This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am running Excel 2016 32bit on Windows 10 64bit.
I have noticed that macros execute significantly faster on a VM box running Windows 7 32 bit and Excel 2010 32bit on the same computer.
The VM is on the same box and the Excel 2016. The Excel file I am executing is exactly the same one.
I have turned of all screen updating, calculations, etc...
Just wondering if anyone has seen this performance issue or has any insights into this issue.
Thx.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Unfortunately the code is far too long for this post.
Upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.
Andreas.
Unfortunately the code is far too long for this post. I was hoping to collect some ideas of possible sources to start stub testing with. I turn off the usual performance problems as shown below.
Application.EnableEvents = false
Application.ScreenUpdating = false
Application.Calculation =xlCalculationManual
Application.PrintCommunication=false
I have turned of all screen updating, calculations, etc...
Show us the macro.
Andreas.