dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
388
share rss forum feed


Danny_P

@btopenworld.com

[Excel] Excel links break when moved

Hi,

I have a spreadsheet that works fine when I set it up, but then when I move it, the formulas link to a new location ie:

='S:\Purchasing\[Addresses.xlsx]Company Details'!B3

when the workbook is copied to a new location the formula changes to the following:

='S:\P1369 John Lewis, Exeter\8. Purchasing\Purchase Orders\[Addresses.xlsx]Company Details'!B3

Basically its now looking for the Addresses workbook in the new folder.

Is there something I am doing wrong? As currently to sort this out I have to update links to manually correct it to the original file?

Thanks in advance

Dan


Kilroy
Premium,MVM
join:2002-11-21
Saint Paul, MN
Sounds like you need them to be absolute links. You can do it for cells by pressing F4, it changes from A2 to $A$2, this indicates that it will always use A2, so if you copy from A3 to B3 it will still use A2.

Don't know how to do this for a file location, but would assume there is a way. Just trying to point you in the right direction.
--
“Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.” ¯ Robert A. Heinlein


H2OuUp2
Happy to be here
Premium
join:2002-03-15
Oklahoma City, OK
reply to Danny_P
You can't just move the file and then open it. You have to do a File Save As so it will remember where the link is at.
--
He is no fool who gives up what he cannot keep, to gain what he cannot lose. - Jim Elliot