How to enable the Protect and share workbook button

  • Hi,
    When i am selecting the Format as Table the Protect and share workbook button in Review tab is disable. I want to enable that command button. How it is possible. I can't even unformat that table. Is there any command for unformat the table for enable the Protect and share workbook button.

  • Re: How to enable the Protect and share workbook button


    When using the Format as Table option you cannot Share the workbook - not sure why - but it a built-in setting that can't be changed.


    To unformat you use the Convert to range button in the Design ribbon when the table is selected.

    There are three types of people in this world.
    Those who can count and those who can't.

  • Re: How to enable the Protect and share workbook button


    Thanks for your suggestion. Actually i have a worksheet in which i am getting outlook mail names in excel sheet & the data received directly in Table format. When i close the file after save the module is delected. It is happening by this format only. So i want to unformat that table before close.