Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel document linking broken due to new documents path in Win7

15 Sep 2011   #1
ramsal

64bit Win7 Enterprise
 
 
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 System SpecsSystem Spec
.
15 Sep 2011   #2
Barman58

Windows 10 Pro x64 x2 Windows 10 Enterprise x64, Ubuntu
 
 

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 System SpecsSystem Spec
15 Sep 2011   #3
CreepinJesus

Windows 7 Ultimate x64
 
 

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 System SpecsSystem Spec
.

Reply

 Excel document linking broken due to new documents path in Win7




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Linking My Documents to another drive
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...
General Discussion
Excel Recent Document not opening from Recent Documents
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...
Microsoft Office
full path to My document and Desktop...
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...
General Discussion
Trying to Find Document Path
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,
Microsoft Office
Access to the path 'C:\Documents and Settings' is denied - Win7-32 Bit
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....
General Discussion
broken path all shortcut
helo everybody.. i have a problem that all my icon window seven have broken path include control panel icon..can u all help me how to fix and repair the path shortcut..all shortcut only can open with 1 program..its cannot by their program self..helppss:cry:...
BSOD Help and Support


Our Sites

Site Links

About Us

Find 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 19:33.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App