Formula check

[Guest]

I have a big input sheet with data that feeds a 50MB excel file. Since I have changed a lot of the formulas during a model update I want to check if there are any cells in the input sheet that are not linked to anything anymore. Since the sheet is very big is there any way to ckeck for any cell not linked by checking the whole sheet instead of doing the trace dpendents function cell after cell?
Thanks. Neda

 

[Dave Peterson]

If your input worksheet was called: Input
Maybe you could just search the other worksheets for input!

You might get a few false hits:

=if(a1="","Please check your input!","")

But it might be worth it.

In xl2k and later, you can select all your worksheets and edit|find.

In xl97, it's one sheet at a time.

But in any version, you could use Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/

===
And if you want to check for links to external files:
Get a copy of Bill Manville's FindLink program:
http://www.bmsltd.ie/MVP/Default.htm

========

And maybe this'll work -- against a copy of your workbook!

rightclick on the input sheet and select "move or copy"
Move it to a new workbook.
Now look at Edit|links and see if you point at your new workbook.

===
I think if you save both those test workbooks, you could use Bill Manville's
Findlink program very nicely.