Forum Discussion
Shift+F9 is now cleaning dirty cells (after an update from version 2305 to 2308)
Just to update on this, we have confirmed (via Microsoft Premier Support) that this is indeed a deliberate change to the Shift+F9 behavior. We'll have to consider our options for users relying on the old behavior.
I guess Charles should eventually update the decisionmodels page, and also this one:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calculation-performance#calculating-workbooks-worksheets-and-ranges
- If anyone from the Excel team could at least confirm if the change was intentional or not it would be much appreciated. We have affected users who have been relying on the old behavior. Please feel free to message me directly. Thanks.
Just to update on this, we have confirmed (via Microsoft Premier Support) that this is indeed a deliberate change to the Shift+F9 behavior. We'll have to consider our options for users relying on the old behavior.
I guess Charles should eventually update the decisionmodels page, and also this one:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calculation-performance#calculating-workbooks-worksheets-and-rangesI think this is a bug - looks like off-sheet dependencies do not get dirtied when they should.
- Thanks Jan, will do.
