Unable to Share Workbook

[Burnt]

I had orginally designated a workbook as shared. Now the workbook is no
longer designated as shared. To make matters worse, the "Share
Workbook" option in Tools is not available (it is shaded out). Did I
make an error in some setting?

[JHalsall]

I am having a similar problem with a couple of my worksheets and can't figure out a reason why it won't let me share these, any ideas/solutions would be appreciated.

Thanks in advance.

[JHalsall]

I have found the problem (via another thread) you cannot share a workbook that contains lists (though excel doesn't tell you this), you need to go through the workbook and select each list you have created and either remove it or convert it to a range instead.