I have included code below. When I create a PivotTable using VBA and keep the saved data with the pivot table, it slows the performance of the sheet to a crawl unless I save, close, and reopen the sheet. This is unacceptable for a "Business Class" Spreadsheet. Thus I put the .savedata = False line into my macro. This makes the sheet perform as expected after running the macro, but now while running, the Field List pops up when the .savedata line is run (I have tested this, when commented out, the macro runs without seeing the Field List at all).

Also, the lines

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
Application.DisplayStatusBar = False
Application.DisplayAlerts = False

are run immediately before this subroutine is called, so those haven't been missed.

Any ideas on how to leave the .savedata line in the macro but not see the Field List pop up when running.

Please Login or Register  to view this content.