User Profile
CliveW85
Copper Contributor
Joined Feb 17, 2022
User Widgets
Recent Discussions
Re: Excel Macro Runs *PAINFULLY* Slow
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.19KViews3likes8Comments
Recent Blog Articles
No content to show