Results 1 to 2 of 2
Thread: Impressed with Excel (XP)
2005-07-22, 07:26 #1
- Join Date
- Aug 2003
- Stroud, United Kingdom
- Thanked 0 Times in 0 Posts
Impressed with Excel (XP)
Hi, just a quick note to say how impressed I have just been with Excel! It's to do with the way it handles links to files.
A spreadsheet that has cells referencing say "K:appsfolder1temp.xls" seems to automatically update itself to "L:appsfolder1temp.xls" when the drive mapping is changed in My Computer.
We are undergoing a move to a new server and mappings ( and perhaps some folder structure) is changing. Had no idea Excel would simply somehow update the mappings! Cool.
I wonder if Excel would handle it if the mapping changed to "L:apps_newfolder1temp.xls"Thanks,
2005-07-22, 07:37 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Impressed with Excel (XP)
The link paths will be updated automatically if the relative position of the source and targe workbooks remains the same.
Say that the workbook with the links is in K:appsexcel, and that the links refer to a workbook in K:appsfolder1.
If you move the former to L:newappstestexcel and the latter to L:newappstestfolder1, the links will be fine.
But if you move the former to L:newappstest and the latter to L:newappstestfolder1, you'll get an error because the relative position of the workbooks has changed.