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.