Does size matter.

  • Thread starter Thread starter sonicscooter
  • Start date Start date
S

sonicscooter

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.
 
I would consider it a problem, especially as it seems to be data creating
the size. I would look to separate the data and code, preferably storing the
data in a database.
 
Sounds to me you need a database.
Maybe give SQLite a go as it is fast, simple and reliable and there is a
free
wrapper. If there are multiple users accessing the same data then maybe go
for something else.

RBS
 
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.
 
Back
Top