Got round it by opening the report in design mode, closing the field list and saving again, but rather an odd feature...
You won't be able to see what the macro is doing, but it will run faster.
This example demonstrates how turning off screen updating can make your code run faster.
The example hides every other column on Sheet1, while keeping track of the time it takes to do so.
The first time the example hides the columns, screen updating is turned on; the second time, screen updating is turned off. Hidden = True End If Next c stop Time = Time elapsed Time(i) = (stop Time - start Time) * 24 * 60 * 60 Next i Application.
When you run this example, you can compare the respective running times, which are displayed in the message box. Screen Updating = True For i = 1 To 2 If i = 2 Then Application.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. However, I *can* change the Screen Updating from the immediate window. Screen Updating = False b Global Change Event = True Application. About to go home for the day, but I plan on trying to print Application. So while Screen Updating always is True in debug mode, this is not the issue for me. Sub load Portfolio() Dim i Test As Integer, portfolio Version As String Application. :-) Basically, after all those statements (and between each one) Screen Updating remains "True". Screen Updating = False For i = 1 To 10000 Worksheets("Sheet1"). Screenupdating = False worked perfectly in Excel 2007 until last week, when it remained True however many times I tried to set it to False.The idea is to use the first line near the beginning of your macro, and then use the second line near the end.Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.As a result, of all this selecting and scrolling, the screen flickers whenever your recorded macro is played back. Screen Updating Those that are familiar with VBA code may also be aware of the term Application. Unfortunately those that really need to know about this term (those that can only record macros) are often not aware of it.