delete a spread sheet
I want to delete spread sheet in a shared workbook. Is it possible?
Mats |
delete a spread sheet
Shared workbooks have limits on what you can do to the workbook structure.
You would need to first unshare the workbook before deleting the sheet. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mats" wrote: I want to delete spread sheet in a shared workbook. Is it possible? Mats |
delete a spread sheet
Hi,
you mean a sheet in a workbook, position on the sheet, right click on the mouse, delete If you didn't create the workbook and the workbook is protected you will not be able to delete it if this helps please click yes thanks "Mats" wrote: I want to delete spread sheet in a shared workbook. Is it possible? Mats |
delete a spread sheet
and just to piggyback, You unshare by going to Tools Share Workbook and
uncheck the share checkbox. This will cause anyone who is still accessing the file to lose connection and have only read access to the most recent update they have done. So, may want to let everyone know if you're about to do this. "Luke M" wrote: Shared workbooks have limits on what you can do to the workbook structure. You would need to first unshare the workbook before deleting the sheet. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mats" wrote: I want to delete spread sheet in a shared workbook. Is it possible? Mats |
delete a spread sheet
I have unprotected the workbook, unshared the workbook and Delete Sheet is
still greyed out. What am I doing wrong? This is in Excel 2007 and I saved it as a xlsm macro enabled workbook. -- Shary "Sean Timmons" wrote: and just to piggyback, You unshare by going to Tools Share Workbook and uncheck the share checkbox. This will cause anyone who is still accessing the file to lose connection and have only read access to the most recent update they have done. So, may want to let everyone know if you're about to do this. "Luke M" wrote: Shared workbooks have limits on what you can do to the workbook structure. You would need to first unshare the workbook before deleting the sheet. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mats" wrote: I want to delete spread sheet in a shared workbook. Is it possible? Mats |
delete a spread sheet
To verify, have you removed any protect worksheet as well? Also, does the
workbook happen to have a macro, or any VBA code in it? Right-Click on the tab name and select View Code. Not sure if you'd have any code there locking the tabs... If nothing else works, and you have no programming in the background, you can always move all other sheets to a new workbook and overwrite this one. May not fix, but it sure does work... "Shary" wrote: I have unprotected the workbook, unshared the workbook and Delete Sheet is still greyed out. What am I doing wrong? This is in Excel 2007 and I saved it as a xlsm macro enabled workbook. -- Shary "Sean Timmons" wrote: and just to piggyback, You unshare by going to Tools Share Workbook and uncheck the share checkbox. This will cause anyone who is still accessing the file to lose connection and have only read access to the most recent update they have done. So, may want to let everyone know if you're about to do this. "Luke M" wrote: Shared workbooks have limits on what you can do to the workbook structure. You would need to first unshare the workbook before deleting the sheet. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mats" wrote: I want to delete spread sheet in a shared workbook. Is it possible? Mats |
All times are GMT +1. The time now is 04:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com