How it works
Hard-coded numbers function allows you to quickly identify any areas of your workbook with a formula and
numbers typed into the formula.
How to use it:
Step 1
In the Analysing and Sampling group of The Audit Toolbar, within the more drop-down, click on ‘By Weekend’.
A new Pop-up window will be displayed.
Step 2
The Audit Toolbar will create a new Excel document.
This document will list all areas of your workbook that contain any hard-coded numbers. It will also list, in what sheet the problem was found, at what range as well as give you the formula in
question.
The given ranges are hyperlinked to allow you to easily jump back to the problem area.
