Hi all,
I have an excel spreadsheet (6MB). It crashes whenever I tried to
copy/cut any cell from any worksheet within the workbook. Any idea on how I
can trouble the problem? I have a copy of the workbook before I modified
couple macro, that version still works. I have even tried disabled the
macros, it still crashes. I can insert row, and worksheet. I just can't
cut/copy cells.

Thanks,

when excel repeatedly crashes:
first make sure your TEMP directory is cleaned.

close excel

in windows
Run %temp%

if you find hundreds or thousands of files..
i'm quite confident your problems s/b solved after cleanup.
you s/b able to delete (almost) all files and directories
in the temp directory.

when that is solved..
there are plenty more probs that could cause excel
to crash on copying a sheet.

very often it's DEFINED names. (or VIEWS)
d/l NAME MANAGER addin to check if names may be causing your probs.
http://www.jkp-ads.com/download.asp


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jeff wrote in

Hi all,
I have an excel spreadsheet (6MB). It crashes whenever I tried to
copy/cut any cell from any worksheet within the workbook. Any idea
on how I can trouble the problem? I have a copy of the workbook
before I modified couple macro, that version still works. I have
even tried disabled the macros, it still crashes. I can insert row,
and worksheet. I just can't cut/copy cells.

Thanks,

Hi KeepITCool,
Temp directory doesn't have much stuff in there (10MB). It's mostly
likely caused by defined names. Would you please tell me what should I look
for and steps to troubleshoot the problem?

Thanks,
Jeff

"keepITcool" wrote:

when excel repeatedly crashes:
first make sure your TEMP directory is cleaned.

close excel

in windows
Run %temp%

if you find hundreds or thousands of files..
i'm quite confident your problems s/b solved after cleanup.
you s/b able to delete (almost) all files and directories
in the temp directory.

when that is solved..
there are plenty more probs that could cause excel
to crash on copying a sheet.

very often it's DEFINED names. (or VIEWS)
d/l NAME MANAGER addin to check if names may be causing your probs.
http://www.jkp-ads.com/download.asp


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jeff wrote in

Hi all,
I have an excel spreadsheet (6MB). It crashes whenever I tried to
copy/cut any cell from any worksheet within the workbook. Any idea
on how I can trouble the problem? I have a copy of the workbook
before I modified couple macro, that version still works. I have
even tried disabled the macros, it still crashes. I can insert row,
and worksheet. I just can't cut/copy cells.

Thanks,

Even though I have got rid of all the #refs. It still won't let me copy/cut.
(paste works fine though). Now I can't even launch the Name manager (it'll
crash - but only on that xls).

Thanks,


"keepITcool" wrote:

when excel repeatedly crashes:
first make sure your TEMP directory is cleaned.

close excel

in windows
Run %temp%

if you find hundreds or thousands of files..
i'm quite confident your problems s/b solved after cleanup.
you s/b able to delete (almost) all files and directories
in the temp directory.

when that is solved..
there are plenty more probs that could cause excel
to crash on copying a sheet.

very often it's DEFINED names. (or VIEWS)
d/l NAME MANAGER addin to check if names may be causing your probs.
http://www.jkp-ads.com/download.asp


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jeff wrote in

Hi all,
I have an excel spreadsheet (6MB). It crashes whenever I tried to
copy/cut any cell from any worksheet within the workbook. Any idea
on how I can trouble the problem? I have a copy of the workbook
before I modified couple macro, that version still works. I have
even tried disabled the macros, it still crashes. I can insert row,
and worksheet. I just can't cut/copy cells.

Thanks,