Forum Discussion
Excel Macro Runs *PAINFULLY* Slow
Once I added the the file locations as Trusted Locations, I saw a large improvement. I did not see any changes moving them to SharePoint.
Sometimes they still run incredibly slow, and I don't know what the issue is. However, my monster programs have hit a level of maturity where I finally feel comfortable shutting off screen updating and that helps quite a bit as well.
All suggestions about trusted locations and sharepoint are basically valid however the bottom line is that MS did something that slowed VBA and we, the users, shouldn't have to make changes to our VBA code because of changes MS make to Windows. I really get fed up with MS in many areas where users are expected to change things to suite MS when in reality the users should be allowed to change if they want, not be forced to make changes.
