How to Clear the Cache in Excel & Google Sheets - Automate Excel (2024)

See all How-To Articles

Last updated on February 28, 2023

This tutorial demonstrates how to clear the cache in Excel and Google Sheets.

Clear Cache in Excel

If you have a problem with editing a document or Excel is taking too long to load, you should try clearing the cache.

1. In the Ribbon, select File > Options.

2. Scroll down to the bottom of the Save window and then in the (1) Cache Settings, click (2) Delete cached files.

3. In the pop-up window, select Delete Cached Files.

4. The cache will be cleared. Click OK to close the Excel Options window.

Clear Cache in Google Sheets

1. To clear the cache in Google Sheets, first open Google Sheets.

2. Click on the View site information icon (padlock icon) in the address bar.

3. From the drop-down menu, choose Site settings.

4. In the Settings window, choose Privacy and security from the left-side menu. Under the Usage section, select Clear data.

5. A pop-up message appears asking for your confirmation. Click Clear.

As a result, the Google Sheets cache is cleared.