Forum Discussion

Hershner04's avatar
Hershner04
Copper Contributor
Sep 22, 2021

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...
excel
Macros and VBA
office 365
CliveW85's avatar
CliveW85
Copper Contributor
Feb 17, 2022

I have been experiencing the same issue with 2 machines which have been updated recently. However I think I may have found a fix, it certainly worked for me, making the macros (simple file read, extract and write to table tasks) run just like before.
I opened XL, went to the Developer tab ... Macro Security... Trusted Locations.
I then added the directory of the XL file with the macro.
Closed XL and then opened the file with the macro and it ran as fast as it used to "back in the day" 🙂
Hope that helps someone.

  • Steve_Pigsoft's avatar
    Steve_Pigsoft
    Copper Contributor
    Feb 17, 2022

    Brilliant! Thanks very much for this.

    As you suggested - Add the directories of the Excel file(s) with the macro(s) within to Excel's Trusted Locations, and the macros then run at a good speed once more, AND exiting from Excel after running the macros is restored to being swift, too.

     

    Presumably, before recent updates of Microsoft 365, listing Trusted Locations was not an essential requirement for running Excel Macros at a reasonable speed, and now it is -

     

    Case closed for me. Thank you CliveW85 for this fix.

    • Mabandl1's avatar
      Mabandl1
      Copper Contributor
      Jul 20, 2023
      What if the files are stored on SharePoint?
    • px03afk's avatar
      px03afk
      Copper Contributor
      Feb 17, 2022

      If the solution is a simple as that, why haven't MS technicians not been able to fix it instead of blaming the problem on poor coding!!

Resources