View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Does size matter.


Sounds you could make things simpler by using the VBA code cleaner:
http://www.appspro.com/Utilities/CodeCleaner.htm

RBS


"Libby" wrote in message
...
Sounds big to me too.

You can sometimes reduce the file size by the way you save. For example,
try
saving multiple times when the workbook is in design mode. Try also saving
with no other workbooks open.
In my experience the file size is dynamic and not necessarily related to
information. I've had it where I've actually removed code/data and the
file
size has increased.

As a last resort you could try coping everything to a new workbook. I've
experienced anomolies where a particular workbook is disproportionately
big
compared to others with similar content. When I've copied the data and
code
into another normal size is resumed.

"sonicscooter" wrote:

What is classed as a large spreadsheet?

I use 2 instances of Excel, one is 11 meg, and the other is 26 meg, they
are
growing larger each day as the inbuilt data bases fill, i think they will
end
up around 15 meg and 34 meg.

Should this be a problem?

Thanks Shane.