Solved

Excel 2010, can't edit normally

Posted on 2013-11-21
1
386 Views
Last Modified: 2013-11-21
I have a workbook open and almost all the icons in the menu system are disabled. The only ones open are some on the Insert menu/tab and the 3 icons on the Nuance PDF tab. i can enter characters on the different sheets, and delete characters anywhere but I cannot delete lines, print, save, etc. It's the same for all pages of this 12-sheet workbook.

The critical problem is that I cannot save it normally, or to another name. I have not used protection on this workbook and it does not say read-only, nor does it behave that way.

I use Excel a lot and I've never seen this behavior.

Help!

John
0
Comment
Question by:John Fistere
1 Comment
 
LVL 2

Accepted Solution

by:
John Fistere earned 0 total points
ID: 39668121
Crisis over. I managed to save the file on some Windows Live service that was a part of Excel. I then Ctl-Alt-Del'd to stop the application. I then found that the cause of the behavior was that it was waiting for a response from me for a "Save As" operation I must have started, but then the dialog became hidden behind the app.

Cancelling the Save As operation brought everything back to normal.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question