Hello,
I have been working on a "program" at work to be used by contractors in the construction field. My program is essentially an Excel spreadsheet with some graphics, lots of equations, lots of data and quite a bit of VB code to automate several tasks so that the end user can fill in some survey data, click a button, and that is all. My problem is that the file is around 16 mb. Since I don't believe that I have entered THAT much data and code, I ran through some tests.
I created a new file, selected all of the data (not using ctrl+A, that comes later) and copied the data from each tab into the new sheet using Paste Special ->Values, then copied all of the graphics and controls, then copied all of the VB code. The file size went down to about 1.5mb.
I then created another file and copied everything the same way except using Paste Special ->Formulas, the file size went up to about 6mb.
Finally, I copied all of the data to a new sheet using ctrl+A then pasting into the new sheet. The file size ballooned to 16mb.
From this testing, it seems that the file size is larger than the sum of its parts. I am guessing that there is some sort of overhead associated with the file, but I have no idea how to find out or how to reduce it. Any thoughts would be greatly appreciated.
I have been working on a "program" at work to be used by contractors in the construction field. My program is essentially an Excel spreadsheet with some graphics, lots of equations, lots of data and quite a bit of VB code to automate several tasks so that the end user can fill in some survey data, click a button, and that is all. My problem is that the file is around 16 mb. Since I don't believe that I have entered THAT much data and code, I ran through some tests.
I created a new file, selected all of the data (not using ctrl+A, that comes later) and copied the data from each tab into the new sheet using Paste Special ->Values, then copied all of the graphics and controls, then copied all of the VB code. The file size went down to about 1.5mb.
I then created another file and copied everything the same way except using Paste Special ->Formulas, the file size went up to about 6mb.
Finally, I copied all of the data to a new sheet using ctrl+A then pasting into the new sheet. The file size ballooned to 16mb.
From this testing, it seems that the file size is larger than the sum of its parts. I am guessing that there is some sort of overhead associated with the file, but I have no idea how to find out or how to reduce it. Any thoughts would be greatly appreciated.
