Excel Linked Cells

[jrgutt]

We have a number of excel spreadsheets which contain links to other spreadsheets. In the future, we are planning on changing our directory structure which will cause problems for the cells that contain links to other spreadsheets. Is there a simple way to identify the cells which have links in them, the link itself, and a someway to change the links without having to change every linked cell in every spreadsheet?

 

[Chris Davison]

if it were me, with 10 files, I'd open them all up then save them to the new directory.... all the links would change automatically.

My guess is you have a lot more than 10 though, right ?

 

[RET79]

Why dont you put the file path being linked to in A2 say, like

C:MyFile2001myfile.xls

then, use indirect function to link.

For instance

=INDIRECT(A2,T65)

I think would pick out T65 from C:MyFile2001myfile.xls
which is in A2.

So next year, just put the new path in A2, and your whole spreadsheet will be updated.

RET79

 

[RET79]

I think what I am describing is parameterising file names.

It's very effective, and rigid. Changing one cell with the file path updates the whole sheet or book.

wicked

RET79