Can't Save or Close file

I am running Windows 7 Ultimate on a PC. I have an Excel file open but most of the buttons on the different banners at the top are disabled including, in particular, Save, Save As, and Close. It is acting as though a dialog box relative to the file were open but I have searched for a dialog box and none is apparent.

This is happened before and the only way out has been to reboot or close the application with the Task Manager. I really need to save it.

What can I do?
LVL 2
John FistereEngineer, retiredAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Thunder724Commented:
When you open the file does it have a button on top middle indicating "Allow Editing?" or something like that?
You could also try copying the file to a new file and name to see if that helps.
RayData AnalystCommented:
You've probably already handled this, but did try clicking on the active Excel application then pressing the "ESC" key a few times?  If it is waiting on something, this should cancel it.
John FistereEngineer, retiredAuthor Commented:
Thunder:
I created the file so the "Allow Editing" message does not apply nor appear. I thought you had thought of an obvious wonderful solution, but alas, the new file I created has the same problem, that is, most of the buttons are deactivated. Now I am sitting with two files I cannot Save!

Ray:
Yes I have tried the ESC key.
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Thunder724Commented:
Can you create a new file, save it and re-open it? Does this condition persist for other files?
If not, can you open the file, select all the contents and paste it into a new file?
David Johnson, CD, MVPOwnerCommented:
There probably is a macro running that runs on load that is stopping those functions
jcimarronCommented:
JFistere --
Those commands should be available by clicking on File in the Excel Menubar.
John FistereEngineer, retiredAuthor Commented:
Thunder,
When I create a new file it has the same problem. Rebooting solves the problem, at least temporarily, but then I have lost my file.

David,
If it is a macro, how do I find it stop it? The macro keys are inactive. And the problem exists for a brand-new empty file.

jcimarron,
I agree. Those commands should be available, but in this case they are inactive.
nobusCommented:
if you have the input data - i suppose you'll need to close the files without saving, and input the data again
if not, take pictures, or screenshots of what you need first
John FistereEngineer, retiredAuthor Commented:
nobus,
Fortunately, I was able to print it, and it's only a one page spreadsheet. But I would like to solve the problem, because it has occurred before.
Rob HensonFinance AnalystCommented:
Can you get to the File > Options window?

The Save option on the right hand side shows the default locations for Recovery etc. There is also an option at the end of the Advanced section with text "Atstartup, open all files in:" and there is then an input box for file locations. If this is populated check this location for *.xlsm files. There could be one which is opening and on open disabling the Save functions.

Thanks
Rob H
Thunder724Commented:
If you try to copy the data and paste it into another spreadsheet, use "Paste Special" and choose only "Values".
nobusCommented:
the only things that come to my mind are : repairing the OS, or the EXCEL
you can repair the office programs from the add/remove programs
repairing the os can be done by running sfc :
http://www.sevenforums.com/tutorials/1538-sfc-scannow-command-system-file-checker.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John FistereEngineer, retiredAuthor Commented:
I had never heard of "sfc" before but I ran it using the link you gave and it produced lots of "can't repair file" messages, but when I checked the humongous log, it appeared that there were many repairs that were made. For the moment, I don't have the problem anymore (but it's not repeatable anyway), so we will see.

What I didn't notice is a speed up in general computer operation, so there has been an improvement in that area, which I didn't expect. Thanks.

I didn't try your other solution, that of repairing Excel, but if I do have the problem again I will try that.
John FistereEngineer, retiredAuthor Commented:
By the way, thanks to all of you who tried to help. I really appreciate it.

John
nobusCommented:
tx for the feedback John
as for the "can't repair file" messages" - run sfc again; in some cases this clears up lots of them, and it does not hurt
John FistereEngineer, retiredAuthor Commented:
nobus - I did run it twice and it behaved about the same.
nobusCommented:
that's why i said "in some cases"
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.