| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
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...") |
|||
| Line 3: | Line 3: | ||
This is not an XLCubed behaviour, it is something Excel does automatially and the add-in has no control over. It applies to all formulae, not just XLCubed formulae. | This is not an XLCubed behaviour, it is something Excel does automatially and the add-in has no control over. It applies to all formulae, not just XLCubed 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 16:17, 31 January 2019
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 and the add-in has no control over. It applies to all formulae, not just XLCubed 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.
