Twice a month I update an Excel file to store our household finances and
bills when I pay bills. It has worked fine until about 2 months ago. When I
would close it, Excel would enter into Not Responding mode. I tried manually
saving the file before I close it and even while I am still working in it and
it still gets hosed. I can recover the file , thankfully, with the office
automatic recover feature, but it is very annoying.

Any ideas what is going on and what I can do to fix it?

Hi,

I had something similar, ik may be that there is a 'missing bit or
byte' in the file which causes the problem, in short, the file is
corrupt.

Open the Excel document,

Create a new document

Go back to the original one

select the entire sheet by pressing <Ctrl <A simultaneously
<Ctrl <C to copy to clipboard

Go to the new docucent en set the point to cell A1
<Ctrl <V to paste dat clipboard data

If you have more than one sheet in the docuemtn repeat the action for
all the sheets.

Save the new document and see if it works.

If all is well, you can de delet the old one and give the new file the
same name.

Good luck,

Hans


--
hhalle

Male
------------------------------------------------------------------------
hhalle's Profile: http://www.excelforum.com/member.php...o&userid=20829
View this thread: http://www.excelforum.com/showthread...hreadid=491632