Others users have since entered data and resaved the file. If you still want to unprotect Word or PowerPoint document, just follow the articles below to do. Thank you for your response though Joanne Atkinson, Christchurch, New Zealand In the Share Workbook dialog box, on the Editing tab, clear the Allow changes by more than one user at the same time. Select: Ungroup Once the last sheet is Ungrouped. Click the plus sign next to any gray component to see which features were not installed. For this solution, what you need is a password recovery tool,my favourite is SmartKey Excel Password Recovery, you can Download this software from its official site With SmartKey Excel Password Recovery, you can open you excel spreadsheet without data lost.
Can anyone please give me an idea as to why the option is not available? Locate the Excel 2007 entry in the list of installed Microsoft Office software. I have checked the file to make sure that it is not read only. Here's how to remove workbook structure protection easily. In order to remove sheet protect, you first need to un-share the document, which in turn restores this functionality. I was sent a locked Excel 2010 to use, but with a number of silly bits of formatting that needed changing. Once I went to the end, all came right.
I have tried closing and reopening, as well as restarting the computer. And I feel pretty dumb. While I am able to modify cells, I am unable to insert and delete rows, format cells, change height, column width, etc. Now, when I try to open a cell to make changes, I receive a message telling me to unprotect the sheet. Step 1 — Create a Google account at gmail.
Can anyone help me unlock this thing? It probably means that you have grouped two or more sheets. This method lets you upload the file to Google Sheets, which removes all protections added in Excel. About the Author Alan Sembera began writing for local newspapers in Texas and Louisiana. How to unprotect a password protected worksheet. Did you use a similar format to above or another method? Each sheet's tab appears along the bottom of Excel.
You may have had these sheets grouped for a while. The option to add new sheet is greyed out? Previously, each month, I would unshare, unprotect and update the workbook ready for the new sales month. To do this, click on any worksheet which is not selected, in the above example, it is Sheet3. However, I am unable to delete the Sheet2. I foolishly assigned a password so that only the responsible parties could open it. Why is it Disabled: There are mainly 5 different reasons for Excel Insert button greyed out on the Developer Tab.
Whether I load the current spreadsheet, or backups even ones that were zipped and ok before all now have Import Data greyed out. Can't insert a new worksheet or delete an existing sheet? To request our help, please click the following link: Continue the Discussion Have you had to unprotect a password protected spreadsheet? Users commonly omit some features during a custom install to save space. Please let us know if you find some other reason for insert option disabled excel. And a box pops up with a usable code. Full version is recommended if you are sure to successfully unprotect your excel sheet in few seconds.
Reason 5: Excel Insert button greyed out due to Track Changes Enabled for the Workbook. The old version of this file pre data entry by other users does not have this problem. Open the worksheet you forgot password to unprotect. Or, you can right click on the selected sheets and choose Ungroup Sheets see image below. This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness.
I was able to resolve the problem. Everything is greyed out and cannot be changed. Unprotecting an Excel sheet is surprisingly easy. Get a excel file, and make it a copy it. Re: Import Data grayed out Thanks Roy.
However, I have about 50 excel documents, each containing multiple sheets. Then enter Macro editor with Alt +F11. Then you can remove the password protection, and re-share the document. Go to in a web browser. I recently had the circumstance where a client sent me a copy of a spreadsheet that was password protected, however the client no longer had the password to unlock the content. This type of installation creates a functional version of Excel 2007, but does not have all of the available features, resulting in grayed-out menu items.