MicrosoftI can see use cases for this feature but it's fundamentally flawed for our default use of Microsoft Excel - i.e. we included data tables in models for scenario analysis then use Partial calculation by default to prevent them calculating every time an assumption is changed - which is very slow with data tables on.
In this use case, even when the model is set to the base case and all numbers in the spreadsheet are correct after updating an assumption, they still display as stale with strikethrough formatting, causing massive confusion for users who are reporting it to us as a bug.
Based on this, I cannot see us ever being able to use stale value formatting, so we'll need to turn it off on an application level by default.
JoeMcDaid can you please confirm that it is possible to turn off this feature by default, so that by default workbooks do not open with it turned on. Also, can this be done using VBA, on either a workbook or application level?
Personally, I think this feature should be turned off for all workbooks by default, as users who decide to turn it on (who I believe will be in the minority) can easily do so on a workbook-specific basis.
Most users will either leave calculation set to Automatic, in which case the feature is not relevant anyway. And those sophisticated enough to change their workbook calculation method to Partial or Manual will at that time be able to see the Stale Value Formatting option in the Calculation menu and decide what they'd like to do.
Turning it on by default is very presumptuous and confusing. We've already have dozens of inquiries about it from confused users...
Please advise, thanks.
Michael
