How to clear query cache of Microsoft Excel?

Modified on Tue, 14 Jul 2020 at 08:27 AM

Step 1: In Microsoft Excel, Go to Data menu and select Get Data > Query Options

Step 2: Click on Data Load option.

Step 3: Next click on "Clear Cache" button under the "Data Cache Management Options". Press OK.

Step 4: Once cleared the cache, make sure the "Currently used" value is 0 bytes like the below screenshot.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article