Excel 2013 Application.ScreenUpdating Multiple Workbooks

We are noticing an odd behavior with Application.ScreenUpdating in Excel 2013 as it pertains to multiple workbook scenarios.

With Application.ScreenUpdating = False, performing actions on other non-active workbooks causes Excel to "focus" the target workbook resulting in a momentary screen flash.

For example, if Book1 is active and we attempt to set visibility on Sheet1 of Book2, the screen will flash as Book2 is focused and the visibility method executed.  Afterwards, focus is returned to Book1.

This happens on other operations as well - such as protect, unprotect, etc.

It appears to us, that with the introduction of SDI in Excel 2013, ScreenUpdating is not completely disabling all screen updates as it has with previous Excel releases.

Any help would be really appreciated.

Thanks!

November 8th, 2013 10:49am

You should turn ON ScreenUpdating  after your code is running.

with applications
   .ScreenUpdating  = false
    'your code....
   .ScreenUpdating = true
end with

The same with .EnableEvents and take look for .Calculations swithes.
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2013 12:09pm

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

November 11th, 2013 4:17pm

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

Free Windows Admin Tool Kit Click here and download it now
November 11th, 2013 4:17pm

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

November 11th, 2013 4:17pm

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

Free Windows Admin Tool Kit Click here and download it now
November 11th, 2013 4:17pm

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

November 11th, 2013 4:17pm

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Free Windows Admin Tool Kit Click here and download it now
November 13th, 2013 4:43am

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

November 13th, 2013 4:43am

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Free Windows Admin Tool Kit Click here and download it now
November 13th, 2013 4:43am

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

November 13th, 2013 4:43am

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Free Windows Admin Tool Kit Click here and download it now
November 13th, 2013 4:43am

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

November 13th, 2013 4:43am

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Free Windows Admin Tool Kit Click here and download it now
November 17th, 2013 8:09pm

Hi,

I'm marking the reply as answer as there has been no update for a couple of days.

If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

November 20th, 2013 11:54pm

Just to confirm the problem, I'm finding the same thing.  On a client's computer, the file window itself flashes and blanks as different workbooks are touched by VBA.  And on my computer (Win 7 and Excel 2013), the ribbon does a lot of flashing as I move data from one workbook to another.  It seems that "Application.ScreenUpdating = False" doesn't apply to the ribbon or taskbar.  (By the way, I'm not using .Select or .Activate; I'm just Setting objects and copying data.)


  • Edited by Dean Meyer Friday, February 21, 2014 4:36 PM
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2014 6:57pm

Just to confirm the problem, I'm finding the same thing.  On a client's computer, the file window itself flashes and blanks as different workbooks are touched by VBA.  And on my computer (Win 7 and Excel 2013), the ribbon does a lot of flashing as I move data from one workbook to another.  It seems that "Application.ScreenUpdating = False" doesn't apply to the ribbon or taskbar.  (By the way, I'm not using .Select or .Activate; I'm just Setting objects and copying data.)


  • Edited by Dean Meyer Friday, February 21, 2014 4:36 PM
February 21st, 2014 6:57pm

Just to confirm the problem, I'm finding the same thing.  On a client's computer, the file window itself flashes and blanks as different workbooks are touched by VBA.  And on my computer (Win 7 and Excel 2013), the ribbon does a lot of flashing as I move data from one workbook to another.  It seems that "Application.ScreenUpdating = False" doesn't apply to the ribbon or taskbar.  (By the way, I'm not using .Select or .Activate; I'm just Setting objects and copying data.)


  • Edited by Dean Meyer Friday, February 21, 2014 4:36 PM
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2014 6:57pm

It may work on Windows 8 and Office 2013, but code which has been running on windows 7 , office 2007 and office 2010 doesn't work. The screen may stop updating but when the macro finishes I have found you aren't left with the approriate sheet on top and excel seems to want to display all sheets that have changed. So teh problem hasn't erally been answered.

April 8th, 2014 12:07am

I also see exactly the same behaviour on my system.

Code is running well on machines running WIN7+Office 2010 but on my
development system with WIN7+Office 2013 the screen flickers at each switch.

And the problem is that a workbook which is opened to serve as a source for a dropdown
field in a userform overlays the userform when opened which doesn't happen with Office 2010.

Im my oppinion this thread isn't answered because the majority of the systems running in offices
are WIN7+Office 2010 and will be switched to WIN7+Office2013.

To have WIN8+Office 2013 which works obviously well will take a while if it ever happens...

So it would be nice to have a solution or a workaround.

Free Windows Admin Tool Kit Click here and download it now
May 20th, 2014 1:40am

...

So it would be nice to have a solution or a worka

September 12th, 2014 12:11pm

...

So it would be nice to have a solution or a worka

Free Windows Admin Tool Kit Click here and download it now
September 12th, 2014 12:11pm

Bump,

Does anyone know how to resolve this behavior?

Windows 7, Office 2013, Excel 2013

A VBA process runs, in my case drawing a chart, and then shows the chart to the user. 

It takes a very long time for the chart to appear. For the remarkably patient, it does finally appear.
I have userform.Show 0 controls that allow the user to modify the chart. After said modification, the screen does not update. Closing the userform, clicking on the chart have no impact.
To get the chart to update, Close the userform, switch to another tab, Then switch back to the original tab. And you can see the changed. 

I have paying clients.
Microsoft, what am I supposed to do, tell them this is a design feature? 

Note: Workaround for some situations, add:

    Application.screenupdating = True
    ActiveSheet.Next.Select
    ActiveSheet.Previous.Select

This does achieve the desired screen refresh. (might want to throw in a doevents in there too)

However in some instances, due to event procedures, this is not valid option.

Please, anyone.... HELP!


September 19th, 2014 1:07pm

Bump,

Does anyone know how to resolve this behavior?

Windows 7, Office 2013, Excel 2013

A VBA process runs, in my case drawing a chart, and then shows the chart to the user. 

It takes a very long time for the chart to appear. For the remarkably patient, it does finally appear.
I have userform.Show 0 controls that allow the user to modify the chart. After said modification, the screen does not update. Closing the userform, clicking on the chart have no impact.
To get the chart to update, Close the userform, switch to another tab, Then switch back to the original tab. And you can see the changed. 

I have paying clients.
Microsoft, what am I supposed to do, tell them this is a design feature? 

Note: Workaround for some situations, add:

    Application.screenupdating = True
    ActiveSheet.Next.Select
    ActiveSheet.Previous.Select

This does achieve the desired screen refresh. (might want to throw in a doevents in there too)

However in some instances, due to event procedures, this is not valid option.

Please, anyone.... HELP!


  • Edited by 0rangeCru5h Friday, September 19, 2014 5:08 PM
Free Windows Admin Tool Kit Click here and download it now
September 19th, 2014 8:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics