Forum Discussion
Problems with formula updating due to move to new computer
Damien,
Thanks very much for your reply. It looks like the easiest thing might be to just edit the source of the files that formula can't find. If I choose Update and then Edit when I open a file with a bad link I am prompted to edit the source for different files. I may just do this.
I'm curious though what you mean by updating the formulas to be more dynamic? A sample formula might refer to a cell in c:\Users\Richard\Excel Data\Personal\Financial\SourceFile.xlxs. How would you make that more dynamic?
Richard
Hi Richard
Apologies, I just re-read your initial post and took cell reference as wanting a relative formula to open and access other workbooks rather than directly referencing the cell content in your open workbook.
As far as I know there's nothing that can do relative cell referencing as Excel changes the path into a full path when you close the source file that you are referencing.
If you happen to have a number of adjacent cells from another workbook, you could fix up the first cells connection and then remove the $ from the column/row as needed, and then autofill the formula to fill in the other cells.
I have also found that if you maintain the folder structure (e.g. Financials and all sub folders where your Excel files are stored) that when you open your workbook it will prompt you to update the links which should realign the links to the correct location (at least that's been my experience).
Hopefully it won't be too painful to do.
Best wishes for your task ahead!
Cheers
Damien