M
miwarren
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!!!
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!!!