I created a workbook that has 13 worksheets. One for each month and then a
tally sheet to get quarterly and ytd totals. Once I created the sheet I
copied it for 15 different departments to use. Lots of formulas and lines in
the worksheets. Now when I go back to look at the size of the workbookbooks,
some are 11,000 KB in size and others are 360 KB. I am trying to understand
why the same workbook is up to 11,000 KB and others are 350...this is without
data being entered yet. How can I find out what is causing the worksheet to
go to 11,000 KB. 11,000 just a tad large and long to open.
--
Deb G

Sounds like you have extra rows/columns there.

IF the scroll bar does not hit bottom when you are at the last row or column
of data:

highlight the row below the last, shift+ctrl+down arrow edit/delete

highlight the column to the right of the last, shift+ctrl+right arrow
edit/delete

Go to cell A1, save. This should remove dead space. Do this for all
worksheets that have this issue. Check your file size. :-)
"Deb G" wrote:

I created a workbook that has 13 worksheets. One for each month and then a
tally sheet to get quarterly and ytd totals. Once I created the sheet I
copied it for 15 different departments to use. Lots of formulas and lines in
the worksheets. Now when I go back to look at the size of the workbookbooks,
some are 11,000 KB in size and others are 360 KB. I am trying to understand
why the same workbook is up to 11,000 KB and others are 350...this is without
data being entered yet. How can I find out what is causing the worksheet to
go to 11,000 KB. 11,000 just a tad large and long to open.
--
Deb G

Sean, you are absolutely correct. How easy that was. Thank you very much!
--
Deb Geambazi


"Sean Timmons" wrote:

Sounds like you have extra rows/columns there.

IF the scroll bar does not hit bottom when you are at the last row or column
of data:

highlight the row below the last, shift+ctrl+down arrow edit/delete

highlight the column to the right of the last, shift+ctrl+right arrow
edit/delete

Go to cell A1, save. This should remove dead space. Do this for all
worksheets that have this issue. Check your file size. :-)
"Deb G" wrote:

I created a workbook that has 13 worksheets. One for each month and then a
tally sheet to get quarterly and ytd totals. Once I created the sheet I
copied it for 15 different departments to use. Lots of formulas and lines in
the worksheets. Now when I go back to look at the size of the workbookbooks,
some are 11,000 KB in size and others are 360 KB. I am trying to understand
why the same workbook is up to 11,000 KB and others are 350...this is without
data being entered yet. How can I find out what is causing the worksheet to
go to 11,000 KB. 11,000 just a tad large and long to open.
--
Deb G

Not a problem. Happy to Help! Comme back any time. I'll be here all week.
Try the fish.

"Deb G" wrote:

Sean, you are absolutely correct. How easy that was. Thank you very much!
--
Deb Geambazi


"Sean Timmons" wrote:

Sounds like you have extra rows/columns there.

IF the scroll bar does not hit bottom when you are at the last row or column
of data:

highlight the row below the last, shift+ctrl+down arrow edit/delete

highlight the column to the right of the last, shift+ctrl+right arrow
edit/delete

Go to cell A1, save. This should remove dead space. Do this for all
worksheets that have this issue. Check your file size. :-)
"Deb G" wrote:

I created a workbook that has 13 worksheets. One for each month and then a
tally sheet to get quarterly and ytd totals. Once I created the sheet I
copied it for 15 different departments to use. Lots of formulas and lines in
the worksheets. Now when I go back to look at the size of the workbookbooks,
some are 11,000 KB in size and others are 360 KB. I am trying to understand
why the same workbook is up to 11,000 KB and others are 350...this is without
data being entered yet. How can I find out what is causing the worksheet to
go to 11,000 KB. 11,000 just a tad large and long to open.
--
Deb G