Skip to main content

Clear Cache

A cache is a temporary storage where the system saves frequently used data to speed up operations. You can delete all formula-related caches accross all open workbooks. This helps free up resources and resolve issues with outdated or stuck calculations. You can only clear the cache if no formula is currently in use.

Clearing the cache does not delete your actual data or sheets. However, always save your work first to avoid losing any unsaved changes.

When to clear cache​

  • Refreshing outdated data: Recalculate formulas to reflect the latest updates from the source data.
  • Improving performance: Remove large or corrupted cache files that may be slowing down workbook operations.
  • Troubleshooting errors: Reset the system to fix loading issues or incorrect formula results.

Clear the cache for all workbooks​

From the ribbon​

  1. On the Analysis tab, in the Cache section, select Clear Cache.
  2. If the cache is available, select Clear to confirm. If the cache is currently in use, select Cancel.

From the toolbar​

  1. In the Toolbar panel to the right, select Clear Cache.
  2. In the confirmation dialog, confirm that you want to clear the cache for all open workbooks.
  3. Select Clear.

After clearing the cache, you can refresh formulas without changing any parameters. To refresh a formula, go to the Analysis tab and select Refresh.

important

If you’re unable to clear the cache or formulas remain stuck, refresh your browser to reset the system. Save your work beforehand—unsaved changes will be lost, and all caches will be deleted.