Hi guys
Originally I have a template with a file size of 6Mb, because of some diagrams and blank chart objects which will be filled up after the user have entered the data. When the chart objects are filled by 400 frequency points, the 18 graphs add up into a whopping file size of 18Mb, which is obviously too much in this case. So now I have an excel file of 23.3Mb size. Is it possible that one graph can actually take up the space of 1Mb? The 18 blank charts which have not been filled up do not even take up 1Mb of space. Any help will be very much appreciated.
Btw, this template does not have any macros in it. The macros are in another excel file which generates the data into this template.
CJ
Originally I have a template with a file size of 6Mb, because of some diagrams and blank chart objects which will be filled up after the user have entered the data. When the chart objects are filled by 400 frequency points, the 18 graphs add up into a whopping file size of 18Mb, which is obviously too much in this case. So now I have an excel file of 23.3Mb size. Is it possible that one graph can actually take up the space of 1Mb? The 18 blank charts which have not been filled up do not even take up 1Mb of space. Any help will be very much appreciated.
Btw, this template does not have any macros in it. The macros are in another excel file which generates the data into this template.
CJ
Last edited: