Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SHOULDBE ABLE TO DELETE EXCEL WORKSHEETS EVEN IF NOT DOC CREATOR.
I had a work issue where I could have fixed worksheet formatting in less than
a minute IF I was able to delete worksheets. Since you can't delete Excel worksheets unless you're the creator of the document, it took over an hour to complete. Why does Excel have this obnoxious feature? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SHOULDBE ABLE TO DELETE EXCEL WORKSHEETS EVEN IF NOT DOC CREAT
Thanks for the insight. But even when I saved as a new document, those
options remained and I was still unable to delete worksheets. That's SO retarded. "Gord Dibben" wrote: Your statement "Since you can't delete Excel worksheets unless you're the creator of the document" is incorrect. Worksheets can be deleted by anyone. Exception........... If under ToolsProtection someone has enabled Workbook Protection which will not allow sheets to be deleted if the Structure is protected. The workbook protection must be disabled, perhaps a password is required. Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 15:59:01 -0700, le tamster <le wrote: I had a work issue where I could have fixed worksheet formatting in less than a minute IF I was able to delete worksheets. Since you can't delete Excel worksheets unless you're the creator of the document, it took over an hour to complete. Why does Excel have this obnoxious feature? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SHOULDBE ABLE TO DELETE EXCEL WORKSHEETS EVEN IF NOT DOC CREAT
If the workbook is shared, you will be unable to delete sheets.
And that is SO not retarded because it prevents me from deleting a sheet you may be working on. Have a look under ToolsShare Workbook. Sounds to me like you are a newbie to Excel. Would you like some URL's to a few Tutorial sites? Gord On Fri, 8 Sep 2006 19:59:02 -0700, le tamster wrote: Thanks for the insight. But even when I saved as a new document, those options remained and I was still unable to delete worksheets. That's SO retarded. "Gord Dibben" wrote: Your statement "Since you can't delete Excel worksheets unless you're the creator of the document" is incorrect. Worksheets can be deleted by anyone. Exception........... If under ToolsProtection someone has enabled Workbook Protection which will not allow sheets to be deleted if the Structure is protected. The workbook protection must be disabled, perhaps a password is required. Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 15:59:01 -0700, le tamster <le wrote: I had a work issue where I could have fixed worksheet formatting in less than a minute IF I was able to delete worksheets. Since you can't delete Excel worksheets unless you're the creator of the document, it took over an hour to complete. Why does Excel have this obnoxious feature? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions Gord Dibben MS Excel MVP |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SHOULDBE ABLE TO DELETE EXCEL WORKSHEETS EVEN IF NOT DOC CREAT
But if I'm just working on a workbook that has nothing to do with the
original creator anymore, i.e., they won't be working on it anymore, and I've saved it as a copy or new doc for my own use, then it is indeed so retarded that I wouldn't be able to delete a worksheet. Can't they put a function in that when a copy is made, it resets the sharing functions? "Gord Dibben" wrote: If the workbook is shared, you will be unable to delete sheets. And that is SO not retarded because it prevents me from deleting a sheet you may be working on. Have a look under ToolsShare Workbook. Sounds to me like you are a newbie to Excel. Would you like some URL's to a few Tutorial sites? Gord On Fri, 8 Sep 2006 19:59:02 -0700, le tamster wrote: Thanks for the insight. But even when I saved as a new document, those options remained and I was still unable to delete worksheets. That's SO retarded. "Gord Dibben" wrote: Your statement "Since you can't delete Excel worksheets unless you're the creator of the document" is incorrect. Worksheets can be deleted by anyone. Exception........... If under ToolsProtection someone has enabled Workbook Protection which will not allow sheets to be deleted if the Structure is protected. The workbook protection must be disabled, perhaps a password is required. Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 15:59:01 -0700, le tamster <le wrote: I had a work issue where I could have fixed worksheet formatting in less than a minute IF I was able to delete worksheets. Since you can't delete Excel worksheets unless you're the creator of the document, it took over an hour to complete. Why does Excel have this obnoxious feature? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions Gord Dibben MS Excel MVP |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SHOULDBE ABLE TO DELETE EXCEL WORKSHEETS EVEN IF NOT DOC CREAT
When testing new changes to a spreadsheet template, it is not uncommon for
the original creator to save changes as a new workbood in case the changes don't work. Then he/she can reload the last workbook and start again. Also, the creator may have kept the file on a local drive during development, then used save as to put it on the network drive for shared use. It would be irritating and counterproductive if certain settings were reset every time save as was used. Excel has no way of knowing you are not the original creator. If the workbook is shared, try unsharing it. If there is a password (either workbook protection or the workbook is protected and shared) your beef is w/the original creator for not allowing you to delete sheets (which is obviously by design). You should request assistance from him/her. Put me on the side of "so not retarded." "le tamster" wrote: But if I'm just working on a workbook that has nothing to do with the original creator anymore, i.e., they won't be working on it anymore, and I've saved it as a copy or new doc for my own use, then it is indeed so retarded that I wouldn't be able to delete a worksheet. Can't they put a function in that when a copy is made, it resets the sharing functions? "Gord Dibben" wrote: If the workbook is shared, you will be unable to delete sheets. And that is SO not retarded because it prevents me from deleting a sheet you may be working on. Have a look under ToolsShare Workbook. Sounds to me like you are a newbie to Excel. Would you like some URL's to a few Tutorial sites? Gord On Fri, 8 Sep 2006 19:59:02 -0700, le tamster wrote: Thanks for the insight. But even when I saved as a new document, those options remained and I was still unable to delete worksheets. That's SO retarded. "Gord Dibben" wrote: Your statement "Since you can't delete Excel worksheets unless you're the creator of the document" is incorrect. Worksheets can be deleted by anyone. Exception........... If under ToolsProtection someone has enabled Workbook Protection which will not allow sheets to be deleted if the Structure is protected. The workbook protection must be disabled, perhaps a password is required. Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 15:59:01 -0700, le tamster <le wrote: I had a work issue where I could have fixed worksheet formatting in less than a minute IF I was able to delete worksheets. Since you can't delete Excel worksheets unless you're the creator of the document, it took over an hour to complete. Why does Excel have this obnoxious feature? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a group of worksheets with named ranges in Excel 200 | Excel Worksheet Functions | |||
Relative referencing in Microsoft Excel between worksheets | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel needs to have the ability to insert "SUB" worksheets | Excel Worksheet Functions | |||
How can I delete ALL text boxes in Excel worksheets? | Excel Discussion (Misc queries) |