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
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