I'm running Longview for Excel queries which pulls data from Longview. There are about 20 columns & about 90,000 records currently in the results. I have office 2013. I'm looking for VBA code that will clear the cache after running the Longview functions (which pulls in data from longview). It seems I need to close the file & re-open it in order to run the vba code to refresh groups of columns with the longview functions. otherwise, I have to create modules to refresh 1 column at a time (then copy/paste as values). This file gets updated regularly & closing/re-opening the file to clear it out is not a realistic option. thank you.