I have worked up an excel document that consists of four sheets, one sheet being the data entry sheet which then in turn post data to the other sheets providing needed information. It also includes links to external workbooks to calculate the end result. When the output is posted we then need to save the workbook for future reference for up to one year.
Problem: The files are consistently around 1.5 megs after the data is posted which at the frequency that the forms are created is not ideal. So what would you suggest?
*Some brainstorming I had:
Do I save it as data file that will not contain links but the output instead, if so, how do I do that?
Do I save the information as a data file that can be importing back into the document, again, how would I do that?
That's the only two options that hit me.
Any help would be very much appreciated!!!
Bookmarks