Paul has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course
Migration of linked spreadseets within a drive
A folder containing multiple linked spreadsheets has been renamed and moved to a new folder location (on the same drive). Some of the links have automatically updated to the new location and are functioning normally (the majority, fortunately). Some links show the data being taken from the old location, even though there is no folder at that location any more - and curiously the values remain correct, rather than showing '#REF#'. Any idea please why this latter issue is occuring, and can I rely on the data associated woith these links remaining stable? Note I have chnaged the path of some of the problem links so they are correctly picking up data form the new location, but for some links doing this dies result in a '#REF#' outcome.
RE: Migration of linked spreadseets within a drive
Hello Paul,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding the migration of files containing links.
Excel has always given problems when handling files containing links. Links can be broken in a number of ways:
Moving a file or folder
Renaming a file or folder
Deleting a source file or folder
Changing source file data so that the linked cell is no longer there, and so on...
When editing the links it is usually sufficient to re-establish the link using the Change Source option. This does not always provide a solution that works and you are left the task of re-creating the links from scratch. Hopefully, in your case, this won't take such a long time.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
