Hi,
Don’t actually have any tips for improving, but want to share my experience with using xlspadlock with large files.
We distribute a series of Excel systems with VBA macros for navigation and multiple sheets (between 10 - 75), all working on Pivot Tables from a very large SQL database.
The...