Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Files
I have a set of budget files, one which is a consolidation of all the
others, achieved through links. If copy this group of files to a new folder, on some occasions, the file with the links still points to the files in the original location. Other times it works fine. My problem is, I don't know what I am doing right when it works and wrong when it doesn't. If any body can assist, it would be much appreciated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Files
That is because your cell references look like this:
='C:\[file1.xls]Sheet1'!$A$1 C:\ .. This is the path to your files and when you copy them to another location Excel is not aware of that location. You may need to modify your formulas to reflect the new path. I was trying to construct the path in the formula from an input cell but wasn't successful yet. Hans |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Files
Sorry, another way would be to load all the files, the one with the
links and the linked ones. Then do not COPY the LINKED files to a new location but SAVE them to a new location. That way Excel will adapt your formulas on the sheet with the links. The old files will still be at the original locations. In my example I saved it to a folder "funfree" and this is what the formula looks like afterwards: ='C:\funfree\[file1.xls]Sheet1'!$A$1 Seems to be the quickest way. Hans |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Files
Thanks Hans,
I will give that a try. "flummi" wrote in message oups.com... Sorry, another way would be to load all the files, the one with the links and the linked ones. Then do not COPY the LINKED files to a new location but SAVE them to a new location. That way Excel will adapt your formulas on the sheet with the links. The old files will still be at the original locations. In my example I saved it to a folder "funfree" and this is what the formula looks like afterwards: ='C:\funfree\[file1.xls]Sheet1'!$A$1 Seems to be the quickest way. Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking cells from different files -fill down | Excel Discussion (Misc queries) | |||
Linking cells to files in a folder | New Users to Excel | |||
Linking Excel files -- I cannot find an answer anywhere. | Excel Discussion (Misc queries) | |||
linking files with blanks | Excel Discussion (Misc queries) | |||
Linking locked files ...? | New Users to Excel |