Excel 2010 and Win 7 - changes links from network to local user location

  Mary123 23 Aug 12
Locked

Anyone had problems with links in a spreadsheet spontaniously changing from a network location to the users local profile? For example, C:\user\mban\appdata\roaming\microsoft\excel\xlstart? It's driving me nuts!! I've upgraded to Win7 and Excel 2010 and this has never happened in the 15 years that I've been linking spreadsheets with any other OS or previous versions of Excel. It seems to happen, mainly, when another user logs in and opens the file. I've tried using the UNC path rather than the drive letter. I've also tried making all the linked cells hyperlinks. The master spreadsheet was created in Excel 2010 so no compatibility problem. Any help would be much appreciated. Thanks

  lotvic 24 Aug 12

I would hazard a wild guess that links are in some way 'auto updating' when another user opens the files.

These are all I could find clickhereExcelforum.com and also ClickHere social.technet.microsoft.com that have anything like a solution/workaround.

Advertisement

This thread is now locked and can not be replied to.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

IKinema aims to banish droopy shoulders and wonky spines in animated CG characters

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message