Excel document linking broken due to new documents path in Win7

[ramsal]

Hi all,

I've recently moved from XP to 7 and realized that due to the change in path to my documents folder any references from one Excel workbook to another no longer work because the reference is to an absolute path and expects the "C:\Document and Settings\..." path rather than "C:\users\..." that Win7 uses.

Having to change each reference in my many spreadsheets manually is just not an option. Are there any tools that could help with this? I've already tried Find & Replace to change the path but the Excel still asks to select the actual file that i'm trying to link to which is still very time consuming.

Thanks in advance of any suggestions.

 

[Barman58]

Win7 employs a virtualization technology, (Symbolic links or junction Points), to cater for this very issue - it should work without modification

I have just set-up a shortcut to C:\Documents and Settings\...... and it works, your post states "document and settings" which is probably a typo but would cause failure

 

[CreepinJesus]

First off, don't use absolute paths

Second, Windows 7 has built-in links for those folders, so if you browse to C:\Documents and Settings\, it should automatically "redirect" to C:\Users.


Edit: beaten