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.

Vik162004's avatar
Vik162004
Copper Contributor
Sep 20, 2022
I had the intuition that is something about the macros security, but I didn't have the idea to include them in the Trusted Location, that's a brilliant solution. You really saved me CliveW85, great idea. Thanks a lot for sharing!

Resources