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. 