MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Illegal operation? Corrupted file?


Posted by Vicki Fox on August 14, 2001 8:37 AM

When we do a copy paste from one Excel file to a brand new Excel file an error message comes up that says we have performed an illegal operation. It then closes all Excel files (without saving) and shuts down Excel.
I think the file may be corrupted - have no other explanation for this. But how do you fix a corrupted file?

Or is something else wrong?


Posted by Eric on August 14, 2001 10:33 AM

Couple of things to check

Hi,

Can't say this kind of thing has never happened to me before. Here's some maneuvers that have worked in the past.
First, if you're running anything from Windows 95 to Windows ME (not WinNT, Win2K, and WinXP) you have to do a "hard" reboot (power off, power on) everytime you get that message or other stuff is liable to fail as well!
Second, try copying and "paste special" "as values" into a second sheet.
Third, if that doesnt work try saving the worksheet as an ACII file (warning, only saves the active worksheet)
Fourth, if that doesn't work, try copying the worksheet and pasting it into another application like notepad (if the file is small enough) or Word or Wordperfect.
I've also heard that you can open damaged Windows-based Excel files by opening them in the Mac version of Excel- http://www.accountingadvisors.com/exceltip.shtml#damaged

hope that helps, and good luck!