View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.crashesgpfs,microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Excel crashes when copy

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,