View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phrank Phrank is offline
external usenet poster
 
Posts: 153
Default Shared workbook file size becoming very large

I've got a shared workbook with 5 tabs. Each tab has about 20 columns
of data. Four of the five tabs have a maximum of 50 lines, and the
fith tab does have about 750 lines at the moment. The file size has
ballooned to about 40 mb, which is making it take an inordinate amount
of time to save and calculate. One of the columns is for Notes, and
the notes can get lengthy. Would this text in cells make the file
this big, or does it have something to do with the shared workbook
aspect? Is there a way to 'clean up' a shared workbook? Thanks for
any advice.

Frank