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.