Difference between revisions of "Upgrading Excel"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| 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. |
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 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.
