After opening my Microsoft Excel document why has Excel updated my sources?
My Excel sheet now shows #Ref what can I do now?
We assume by design as Microsoft was made aware of this behaviour back when Microsoft Office 2010 was popular.
We think that Microsoft does not label this a bug as in a Microsoft KB article the behaviour is explained to help answer why has Excel updated my sources.
In this document Microsoft posts:
Scenarios that may cause links to not work as expected
There are several circumstances in which links between files can be inadvertently made to point to erroneous locations. The following are two of the most common scenarios.
Scenario 1:
You map a drive under the root of a share. For example, you map drive Z to \ServerShareFolder1.
You create links to a workbook that is stored at the mapped location after you open the file through that mapped drive. You open the file by a UNC path. As a consequence, the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to \ServerFolder1. In other words, the Share name is eliminated from the path.
Scenario 2:
You map a drive under the root of a share. For example, you map drive Z to \ServerShareFolder1.
You open the file by a UNC path or a mapped drive mapped to a different folder on the share, such as \ServerShareFolder2. As a consequence, the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to \ServerFolder1.
What Does This Mean and why has Excel updated my sources?
Short-term Fix:
Proactive, Responsive, Hamilton Systems
Grab a drink and let’s have a quick chat about your business, and see how we can help you.
Book your 15 minute call below.
Carl Hamilton
Do you have questions or want to talk?
Move your business forward with HTS.
Same Day Callback Monday – Friday.
“Our email wasn’t performing very well so we asked Hamilton Systems to take a look & Carl proposed to migrate us to MS Exchange.
Carl was very helpful throughout & the migration went very well.
He was on hand to sort out any teething issues, taking calls early morning & into the night, to ensure we were up & running smoothly.
Would recommend for knowledge, attention to detail & great customer service.”
Ian Porter
Fotofabric Limited