Increase in the size of 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 Excel Workbook.
 

Your used range has probably become messed up. Take a look at the scroll
bars. If they can swcroll you well past the end of your data then the used
range needs to be reset. Check out this link...

http://www.contextures.com/xlfaqApp.html#Unused
--
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