To change the recorded macro so that the query runs in the background, edit the macro in the Visual Basic Editor.
Change the refresh method for the Query Table object from Background Query := False to Background Query := True.
This check box is under the Pivot Table Data section on the Data tab of the Pivot Table Options dialog box.
For information about editing macros, see Visual Basic for Applications Help.
When I check on numerous different blogs and news sites, my computer loads the page from cache and presents what was showing when I visited two or three days ago.
I run IE, Firefox and Google Chrome (with no added toolbars or the like) - all of these programs suffer from the same ailment, which would suggest that it's not an issue with an individual browser.
Some recent history with my computer - about a month ago, I got a virus and had to format my hard drive and reinstall Windows Vista.
Every once and a while after I visit a website (such as and NASDAQ.com) when I go back to it old information comes up on the website. The only thing that solves the problem is running defrag, but only temporarily, as soon the issue will reoccur. The fact that defragging has an impact is completely mysterious.
For instance, I went to a week ago and now every time I go the scores, news stories, stats, etc. Certain pieces of info on the website are current and sometimes clicking a link will bring up current info, but most is old. Let's look at what happens under the hood, what steps we would normally take to clear it up, and then make some guesses as to what else you might try.
You can refresh the data connected to an external data source in an Excel workbook.
This data source can be a cell range, Excel table, Pivot Table report, Pivot Chart report, text file, or Web query.
This problem was occurring even back then with a couple of (extremely high traffic) news sites and aggregators.
After I reinstalled Vista, I assumed the issue would go away.
Store the passwords that you write down in a secure place away from the information that they help protect.