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
Feedback sent
We appreciate your effort and will try to fix the article