How to clear query cache of Microsoft Excel?
Modified on: Tue, 14 Jul, 2020 at 8: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.
Did you find it helpful?
Can you please tell us how we can improve this article?