Home > In Excel > Cannot Delete Sheets In Excel 2010

Cannot Delete Sheets In Excel 2010


Thanks. Thanks! –Vihar May 8 '13 at 11:50 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign When I go to tools>protection, the only > > > option I have is to protect worksheet/workbook. Create, change, or view scenarios None Group or outline data You can continue to use existing outlines. have a peek at these guys

Create or change PivotTable reports You can view existing reports. See More: unable to delete or add worksheets in an Excel spreadsheet Report • ✔ Best Answer Scorpion99 March 14, 2013 at 08:20:13 From did you get this file?It might be Join over 733,556 other people just like you! Insert a new worksheet Insert multiple worksheets at the same time Change the default number of worksheets in a new workbook Insert a new sheet that is based on a custom http://www.mrexcel.com/forum/excel-questions/84858-cant-delete-worksheet.html

Can't Delete Sheet In Excel 2013

Advertisement Recent Posts Word List Game #14 poochee replied Nov 6, 2016 at 2:26 PM lost on transfering dvd to computer tazzhound85 replied Nov 6, 2016 at 2:26 PM A -W All rights reserved. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote May 11th, 2004,11:35 AM #7 kidkl Board Regular Join Date Apr 2004 Location Death Sea Posts 93 Re: Can't Thread Status: Not open for further replies.

sheet protection would not do that, you would still be able to delete individual sheets. However, the Thread Tools Search this Thread 12-14-2005, 02:22 AM #1 fooddestroyer Registered Member Join Date: Sep 2004 Location: N.Ireland Posts: 274 OS: XP I want to All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. Can't Delete Sheet In Excel 2016 Right-select of any of my sheet tabs show options greyed out except for "View Code", "Protect Sheet", and "Select All Sheets".

Use a data form to add new data You can use a data form to find a record. Such opinions may not be accurate and they are to be used at your own risk. Share it with others Like this thread? http://www.excelforum.com/showthread.php?t=537594 how do I do this?

Join them; it only takes a minute: Sign up Can't delete sheet up vote 1 down vote favorite I'm trying to open a workbook and delete a sheet from it, but How To Enable Delete Sheet Option In Excel 2007 If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? If your question is resolved, mark it SOLVED using the thread tools 3. The time now is 12:28 PM. -- Mobile_Default -- TSF - v2.0 -- TSF - v1.0 Contact Us - Tech Support Forum - Site Map - Community Rules - Terms of

Delete Sheet Greyed Out Excel 2013

I am able to insert worksheets and edit worksheets, and it doesn't appear that my worksheet/workbook is protect. http://www.techsupportforum.com/forums/f57/delete-sheet-in-excel-80723.html The time now is 03:28 PM. Can't Delete Sheet In Excel 2013 Guest, Apr 30, 2006 #1 Advertisements Debra Dalgleish Guest If the workbook is shared you won't be able to delete sheets. How To Delete A Worksheet In Excel 2010 There are two types of data tables: one-input tables and two-input tables.) You can view existing data tables.

the icon is not highlighted to delete Saturday, September 18, 2010 1:33 PM Reply | Quote Answers 1 Sign in to vote The problem is its a Shared Workbook. More about the author Guest, Jun 12, 2006, in forum: Microsoft Excel Worksheet Functions Replies: 5 Views: 279 Guest Nov 8, 2006 Can't Freeze Pane in Excel, it's grayed out. If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. {RESOLVED} Excel: Can't Delete Worksheet Discussion in 'Business Applications' started by jimi, Aug Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Excel Delete Sheet Greyed Out

Okay, so I added the 'delete sheet' button onto my toolbar--this allows me to delete sheets. Any help you can offer is > > > much appreciated! Register To Reply 10-29-2012,06:45 PM #6 JosephP View Profile View Forum Posts Forum Guru Join Date 03-27-2012 Location Ut MS-Off Ver 2003/10 Posts 7,290 Re: can't delete worksheet--grayed out! http://skimwp.org/in-excel/cannot-delete-image-in-excel-2010.php Then hold down CTRL while you click the tabs of the other sheets that you want to select.

Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread. Unshare Workbook Excel On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet. Create or change charts or PivotChart reports You can view existing charts and reports.

If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

If you're having a computer problem, ask on our forum for advice. Any help you can offer is > > much appreciated! 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' > Delete Option Greyed Out In Excel If so, delete the code...you don't need it anymore.

Thread Tools Show Printable Version Subscribe to this Thread… Mark this thread as solved… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-30-2006,01:25 PM #1 TDiesel216 Guest can't Two or more nonadjacent sheets Click the tab for the first sheet. I am trying to delete 2 of the three but "Delete Sheet" is grayed out in both the "Edit" menu and RtMouseClick menu. http://skimwp.org/in-excel/cannot-delete-worksheet-in-excel-2010.php Click Save.

Tried a new workbook with same results. it could be greyed out in lieu of workbook protection. All Rights ReservedAd Choices The information on Computing.Net is the opinions of its users. You can also change the number of worksheets that appear by default in a new workbook.

Report • #5 NicFurr March 14, 2013 at 09:06:39 You're right.... I can't tell you why this happens but the above solution works for me when ever I come accross this issue with users at work. « Excel Formula Help Please!!!!! 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 I just registered and copied the "Reactivate..." code above and executed it without change of these sheet tab options.

Option is grayed out. mgold9, Oct 29, 2016, in forum: Business Applications Replies: 1 Views: 142 Lozzy-loz Oct 29, 2016 Excel Stacked Bar Graph Issues r24igh, Oct 27, 2016, in forum: Business Applications Replies: 3 Top of Page Share Was this information helpful? Use code tags for VBA. [code] Your Code [/code] (or use the # button) 2.

Why is this C++ code faster than my hand-written assembly for testing the Collatz conjecture? I personally don't like Shared Workbooks. When I go to tools>protection, the only > > option I have is to protect worksheet/workbook. Protect Workbook is available.

On a computer that is running Microsoft Windows XP, in the Save as type box, click Excel Template or Excel Macro-Enabled Template. Yes No I don't know I haven't used it View Results Poll Finishes In 5 Days.Discuss in The LoungePoll History About Us | Advertising Info | Privacy Policy | Terms Of In the File name box, type the name of the worksheet template. The workbook is not shared--when I go to 'share workbook', the check mark does not exist.

Mar 10, 2005 I can't delete a whole sheet in Excel.