Share Workbook - greyed out??

[tbablue]

Anyone have any idea what criteria would 'grey out' the option to 'Share Workbook' under TOOLs menu?

I cant see any macros in the workbook and protection is turned OFF.

Any othe rideas?

 

[Colin Legg]

Do you have the workbook opened as read-only?

 

[tbablue]

Nope. I can 'Save' & 'Save As'.

 

[Colin Legg]

Is it only greyed out for this particular workbook, or always?

 

[tbablue]

Just this workbook.

I'm guessing it's because some kind of formatting or something has been applied that isn't compatible within a Shared workbook - but the formatting seems quite straight forward; no merged cells, etc.

I'm kinda stumped!

 

[Colin Legg]

Are you using Excel 2003? The share workbook command is disabled if your workbook contains any lists (made via the Create List option).

 

[tbablue]

BINGO!

Thanks for your attention.

:D

 

[Colin Legg]

Phew! I only had one more suggestion after that one!

 

[Sailor Sam]

I know this is an old thread, however I am experiencing exactly the same thing.

I have a single workbook, in Excel 2003 which the:

Tools=>Share Workbooks....

is greyed out. It's relevant only to this specific workbook. I inherited the Workbook from a colleague at work. It's pretty big, about 5 Mbytes. It had a list in it, which I converted to a range.

I saved the Workbook, closed it, killed Excel, re-opened the workbook, and no joy.

Any suggestions would be greatly appreciated.

Thanks in advance.