I have a workbook that I want to update with price information (Last and Change) on a nightly basis. At 11:30 PM I have a scheduled task that copies the workbook to a staging directory and opens the workbook. In the workbook I have VBA code that runs on Open and, if the workbook is in my specially-named directory, does an Application.CalculateFullRebuild, Application.Save, and Application.Quit. This should cause updating with market close data, since we are many hours after the market close. It did not seem to be getting proper values last week. The following morning, before the market opened, if I did a Settings->Clear Cache and then the CalculateFullRebuild if seemed to get the correct data. Is there a problem with the caching? It would seem that this should work. How would you suggest I accomplish this so that it works reliably in an automated fashion?