- Joined
- Mar 13, 2011
- Messages
- 2,531
- Reaction score
- 6
- Points
- 38
- Location
- Nanaimo, BC, Canada
- Website
- www.excelguru.ca
- Excel Version(s)
- Excel Office 365 Insider
Just wanted to make sure I didn't miss anything in later versions...
I have two files, let's call them A and B. Inside A there are a bunch of links to B. I now want to make a backup copy of these files so that I can work on them some more, but retain my history. To do this I want to copy them into another folder (call it v2011-05-31), but then the links would be retained to the original folder (call it vCurrent), which defeats the purpose.
Currently the only method I'm aware of to accomplish relative linking (to make that true backup) is as follows:
I know this works, but it's a pain to do. I'm hoping (but not holding my breath) that I just missed the implementation of relative linking in Excel 2007/2010.
Confirmation either way would be appreciated.
PS: Actually, it's not the only way, I guess. I could repoint the links by way of the Data-->Edit Links tab, I suppose, but that's scary if you are linking to a lot of files.
I have two files, let's call them A and B. Inside A there are a bunch of links to B. I now want to make a backup copy of these files so that I can work on them some more, but retain my history. To do this I want to copy them into another folder (call it v2011-05-31), but then the links would be retained to the original folder (call it vCurrent), which defeats the purpose.
Currently the only method I'm aware of to accomplish relative linking (to make that true backup) is as follows:
- Open file A & B in the vCurrent folder (causing the links to lose the file path while Excel is open)
- Do a File-->SaveAs on File B to folder v2011-05-31
- Close File B causing the full path to now show in links in File A
- Do a File-->SaveAs on File A to folder v2011-05-31
I know this works, but it's a pain to do. I'm hoping (but not holding my breath) that I just missed the implementation of relative linking in Excel 2007/2010.
Confirmation either way would be appreciated.
PS: Actually, it's not the only way, I guess. I could repoint the links by way of the Data-->Edit Links tab, I suppose, but that's scary if you are linking to a lot of files.