Excel Workbook too large

J

jdtivoli

I have created 3 workbooks which contain 1 worksheet each. Two of th
worksheets each contain formulas which return data from variou
different fields in the same third worksheet.

These 2 workbooks should be identical with the exception being that th
formulas point to different field locations in the third worksheet.

I created the second worksheet by copying the first one and the
editing the formulas as required to point to different fields on th
third worksheet.

The first workbook is 140k and the second is 1.03Mb.

Could someone give me an idea as to why this might be this way, o
where to start looking for a solution?

There is 400 formulas total on each worksheet so I really don't want t
have to recreate the worksheets from scratch again.

Jess
 
R

RWN

What happens if you do a "Ctrl-End" on the large workbook?
If you wind up "out in the boonies" (in an area of "unused" cells) then
you'll want to delete all the rows & columns that are unused, then save
the workbook.
For ex, say the function takes you to row 100 but your last used row is
20, then delete rows 21->100 (same idea for columns).

A "Ctrl-End" should now take you to the last used cell in the book.

Remember to save the book once you've done the delete.

Works for '97 & 2k.
 
R

RWN

Oh darn! That's usually the problem (for me at least).

At what point does the size grow?
i.e. if you re-do your copy procedure and save it (no editing) , is it
the same size as the source file?

BTW how did you do the copy? Select the used cells, select the whole
sheet or copy the Workbook via explorer.
 
M

Mike A

Oh darn! That's usually the problem (for me at least).

At what point does the size grow?
i.e. if you re-do your copy procedure and save it (no editing) , is it
the same size as the source file?

BTW how did you do the copy? Select the used cells, select the whole
sheet or copy the Workbook via explorer.
Click to expand...


It may be that the formatting info. for the unused cells was copied.
Try Edit | Clear > Formats.


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
Top