Excel 2016 turn off screenupdating

[journaling], [speech], [ext], [insert], [lastcell], [addins], [slowmacros], [speedup VBA], [recalculation], [openclose], [calc], [1-2-3], [memory], [leakage], [GDI], [objects], [pagesetup], [swapfiles], [VBE], [files], [elimxused], [defrag], [formats], [likeformats], [volatile], [checklist], [slowxp], [moreitems], [grayed], [temp], [timer], [reg], [related], [startup], [warnings], [search], [mskb], [slow], [updatesites], You are probably visiting this page because you were referred to it by someone in a newsgroup.

Because of the nature of such problems, it is important to provide feedback when you solve your problem by replying back to the thread so that others can be helped and so that pages such as this can show relevant information.

excel 2016 turn off screenupdating-45

Example using XL2000, my 2.16MB file was saved as a 3.85MB file and took 45 seconds to save first time with Save As, and over one minute with subsequent Save.

The save time for this large file as a normal XL2000 file is 10 seconds. If you are saving as Microsoft Excel 97-2000 & 5.0/95 Workbook *you will see the following Microsoft Excel 5.0/7.0 saving on your status bar where you normally see Ready toward the end of the save then you are saving in multiple formats.

If the file is accessed only in one version, you don’t want to use this feature.

Save As a normal *file to eliminate the feature from your file.

A bad HP print driver install caused intermitent print problems and following an uninstall that had mapped but not removed a z: drive.

Last modified 27-Nov-2014 15:35