Home > In Excel > Cannot Delete Worksheet In Excel

Cannot Delete Worksheet In Excel


Insert or change hyperlinks Existing hyperlinks continue to work. On the Home tab, in the Cells group, click Insert, and then click Insert Sheet. How to print sheet names On the Insert tab, in the Text group, click Header & Footer. Click Tools -> Protection -> Unprotect Workbook. check my blog

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote May 11th, 2004,11:26 AM #5 ColsHub New Member Join Date May 2004 Posts 6 Re: Can't delete worksheet Just The time now is 02:46 PM. Use a data form to add new data You can use a data form to find a record. Have been doing VBA for a few years and now attempting addition of new capabilities.

Cannot Delete Sheet In Excel 2010

When the information becomes non-applicable it should be deleted...otherwise age does not affect the quality of the information and I like to add to it when I have time. Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. To turn > off sharing, choose Tools>Share Workbook. > On the Editing tab, remove the check mark from 'Allow changes by more > than one user at the same time' >

  1. Is this the only menu item that's disabled? __________________ Iain - Defender of the Haggis and all things Scottish.
  2. Any help you can offer is > > much appreciated!
  3. Such opinions may not be accurate and they are to be used at your own risk.
  4. Tip: You can also right-click the sheet tab of a worksheet or a sheet tab of any selected worksheets that you want to delete, and then click Delete.
  5. Register Help Remember Me?
  6. Also can't add new sheets with the "+".
  7. I am able to > > insert worksheets and edit worksheets, and it doesn't appear that my > > worksheet/workbook is protect.
  8. UNLESS of course, there is an offending workbook you are using that may keep turning it off.
  9. Yes, my password is: Forgot your password?
  10. However, the Delete Sheet option is greyed out?

Share it with others Like this thread? The default worksheet template, sheet.xltx or sheet.xltm, should be saved in the XLStart folder, which is usually C:\Program Files\Microsoft Office\Office12\XLStart. Tip: You can also right-click the tab of an existing worksheet, and then click Insert. Can't Delete Sheet In Excel 2016 Do I need this: System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)?

You can't delete sheets from a shared workbook. Delete Sheet Greyed Out Excel 2013 thanks Microsoft Office > Excel IT Pro Discussions Question 0 Sign in to vote how can I delete a sheet in excel in a shared file that I sent home from Any other feedback? http://www.computing.net/answers/office/unable-to-delete-or-add-worksheets-in-an-excel-spreadsheet/17977.html You'll be able to ask any tech support questions, or chat with the community and help others.

Why can't I delete my Excel worksheet Wait - just had a Eureka. How To Enable Delete Sheet Option In Excel 2007 Debra Dalgleish, Apr 30, 2006 #2 Advertisements Guest Guest The workbook is not shared--when I go to 'share workbook', the check mark does not exist. Do I have to un-share the workbook in order to delete sheete? Create, change, or view scenarios None Group or outline data You can continue to use existing outlines.

Delete Sheet Greyed Out Excel 2013

Each user who saves the workbook sees the changes made by other users.) on Web servers. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Cannot Delete Sheet In Excel 2010 Create or change PivotTable reports You can view existing reports. How To Delete A Worksheet In Excel 2010 VLAN Issue PC Random Freezes/Crashes PC crashes at random times but the...

All rights reserved. click site Use a data form to add new data You can use a data form to find a record. If so, delete the code...you don't need it anymore. PC Safety & Security::PC running a bit slow?::Photographers Corner 06-14-2007, 11:04 AM #5 Mitchlyn Registered Member Join Date: Jun 2007 Posts: 1 OS: XP I had this problem Excel Delete Sheet Greyed Out

The name (or title) of a worksheet appears on its sheet tab at the bottom of the screen. Note: Custom templates are automatically saved in the Templates folder. Guest, Nov 28, 2005, in forum: Microsoft Excel Worksheet Functions Replies: 2 Views: 354 Guest Nov 29, 2005 How do I rename an Excel worksheet when the feature is grayed out. http://skimwp.org/in-excel/cannot-delete-worksheet-in-excel-2010.php I am able to insert worksheets and edit worksheets, and it doesn't appear that my worksheet/workbook is protect.

Add or change Microsoft Excel 4 dialog sheets None Change or delete array formulas(array formula: A formula that performs multiple calculations on one or more sets of values, and then returns Unshare Workbook Excel Just click the sign up button to choose a username and then you can ask your own questions on the forum. All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do.

if all entries under protection say 'Protect ...' then you're sheet/book is not protected, and that is probably not the problem. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu. Operating Systems ▼ Windows 10 Windows 8 Windows 7 Windows XP See More... Excel 2010 Unprotect Workbook If so, delete the code...you don't need it anymore.

Here is a list of all the features which are not enabled in a shared wb: Features that are unavailable in shared workbooks You can though the individual sheets were not protected and the overall spreadsheet was not protected, the structure was password protected and this is not immediaterly apparent. Note: Sheet tabs are displayed by default, but if you do not see them, verify that the Show sheet tabs check box is selected in the Advanced category of the Excel Options More about the author Why can't I delete my Excel worksheet?

Register Help Remember Me? Computing.Net and Purch hereby disclaim all responsibility and liability for the content of Computing.Net and its accuracy. Here is the FAQ for this forum. Those who understand binary, and those who don't.

jimi, Aug 20, 2001 #1 Linkmaster Joined: Aug 11, 2001 Messages: 2,872 Hi jimi, Welcome, If you you want to delete the old data sheet, just find the sheet where you Is there any code running that might disable that menu option?