I have a Pivot Table on a Form in an Access database that is linked to a Query in the same database. It works good, no complaints. However, I want the Pivot Table in the Form to refresh automatically when I open it. I have tried writing an AutoOpen macro to update the Pivot Table in its Excel environment, it doesn't work. Apparently AutoOpen doesn't sense that Excel is opening when its environment is in a PivotTable in an Access Form. I have also tried checking the "Refresh On Open" box in the Pivot Table Options field. That doesn't work either, probably for the same reason as the previous problem. Currently, I have users manually refresh the Pivot Table after opening the Pivot Table Form with the use of a reminder message box and a push button. I'd really like to automate the refresh process, though. Any Excel VBA code wizards out there willing to give an assist? Thanks in advance. Joe

Joe, I am in the same situation. Did you ever find a solution to do this automatically? Right now, I will need the user to do a refresh as well. Note, in Office 2000 this is not a problem. I developed this in 2000. Then pushed it out to the client who uses XP and had the problem. Thanks. me too