Use relative links between sheets restricted to a single workspace

B_Bernard_D

Hi,

I have 1 sheet (sheet1) that takes a value into another one (sheet2). I would like the link between both to be relative and restricted to a single workspace so when I copy both in a new workspace (w2), they remain linked to each other but can't access original workspace (w1). Result would be sheet1w2 linked to sheet2w2

Curently, it is doing sheet1w2 linked to sheet2w1

Thanks a lot

SSFeatures

Hi @B_Bernard_D,

If you are trying to copy each sheet individually and move them into a new workspace then the links will be absolute instead of relative.

However, if you duplicate the entire workspace or folder then the new copied sheets will be relative to each other.

Is it possible for you to put sheet1 and sheet2 into their own workspace, and then copy that workspace whenever you want to copy the sheets?

Best!