PDA

View Full Version : Excel formula linked to another page


haynes
Apr 30, 2010, 11:47 AM
I have a formula in an excel spreadsheet linked to a spreadsheet in another workbook... now I can't remember where I saved that other workbook, is there a way to find it?

JBeaucaire
Apr 30, 2010, 06:47 PM
Look in the cell with the references, it should show the complete path to the file:

='C:\Documents and Settings\Jerry\My Documents\Excel Tips\[AAG Log.xls]Sheet1'!$A$1


Another way to find it is to click on Edit > Links, click on Source filename and click on Open Source.