excel links

[BINZA@]

I have been given an excel file with many formulas and links and possibly
macros. I am wondering if its possible to see all of these displayed so I
can see simply what's going on where its looking for data.

Thanks for any help.

 

[MartinW]

Hi Mark,

You can go to Tools>Options>View Tab and check Formulas
under Window options. This will display all the formulas in the sheet.
You can also click on a cell that contains a formula and go to
Tools>Auditing>Trace Precedents. This will put arrows to the last
cell referenced by a formula, then click on that cell and Trace precedents
again etc. etc. until you reach the source. You can also do the same
with Trace Dependants.

HTH
Martin

 

[BINZA@]

Perfect
Thanks for that.

 

[MartinW]

You're Welcome!!

 

[Earl Kiosterud]

Binza,

There's a shortcut to take it in and out of the formula-display mode Martin told of. Press
Ctrl` (that's the key left of the 1 key, with the ~ in the upper case position). It would
have been useful had they put that shortcut in that Tools dialog, and I think they plan to
do that in 2057.