Increase in the Size of the Excel WorkBook
 

Hello All,

I have an excel workbook, containing some graphs and some functions
which control the data flow into the graph. The workbook has 5 tabs,
with 2 tabs having 4 graphs each and the rest of the tabs have the data

to feed the graphs. Initially the size of the workbook,with data was
around 1.5 MB.


My client had requested some changes. This involved adding more data
series into the graph. The data was the same, except the graph now
contained more series to be displayed. Now, the size of the workbook is

almost 3.6 MB.


With the increased size, the processing time for these sheets gets
increased. The version of the excel i use is Microsoft Excel
2003(11.8105.8107) SP2.


Can any one please advise me on what's going on with my workbook ? Any
pointers to reduce the size of the file is highly appreciated.


Thanks,
Sagar

Increase in the Size of the Excel WorkBook
 

Please don't multi post... You have an answer in programming. Check out this
link...

http://www.cpearson.com/excel/newposte.htm
--
HTH...

Jim Thomlinson


"Sagu" wrote:

Hello All,

I have an excel workbook, containing some graphs and some functions
which control the data flow into the graph. The workbook has 5 tabs,
with 2 tabs having 4 graphs each and the rest of the tabs have the data

to feed the graphs. Initially the size of the workbook,with data was
around 1.5 MB.


My client had requested some changes. This involved adding more data
series into the graph. The data was the same, except the graph now
contained more series to be displayed. Now, the size of the workbook is

almost 3.6 MB.


With the increased size, the processing time for these sheets gets
increased. The version of the excel i use is Microsoft Excel
2003(11.8105.8107) SP2.


Can any one please advise me on what's going on with my workbook ? Any
pointers to reduce the size of the file is highly appreciated.


Thanks,
Sagar