Table Of Contents
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:
Get In Touch
Need expert IT assistance? Contact Hamilton Group today! Our specialists offer top-notch solutions tailored to your needs. Don’t let tech troubles hold you back.
Talk to us about your business 0330 043 0069
Or E-mail hello@hgmssp.com and one of our experts will get back to you.
Schedule A Quick Callback
The fastest way to figure out if we’re a good fit for your business is to have a quick chat about it. Schedule a 15-minute call so we can get right to the point.
Proactive, Responsive, Hamilton Group
Grab a drink and let’s have a quick chat about your business, and see how we can help you.
Book your call below or call us on 0330 043 0069.
Carl Hamilton
A Message from our Founder/CEO
“We treat every client as if they were a part of our business to provide quality and comprehensive IT support that can be counted on 24/7, 365 days a year. We succeed only when you succeed.”
Related Posts
Let’s work together
IT Support You Can Trust
The best IT Support in Harrogate is also delivered across the UK 24/7 and we are ready to help you with all your Managed IT service needs. Services are provided in areas including Leeds, Liverpool, Manchester, Wakefield, Wetherby, York, Newcastle, Bradford, Bolton, Glasgow, Wigan, Derby, London, Luton, Birmingham, Sheffield, Peterborough, Portsmouth, Reading, Nottingham, Milton Keynes, Telford, and more.
Talk to us about partnering with an IT Support Company that cares
Move your business forward not back with HG.
Same Day Call-back.
Monday – Friday 09:00 – 17:30.
“Our email wasn’t performing very well so we asked Hamilton Group 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
