Share workbook option is disabled

[hsk]

I have a worksheet which i want to share but the option "Share workbook" in Tools menu is disabled.

I searched for reason and found out the option is disabled if sheet contains any "Lists"

I don't know the use of the "Lists" ..... how can i remove the same from my sheet ??

Any idea ?

 

[xenou]

On the Main Menu:
Data | List | Convert to Range...

Workbooks also cannot be shared on a web server...if that is a possible cause for you.

Regards.

 

[hsk]

Nop ...... even "Convert to Range" is also disabled .....

 

[xenou]

There are probably no Lists in your workbook.

Can you start a brand new workbook and share it ... ?
--If not, the problem is your server/network.
--If so, then there is something about your workbook itself that is interfering...but what? I am sorry I don't know ... there are many things that can't be done in shared workbooks but I did not think they prevented workbooks from being shared...only limit the action once the workbook is shared.