Apllication.screenupdating does not work correctly in EXCEL 2016

Tzahi · Dec 22, 2017

[FONT=&quot]Hello,[/FONT]
[FONT=&quot]I wrote macro in excel that work correctly in EXCEL 2010 win 7. [/FONT]
[FONT=&quot]I upgraded to excel 2016 win 10 and "Apllication.screenupdating = false" does not work correctly. I noticed that if I work with a single Excel file, the command work perfectly, faster, and the screen in not flickering.[/FONT]
[FONT=&quot]But, if there are more then one Excel file, then I see the jump from one file to another (the screen is flickering), and because of that, the macro ran slowly, very slowly.[/FONT]
[FONT=&quot]I would like to emphasize that the macro worked fine in excel 2010 win 7.[/FONT]
[FONT=&quot]Do you know what should I do? [/FONT]

mrhstn · Dec 22, 2017

Hi Tzahi

Welcome to the forum.

Can you post your code. It'll significantly reduce the amount of guess work involved in figuring out the problem.

Thanks

Tzahi · Dec 23, 2017

Hi mrhstn
thank you.

Code:

Sub Macro3()
' Macro3 macro
    Application.ScreenUpdating = False
    Dim i, Row1, Value1 As Integer
    Dim NameNode As String
    Windows("Sites.xlsm").Activate
    i = 2
    Do While Cells(i, 1) <> Empty
      NameNode = Cells(2, 3)
      Windows("Metro.xlsx").Activate
      Columns("A:A").Select
      Selection.Find(What:=NameNode, After:=ActiveCell, LookIn:=xlFormulas, _
          LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
          MatchCase:=False, SearchFormat:=False).Activate
      Row1 = ActiveCell.Row
      Value1 = Cells(Row1, 11) + Cells(Row1 + 1, 11)
      Windows("Sites.xlsm").Activate
      Cells(i, 27) = Value1
      i = i + 1
    Loop
End Sub

mole999 · Dec 23, 2017

I would be surprised if there was no flicker under Win 7, switching between a macro enabled and non macro enabled work sheet and selecting a million rows again and again. How much data was it tested against before you took it live in Win 10

Tzahi · Dec 23, 2017

No flicker at all under win 7 excel 2010.

The file size "Metro" (actually Metro.csv) is 9M. less then 100,000 rows and 18 columns.

It's the same file under win 7 excel 2010.[FONT=&quot][/FONT]

mole999 · Dec 23, 2017

probably something to do with Win 10 then, do you still have admin access with UAC depreciated ?

mrhstn · Dec 23, 2017

The Windows 10 Fall Creators Update has some known issues with Office 365, mainly screen flicker. I read about this when I was experiencing cursor flicker just typing in any cell, so it would not be a surprise if this is the issue.

Tzahi · Dec 23, 2017

I'm sorry but I don't understand what "UAC depreciated" means.
I run the macro on the same computer (at work) that I had before upgrading to Windows 10.
And on my computer at home.

mole999 · Dec 23, 2017

> https://en.wikipedia.org/wiki/User_Account_Control ,it was in 7 and has been tightened through the upgrades

Tzahi · Dec 29, 2017

mole999 said:
> https://en.wikipedia.org/wiki/User_Account_Control ,it was in 7 and has been tightened through the upgrades

Hello

My permissions have not changed with win 10, and I don't receive a UAC alert. On a work computer I do not have ADMIN permissions, but on a computer in my home I assume I have all the permission.

Apllication.screenupdating does not work correctly in EXCEL 2016

Tzahi

New Member

Excel Facts

mrhstn

Active Member

Tzahi

New Member

mole999

Well-known Member

Tzahi

New Member

mole999

Well-known Member

mrhstn

Active Member

Tzahi

New Member

mole999

Well-known Member

Tzahi

New Member

Similar threads

Forum statistics

Share this page

Apllication.screenupdating does not work correctly in EXCEL 2016

New Member

Excel Facts

Active Member

New Member

Well-known Member

New Member

Well-known Member

Active Member

New Member

Well-known Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock