+ Reply to Thread
Results 1 to 4 of 4

how to delete a tab if the file is shared?

  1. #1
    Registered User
    Join Date
    06-09-2006
    Posts
    62

    how to delete a tab if the file is shared?

    Hi all,

    I have a document and 3 tabs at the bottom (Sheet1, Sheet2 & Sheet3)
    I wish to delete Sheet3, for this I right click 'Sheet3' and for some reason, the option 'delete' is not highlighted.

    * the file is Shared (not sure this has something to do with that).

    Thanks for any pointers

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    thats why ,there are lots of things you cant do with shared workbooks.
    unshare workbook then delete ,simple as that

  3. #3
    Registered User
    Join Date
    06-09-2006
    Posts
    62
    how do you do that (unshare)?
    thanks

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    tools/shareworkbook
    and uncheck the allow changes by more than one user box.
    if it's in use make sure all people sharing have saved changes before you unshare or their data will disappear

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1