Hi there,
has a friend of Paulo Martins and as a Computer Tech maybe I can Try and
explain the problem in a better way.
So, he has an Excel 2003 Workbook with 160 spreadsheets. If you take one of
those spreadsheets and copy it to a new Workbook and the you put it again in
the origin Workbook, after you close it it won't open again.
If you try and select an external spreadsheet by cliking in the upper left
corner (selecting all cells) and paste it into an existing sheet, after you
save and close it won't open again.

I've already tryied everything I can think of... the result is allways the
same, it works fine until you close the file and try to re-open it.

Hope that someone has any ideas!!!

cya,



"Paulo Martins" wrote:

Many thanks Gord, but i didn´t reach the limit of my workbook because i have
only 160 sheets.
By the way, how can i add more than 255 sheets to a workbook?

Paulo Martins

"Gord Dibben" wrote:

255 sheets is the limit for a new workbook.

More can be added after the workbook is open if your resources will allow.


Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 11:04:03 -0700, Stephane Quenson
wrote:

If you have links to external spredsheets, then each of these external
worksheets are considered as one worksheet in your document, even if not
visible. This is how Excel can still display informationif even if the links
are not updated, by the way.

So you may have reached the limit of worksheets per document, which is 255
if I am not mistaken.

Stephane.