Hi there,
I have a couple spreadsheets that have formulas linked to other workbooks.
Upon opening these workbooks I seem to receive a #REF! error on the formulas with these links. I.e VLOOKUP($B110,#REF!,MATCH($P$2,#REF!,0),0) - #REF! being the link to the other spreadsheet....
I.e one workbooks shows budget number and another shows actual's - when trying to bring the actual's into the budget spreadsheet I receive the #REF! error.
Any ideas to prevent this happening and having to revise the formulas each time I open the workbooks?
B
Bookmarks