Add-In function call causes Inconsistent Calculated Formula Error (Green Triangle)

[pizzaboy]

I'm making a call to a public function declared inside a referenced Add-In.

The function works fine, but I'm getting the dreaded green triangle for the all the cells in the column of my table.

The option to "Restore to Calculated Column Formula" or simply re-inputting the formula removes the green triangle, but restarting the Workbook restores them...

Is there a way to correct this without disabling the option in the Error checking options - I rather like to be notified where a cell value in a column is different to the other values.


Any help would be greatly appreciated.

Cheers

 

[joeu2004]

Absolutely a good idea to disable "error" checking. That is a misnomer, IMHO. They are warnings, not "errors". And as you discovered, more often than not, they flag benign intentional design decisions.

However, the detailed navigation instructions might differ from one Excel version to another. The following applies to Excel 2010.

Click Files > Options > Formulas. Deselect "Enable background error checking" by removing the checkmark. Also click Reset Ignored Errors in order to remove all such warnings. Finally, click OK. Then save the workbook.

I believe this options change will apply to all workbooks that opened in the future. However, I believe you will need to click Reset Ignored Errors in order to remove pre-existing warnings. (TBD)

 

[pizzaboy]

Did I miss something?

I was rather wondering if there was a VBA fix. like moving the function somewhere else.

Is there a way to correct this without disabling the option in the Error checking options - I rather like to be notified where a cell value in a column is different to the other values.