Thanks, Tom.

I checked all of my sheets, and none of them have this problem.

Are there any other things I could try to reduce the filesize? Some
common problems you see?

R/
ML


"Tom Ogilvy" wrote in message ...
Doing step 3 does nothing unless you delete entirerows and entirecolumns of
what you consider to be unused space. If you think you worksheet ends at
row 200 for example, but when you are at row 200, the scrollbar on the right
is not at the bottom of the "tray", then Excel does not see row 200 as the
bottom of your worksheet. Go to the name box and type

201:65536 <cr

then do Edit=Delete

for columns

AA:IV <cr
Then do Edit =Delete

then save the file

Repeat on each sheet.

--
Regards,
Tom Ogilvy

wrote in message
om...
I have a file I've shared/unshared multiple times. I have conditional
formatting, about 20 custom views, 30 simple VBA scripts, and a whole
host of error-checking formulas like

=IF(Z13=0,"",IF(Z24=0,"",IF(Z35=0,"",IF(Z57=0,"",I F(Z63=0,"",IF(Z46=0,"",IF(
Z69="","",Z13+Z24+Z35+Z57+Z63+Z46+Z69)))))))

My filesize keeps growing.

I've tried the following:
1. resharing, clearing the "keep history" checkbox, and unsharing
again
2. running Rob Bovey's codecleaner http://www.appspro.com/
3. resetting the lastcell reference in my workbook open module
Sub Reset_Range()
ActiveSheet.UsedRange
End Sub

None of the above changed the file size at all (3,147 KB before, 3,147
KB after).

Any other suggestions?

Thanks,
Michael Lambert.