Sunday, August 2, 2009

Is there a simple way to find hard-coded cells in a spreadsheet of cells using formulas?

We put together large budgets with many sheets of information and many rows and columns of formulas in each sheet. The budget is handed off to the customer and the customer returns them. However, many times the customer with adjust the budget by hard-coding numbers where formulas used to be. We have no easy way to determine of the hundreds of cells with formulas, which ones were changed to hard numbers. If you have a spreadsheet full of numbers with some formulas and some hard-coded numbers, is there an easier way to tell which is which other than looking at them one by one?

Is there a simple way to find hard-coded cells in a spreadsheet of cells using formulas?
use formula auditing, it will tell you
Reply:*******.
Reply:Formula evaluator. You can see the various parts of a nested formula evaluated in the order the formula is calculated by using a simple dialog box on the Formula Auditing toolbar.


No comments:

Post a Comment