Linked Spreadsheets

M

Mike H.

I would like to have "relative" links instead of "absolute" ones so that if I
am in c:\Dir1\ and have File1.xlsx which has links to file2.xlsx it would
look to file2 in dir1.

Then in c:\Dir2 I also have file1 and file2 and those files are actually
just a copy of the file1 and file2 that are in Dir1. But the links were
refer to their local, "home" path.

The only way I know to do this is to edit links and change source. Is there
another way? I hope, I hope!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top