Forum Discussion
Excel Macro Runs *PAINFULLY* Slow
I have an issue running an Excel Macro. I have read a lot of threads and tried all of the suggestions but no change in performance. I have run the same file/macro on 2 machines, details below. No mat...
32 bits or 64 Bits either for Windows and Office?
VBA codes from an older Excel version or other third‐party Active Xs, you could encounter all sorts of problems. This is because many Excel add‐ons are 32‐bit versions that are not fully compatible with the 64‐bit Excel.
VBA codes from an older Excel version or other third‐party Active Xs, you could encounter all sorts of problems. This is because many Excel add‐ons are 32‐bit versions that are not fully compatible with the 64‐bit Excel.
Thanks for your response! My older machine has always been a 64-bit OS and Office 365 packages with an iteration speed of 11 seconds. My new machine was a 64-bit OS and 32-bit Office 365 package, but I have since uninstalled the 32-bit package and installed the 64-bit version. In both situations, the iteration time was the same (24 seconds). Both Office 365 installations are 16.0.
I have not checked Active X installations but I will do that tonight.
I have not checked Active X installations but I will do that tonight.
- you are right Macros do run slower in general. usually you cant see what the Macro is doing. Now it seems you can pretty much watch it go play by play.
- So far, everyone has missed the point. The. Same. Macro.. running the. Same. Data.. on the. Same. OS. BUILD.. (i.e. Windows and Office 64-bit) runnings much, much, *MUCH* slower on the newer machine that is far superior in all regards.
I’m not looking for advice on how to run the macro more efficiently or alternative methods to macros, I’m looking for help to speed up my machine the should have run far faster out of the box.Hershner04You are not alone. I have the same situation and I am fed up with Microsoft making excuses for things like this. The macro I am having the problem with has nothing but simple copy statements between cells on one sheet and cells on another, along with some formatting. With Excel 365 is is managing to copy around 1 cell per second. Can somebody please explain how that can possibly be bad code on my part.
