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.

--
__________________________________
HTH

Bob

"sonicscooter" wrote in message
...
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.

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


"sonicscooter" wrote in message
...
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.

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.

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.