ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel crashes when trying to save. (https://www.excelbanter.com/excel-discussion-misc-queries/106054-excel-crashes-when-trying-save.html)

Ori

Excel crashes when trying to save.
 

Hello all,

I have a pretty complicated worksheet iv been working on. It has about
10 sheets in, and many many macros, and uses a DDE interface to connect
to a different program.

Yesterday, I finished working on it, saved, and went to bed.
Today, iv opened it up, but without me even changing a thing, it wont
let me save at all. Neither "Save As" with a different name, or the
regular save is working. I tried moving it to a different computer, and
it doesnt save there either.

It says excel has crashed, and asks me if I would like to send an error
report.

I dont understand it, as I changed nothing since the last save
yesterday (which worked fine).

Does anyone have any suggestions?


--
Ori
------------------------------------------------------------------------
Ori's Profile: http://www.excelforum.com/member.php...o&userid=37675
View this thread: http://www.excelforum.com/showthread...hreadid=573529


Earl Kiosterud

Excel crashes when trying to save.
 
Ori,

Try the "Open and repair" option in the Open button of the File - Open
dialog. I think this varies with the version of Excel.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Ori" wrote in message
...

Hello all,

I have a pretty complicated worksheet iv been working on. It has about
10 sheets in, and many many macros, and uses a DDE interface to connect
to a different program.

Yesterday, I finished working on it, saved, and went to bed.
Today, iv opened it up, but without me even changing a thing, it wont
let me save at all. Neither "Save As" with a different name, or the
regular save is working. I tried moving it to a different computer, and
it doesnt save there either.

It says excel has crashed, and asks me if I would like to send an error
report.

I dont understand it, as I changed nothing since the last save
yesterday (which worked fine).

Does anyone have any suggestions?


--
Ori
------------------------------------------------------------------------
Ori's Profile:
http://www.excelforum.com/member.php...o&userid=37675
View this thread: http://www.excelforum.com/showthread...hreadid=573529




Ori

Excel crashes when trying to save.
 

Actually, while copying the spreadsheet over to an old version from a
few weeks ago, it managed to save again somehow, and has been working
fine ever since. (Wish I knew what was wrong in the first place though
so I could make sure it wouldnt happen again)

Iv never heard of that option though, and will keep it in mind if
anything like this happens again.

Thanks for your help.


--
Ori
------------------------------------------------------------------------
Ori's Profile: http://www.excelforum.com/member.php...o&userid=37675
View this thread: http://www.excelforum.com/showthread...hreadid=573529



All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com