XCELLERATOR FORMULA IN DATA RANGE

Duration (m:ss):

1:05

Description
This video demonstration will show you how to use Incisive Xcellerator to find formulas that are in areas that are mostly data. These obviously important cells will likely be accidentally overridden when new data is input into the spreadsheet.

Formula in Data Range

Open your spreadsheet and click on ‘Start Xcellerator’ in the Incisive tab.
WIn this example, one of the numbers in the data range is in fact a formula.
The error that will be identified is ‘Formula in data range’
To fix this, we will want to separate the data and formulas so that the data and formulas are in different columns.
In this case, we can drag the formula into the correct column so that if the data were replaced, the formula would not be adjusted.
Rescan to find that the error has been corrected.

Transcript

In this demonstration, I’d like to show you how you can use Xcellerator to find formulas that are embedded in areas that are mostly data. In this case, we have some data cells, and in this column of data cells, I have embedded a formula. So let’s start Xcellerator. The formula that’s in this data range is identified, the test is ‘Formula in data range’, and we show you the range that we think should probably all be data, and that’s where the formula lives. So in order to fix this kind of thing, we want to separate out the data and the formulas so that you might have a column of data and a column of formulas here, and then you put your formulas in this location. In this case, we could drag this one over, so that if someone were to replace all of this data, they wouldn’t be replacing your formula that you had just figured out. Now when we rescan, we’ll have no more formula in a data range results.

XCELLERATOR FORMULA IN DATA RANGE

Content Requires Flash Player