98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel links (changing names & moving folders) | Excel forum
Excel links (changing names & moving folders) | Excel forum
Resolved · High Priority · Version Standard
Nick has attended:
Access Introduction course
Excel links (changing names & moving folders)
Losing links when Changing spreasheet names :
I have several spreeadhseets that are linked together - I want to change the name of the spreadsheets however when i do I lose the links between the various spreadsheets - is it possible to change the name of linked spreadhseets without losing the links and having to manually update the links??
Losing links when Moving folders :
Also, it is possible to copy a folder of spreadsheets to another folder, rename the spreadsheets in the new folder and have the links automatically update (I have tried and have the same issue, when I move the spreadsheets the links still point to the original folder and file name)
Thanks
NICK
RE: Excel links (changing names & moving folders)
Hi Nick
Thank you for your question.
I think once a link is set up and something changes (filename or location of file) you will need to fix the link.
Amanda
RE: Excel links (changing names & moving folders)
Hi,
If you have the 'master' spreadsheet open and then open the source worksheet, you can 'file, save as' and save it to your new location and the link in the master will be updated.
If you notice that the links in the master file have not updated.....open a source file and tools, options, calculation and ensure automatic is ticked.
One tick appeared to cure all my lost links!
Good luck
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |