I have created an Excel Document that collates Bill of Materials for each job.
I get the data from the Database containing all the BOM's from solidworks.
There are then a series of macros that run to format the table into a readable format, and then add the odd equation here and there. The original blank file is 85kb, upone completion of macros and resave the file is 38,000kb! This can be brought down to 138kb by deleting the 'Schedule Sheet' (The one with the pasted data from the table in sheet 1). I do not understand while it makes the file so large as the data only goes down to row 400 (Roughly).
I have attached a link to the original file pre macro run and the final file at 38,000kb. Please see the modules in these files to understand where i am coming from.
Any help would be greatly appreciated!
https://www.dropbox.com/s/tnjkdw2eq15mwwc/Schedule%20Document%20original.xlsm?dl=0
https://www.dropbox.com/s/ykktahvdec60s6s/Schedule%20Document.xlsm?dl=0
The reason for this was: as discussed in the comments, I had a macro running formatting over all cells.