Difference between revisions of "Upgrading Excel"
(Created page with "When opening a workbook in a newer Excel version all formulae in the workbook will be recalculated. This is not an XLCubed behaviour, it is something Excel does automatially...") |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
When opening a workbook in a newer Excel version all formulae in the workbook will be recalculated. | When opening a workbook in a newer Excel version all formulae in the workbook will be recalculated. | ||
| − | This is not an | + | This is not an FluenceXL behaviour, it is something Excel does automatially and the add-in has no control over. It applies to all formulae, not just FluenceXL formulae. |
| − | You may have to recalculate the workbook to get the values | + | This can leave some cells in the "working..." state. You may have to recalculate the workbook to get the values returned, Ctrl+Alt+F9 will usually resolve all the cells. |
This recalculation only applies when opening a workbook saved in an older version of Excel. If users save the workbook in the upgraded Excel version then it will not recalculate next time it is opened. | This recalculation only applies when opening a workbook saved in an older version of Excel. If users save the workbook in the upgraded Excel version then it will not recalculate next time it is opened. | ||
Latest revision as of 09:33, 4 July 2023
When opening a workbook in a newer Excel version all formulae in the workbook will be recalculated.
This is not an FluenceXL behaviour, it is something Excel does automatially and the add-in has no control over. It applies to all formulae, not just FluenceXL formulae.
This can leave some cells in the "working..." state. You may have to recalculate the workbook to get the values returned, Ctrl+Alt+F9 will usually resolve all the cells.
This recalculation only applies when opening a workbook saved in an older version of Excel. If users save the workbook in the upgraded Excel version then it will not recalculate next time it is opened.
