i-nth logo
How to check for hard-coded values in Excel formulas?
18 January 2015

Here is a common problem. Imagine you are looking at a complex spreadsheet, aptly titled "Corporate Strategy 2020.xlsx" which has 17 tabs, umpteen formulas and unclean structure. Whoever designed it was in insane hurry.

The workbook has formulas like this:

=SUM(Budget!A2:A30, 3600)+7925

So how do you go about detecting all cells containing formulas with hard-coded values?

Alas, the usual methods fail. To solve this problem, let's build 'Detect hard-coded formulas' feature for Excel.

Full article: How to check for hard-coded values in Excel formulas?