Results 1 to 4 of 4

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

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2015
    Location
    USA
    MS-Off Ver
    2007
    Posts
    19

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

    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.
    Last edited by d0rian; 06-04-2020 at 04:33 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel macro runs slower when invoked from button
    By sujimon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2019, 07:30 AM
  2. Macro in Excel 2016 runs MUCH slower when ANOTHER spreadsheet is open?
    By Ed_Collins in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-17-2017, 06:59 PM
  3. Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-07-2015, 04:25 PM
  4. New to the forum. Just upgraded to 2007 from 2003 and am a little lost
    By rmanoz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-23-2012, 08:02 AM
  5. macro runs much slower in excel 2007
    By hputhraya in forum Excel General
    Replies: 2
    Last Post: 03-25-2010, 03:54 AM
  6. [SOLVED] Embedded Excel macro runs 100X slower
    By JS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-24-2006, 07:20 PM
  7. String manipulation in macro runs slower each time ran.
    By Lamination Technology in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2006, 02:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1