New
#1
Excel document linking broken due to new documents path in Win7
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.