Technical question regarding file size - large file with multiple sheets or single files?
Posted on 2011-10-07
We have a file which we use for calculating stock movements for a particular department/process in our factory. This file requires a number of manual inputs, copied from paperwork which can on occasions lead to errors or misinterpretations of the data. This file has a sheet for each week with 10-15 columns and 40-50 rows of data per day. Each week is the same format and size, closing stock from one week carried forward to the opening stock of the next. All very simple sums - input values, output values, expected stock, actual stock, variances etc. The file as it stands could potentially end up with 52 sheets of data.
The gist of the question is this: The file is already heading up towards 16Mb. If I were to split this into 52 separate files, one sheet per file, would it be the same total size; thinking maximising use of network storage resource.
By splitting to separate files, the input data could then be on a separate sheet replicating the data sheets.
Saving a blank file is circa 15Kb so I am assuming having 52 files would have this as a minimum/start point so less than 1Mb for the 52 files.
Splitting the 16Mb file into its respective 40 sheets (40 weeks so far this year) would suggest that they would be circa 0.5Mb each including the minimum start point for a blank file.
Is this a correct assumption to make???
I realise having the input sheets would increase the file size but I wouldn't have thought this would be a large increase.
Any pointers greatly appreciated. Technical issues not a problem, simple sums etc and might need a bit of VBA to copy to new workbook etc but I can manage that.