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
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

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


Mary123

Likes # 0

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

Like this post
lotvic

Likes # 0

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.

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

The 30 best TV shows on Netflix UK: Our pick of the best programmes you can watch right now

IDG UK Sites

Nostalgia time: Top 10 best selling mobile phones in history

IDG UK Sites

VFX Emmy: Game of Thrones work garners gong for Rodeo FX

IDG UK Sites

Apple 13-inch MacBook Pro with Retina review (2.6GHz, 128GB, mid-2014)