I have a problem.
This ones fairly complex, for me anyway ;).
I have a template that is opened (as a copy) and then worked on. A lot of information is entered and calculated as well as imported by way of FORM addins etc. The end result is that the file is SavedAs xyz.xls or whatever name. The file ends up being in the order of 3 to 4 MB in size by the time the project is finished.
The problem is that many people are using the template and saving finished copies which equates to mega memory use.
ie 30 users x 3 projects a day x 3MB = 270MB memory a day x 365 days = 98550MB a year. OUCH !!
Everyone loves the project because it streamlines their work and reduces what used to take 5 days to do down to 2. But the all powerfull IT department have slammed it because of memory use.
But back to the problem, how can I reduce the file size?? I've stripped my code back, I've deleted all unecessary formating, removed unwanted links........etc. and still have a fairly big file.
I was wondering if anyone has ever thought about a way to save just the information that was entered when the workbook template was opened to the point of closing. And then to have it merge or combine with a template when you want to edit etc and again save the information. Essentially so that the template acts like an operating system and you only save the entred data???
This way it would reduce the size of the files dramatically because I'm not saving the whole template again.
Any thoughts, suggestions or help ??
Thanks in advance.