Excel crashes when copying worksheet

[kathleane]

Whenever I try to copy or move certain worksheets either within the same
workbook or to a new workbook Excel crashes. I cannot reopen Excel (vs.
2000) without deleting it from the Program Manager - it remains in the
background.

I suspect the problem may have to do with having too many characters in
certain cells, although I carefully combed through one of these
worksheets and thought that I had fixed all cells so that none had more
than 200 characters and it still crashed Excel when I tried to copy
it.

Does anyone have any solutions for this?

 

[Stuart Farr]

Go into VBE and check SHeet numbering. If you have repeatedly copied
sheets within the workbook, the sheet numbering can become very high
and I have found files to become unstable as a result.

 

[kathleane]

In these workbooks that are crashing I have 6 to 10 worksheets. Is that
approaching the limit? Seems a little low for a limit in a spreadsheet
program.

 

[pfsardella]

The issue that Stuart refers to is detailed in the following posting.
I thought that it was an Excel 97 issue, but .....

http://www.google.com/[email protected]&oe=UTF-8&output=gplain

If that's not the issue, then there are plenty of discussions here.

http://www.google.com/groups?as_q=E...F-8&as_ugroup=*excel*&lr=lang_en&num=50&hl=en

HTH
Paul

 

[Lady Layla]

Limits are determined by the amount of memory on your machine


: In these workbooks that are crashing I have 6 to 10 worksheets. Is that
: approaching the limit? Seems a little low for a limit in a spreadsheet
: program.
:
:
:
: ------------------------------------------------
:
:
: