Excel document linking broken due to new documents path in Win7


  1. ramsal
    Posts : 1
    64bit Win7 Enterprise
       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.
      My Computer
    Quote Quote

  3. Barman58
    Posts : 31,249
    Windows 11 Pro x64 [Latest Release and Release Preview]
       New #2

    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
      My Computers
    Quote Quote

  4. CreepinJesus
    Posts : 370
    Windows 7 Ultimate x64
       New #3

    First off, don't use absolute paths :P

    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
      My Computer
    Quote Quote

 

  Related Discussions
I'm tidying someone else's well-used laptop running Win 7. The HDD is partitioned with all the Documents and Pictures stored in folders "D:\username\My Documents" and "D:\username\My Pictures". There's no stored music or video. To avoid confusing the owner I need to point "Library\Documents\My...
When I go to the top left "Office Button" in Excel and go to my Recent Documents I can open most files, but there's one which does not open. I can open it by going to Open and finding it in my folders or directly from my Windows Explorer files, so the file is not a problem. I've tried opening it...
Hi. I want to know the full path to documents and desktop in windows 7, and I want to full path for all users. the problem is when I look in my c:\users\public there is no documents nor is there a desktop folder. I don't want to specify a user's name to a path since my application (.exe) can and...
Trying to Find Document Path
in Microsoft Office

I have MS Office 2003. I have looked in the Options trying to find where I can change my path to my documents, it is incorrect since I moved them. I felt sure it was there but I can't find it. Where should they be? Thanks,
Dear All, I am installing a software which was used in my old OS : XP. But when I am trying to install it in new machine (Windows-7 32 bit). It is showing "Access to the path 'C:\Documents and Settings' is denied." message in middle of installation. I tried below solutions : 1....
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 10:05.
Find Us