Excel will no longer open my file

Jess123

New Member
Joined
Jan 14, 2010
Messages
1
Hi,

I have a large file that I have been working on at work in Excel 2007 running on XP and for some reason it will no longer open. I think I may have hit something on the keyboard but I have no idea what.

It was working fine this morning and yesterday, but earlier this morning the screen went blue when I hit a key and I couldn't get it back. I exited Excel and tried to reopen the document. But now when I try to open it it comes up with a question about enabling/disabling macros and no matter what I click, or how I go in and edit my macro settings, it won't open. I just get a blank blue screen. Then when I close it, it asks me if I would like to save the changes to the file...but it didn't even open the file in the first place.

There are no macros in the file, I was going to create one yesterday but changed my mind halfway through and deleted it. In My Documents, the excel icon for the document has a yellow scroll with an exclamation mark on it. I'm not sure if this is something to do with the macro that the document thinks it has in it, or if it means the document is corrupt or something.

I have also tried restarting my computer, copying and then renaming the file and then trying to open that, and opening it in different ways (ie, from the recently opened list, from the actual file itself, etc). It's important I get this file back, I can't afford to have to start it again!

Any ideas? Thanks.
 
Last edited:

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Hi,

I have a large file that I have been working on at work in Excel 2007 running on XP and for some reason it will no longer open. I think I may have hit something on the keyboard but I have no idea what.

It was working fine this morning and yesterday, but earlier this morning the screen went blue when I hit a key and I couldn't get it back. I exited Excel and tried to reopen the document. But now when I try to open it it comes up with a question about enabling/disabling macros and no matter what I click, or how I go in and edit my macro settings, it won't open. I just get a blank blue screen. Then when I close it, it asks me if I would like to save the changes to the file...but it didn't even open the file in the first place.

There are no macros in the file, I was going to create one yesterday but changed my mind halfway through and deleted it. In My Documents, the excel icon for the document has a yellow scroll with an exclamation mark on it. I'm not sure if this is something to do with the macro that the document thinks it has in it, or if it means the document is corrupt or something.

I have also tried restarting my computer, copying and then renaming the file and then trying to open that, and opening it in different ways (ie, from the recently opened list, from the actual file itself, etc). It's important I get this file back, I can't afford to have to start it again!

Any ideas? Thanks.

Is the blank blue screen surrounded by the file borders with scroll bars? Do you have a file title?
 
Upvote 0
I was also thinking a better idea of what you mean by a "blue Screen" would help.

Also,
1) Copy it now as a backup! Try your experiments on the copied file and try to keep the original untouched.
2) Open in a non-trusted location so macros don't run
3) Try to open with an older version of Excel, with OpenOffice.org Writer
4) Try to open with the Repair Option (in XL2003 this is an option if you choose open from the file menu, then right click the open button after you select the file.
5) Worst case scenario you may be able to download some trial software recovery programs, or pay for recovery from a specialist.

Repair option 2003:
http://office.microsoft.com/en-us/excel/HA010346561033.aspx

Repair option 2007:
http://office.microsoft.com/en-us/excel/HA100970171033.aspx?pid=CH100948241033
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top