Rob

Have you experimented with this theory?

Open a new workbook.

Save then check FileProperties for size.

Format a great bunch of rows and columns.

Save then check FileProperties for size.


Gord Dibben MS Excel MVP

On Sat, 21 Jun 2008 17:53:59 +0930, "RobN" wrote:

Dave,

I hope you don't mind me butting in here, but I believe formatting to whole
columns/rows can increase the file size, as Excel may consider the last
cells, (in this case the last formatted cell), as the last used cell,
thereby creating further problems, such as slow to open/save, etc.

Rob

"Dave Peterson" wrote in message
...
I've never seen anything like that.

Maybe you could just reapply the formatting you want--to whole
columns/rows.
And try to stay away from using too many of them.

Maybe even clearing the formats (watch out for Conditional formatting if
you use
that) would help.

ToOfWe wrote:

"Dave Peterson" wrote:

How about removing some of the formatting?


Dave Peterson


Thank you fr responding.

I've done that a few times but I doesn't seem to help for very long -
maybe
a few weeks. The spreadsheet is quite old and perhaps there are formats
that
I don't see.

Is there a tool that can identify the different formats, then I can get
rid
of the ones I don't need, or want.

Thanks.

--

Dave Peterson