quick suggestion - another excel sheet that word connects to.
xlspadlocked sheet with macros exports data to that holding file.
the holding file doesn’t even have to be an excel file, you could export to TXT file or CSV.
just a thought…!
brgds
MDW
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...
Hi this is not a question, more of a helpful tip.
We have a system distributed by secure USB flash drive with a password.
The file is a series of pivot tables storing a large amount of data (over 90k in size)
We found one of our users impatiently clicking on the button after feeding her...