+ Reply to Thread
Results 1 to 3 of 3

Excel 2016 screen flashing between two workbooks despite screen updating turned off

  1. #1
    Forum Contributor
    Join Date
    04-13-2006
    Location
    London
    Posts
    102

    Question Excel 2016 screen flashing between two workbooks despite screen updating turned off

    Hi,

    I have a macro written in Excel 2010. It opens another workbook and copies data between the two in a loop - it does this about 40 times in the background.

    On Excel 2010, I disable screen updating just before running the loop, then switch it back on afterwards. This all works absolutely fine.

    Some of my staff have now upgraded to Excel 2016. When the same code runs on their PC, the screen updating disabling doesn't work. It flashes between the two workbooks and takes about 4 times as long to finish the loop. I haven't used Excel 2016 much at all, so does Excel 2016 handle the opening of workbooks differently? What am I missing here?

    Thanks for your help in advance.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel 2016 screen flashing between two workbooks despite screen updating turned off

    I see complaints about this all over the Google. Sorry.

    One suggestion is for procedures that use Global variables. This may be causing the ScreenUpdating to get set back to TRUE, watch for uses of Global variables and set ScreenUpdating=False again. Shot in the dark.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    273

    Re: Excel 2016 screen flashing between two workbooks despite screen updating turned off

    You might try hiding one of the workbooks. You can still copy data between hidden workbooks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2016 - Chart displays on screen but prints blank page
    By ahartman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-15-2016, 06:10 AM
  2. Excel 2016 Touch Screen
    By ftsc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2016, 01:13 PM
  3. [SOLVED] Why does my screen update with images even though i have screenupdating turned off
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-22-2014, 01:08 PM
  4. Replies: 4
    Last Post: 01-23-2014, 07:05 AM
  5. Stopping the Screen Updating Flashing
    By ACM2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2011, 05:51 AM
  6. [SOLVED] Screen flashing why?
    By Chet in forum Excel General
    Replies: 1
    Last Post: 05-16-2006, 03:30 PM
  7. flashing screen
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1