Prev: sheet name in workshhetfunction
Next: Lose the 0 in the Total cell
From: AE on 31 May 2010 09:24
I have a spread sheet built that currently has 382 sheets of data. The sheets
are 12 columns x 61 rows. There are conditional formats applied. I can copy a
blank sheet move it to the required location, input data, but it will not let
me save it. I get an error box to send to Microsoft. When I close it will go
to recovery and updates the file as version1, version 1 version 2 ect...
From: Mike H on 31 May 2010 10:04
Hi,

Save a copy of the workbook and delete some sheets (say) a dozen. Can you
create new sheets and save now?

If so I suspect you may have run out of system memory which is the limiting
factor for sheets in a workbook.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"AE" wrote:

> I have a spread sheet built that currently has 382 sheets of data. The sheets
> are 12 columns x 61 rows. There are conditional formats applied. I can copy a
> blank sheet move it to the required location, input data, but it will not let
> me save it. I get an error box to send to Microsoft. When I close it will go
> to recovery and updates the file as version1, version 1 version 2 ect...
 | 
Pages: 1
Prev: sheet name in workshhetfunction
Next: Lose the 0 in the Total cell