Upgraded from 2007 to 365 and my VBA runs much, much slower.

[d0rian]

I finally got around to upgrading from ver. 2007 to 365 as I know 2007 is no longer supported by MS and I've been told that there have been a ton of feature and performance improvements besides.

But my working .xlsm file, particularly the macros, are incredibly laggy. Yes it's a large file (17MB) that pulls in real-time data for hundreds of stock symbols and runs a bunch of calculations and conditional formatting in the background, but performance in 2007 was at least alright, whereas it's borderline unusable when opened in the new 365 Excel. Just one example: I have a simple listbox and a mouse macro to cycle through the ~20 listbox items...it took approx 1/4 of a second to cycle to the next listbox item with a mouse click in 2007. It's closer to 1.25s (5x slower) in 365.

Was alarmed that performance was so much worse in a 12-year newer version...

• Is this a known performance issue...? Like, is there something about how 365 handles calculations or VBA or conditional formatting that's dramatically different than in previous versions?
• What options can I toggle in 365 in hopes of either improvement performance or at least troubleshooting? So far, I've:
  1. Options...Ease of Access...Unchecked "Provide Feedback with Animation", since I found the default "glide" / animation effect annoying
  2. Options...Advanced...Checked "DIsable Hardware Graphics Acceleration", since online reading suggested that disabling it could improve performance but I didn't notice anything.
• Tried the 32-bit version of 365 since I'd read that might help even if your system is 64-bit...performance seems the same to me :/
• Something I wondered: would recreating this file as a native 365 file starting with a blank 365 .xlsm workbook result in better performance? IOW, I created this starting from a blank 2007 Workbook, and while obviously 365 is backwards compatible with .xlsm files created in previous versions, is there something about a native-to-365 .xlsm file that would, for some reason, result in better performance?

EDITING post at request of an admin because I made a similar post on a different forum, but received no help, which is why I came here hoping for some from the sleuths on this forum.

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[d0rian]

Edited my OP at the request of an Admin who asked that I follow forum rules and link to the cross-post on another forum (where I didn't get any help, which is what brought me here
I'm really frustrated, as having used my file with the 365 installation for a little more time, it's not just laggy, but actually downright unusable in 365...

[d0rian]

Last bump, hoping for some guidance. Given my own research -- and finding that this seems to be a widely-reported problem -- I thought that there'd be smart folks with some experience with this performance issue, or tips to try and troubleshoot