You can click TOOLS on the menu, click the VIEW tab and under VIEW OPTIONS
click the FORMULAS check box.

Or you can select the cells in the worksheet and the press Ctrl + F to open
the FIND dialog box. For the text to locate enter =[, verify that LOOK IN is
set to FORMULAS and then click the FIND all button. It will produce a list
of all cell containing linked formulas. Double clicking an item in the list
will activate the cell containing the formula

--
Kevin Backmann


"juliejg1" wrote:

I have been handed over about 15 spreadsheets. Many of them have cell
formulas refering to different spreadsheets/workbooks. Is there a way to see
where each is referencing without going into each cell and reading the
formulas?