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.