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
workbook that contains lists (though excel doesn't tell you this), yo
need to go through the workbook and select each list you have create
and either remove it or convert it to a range instead