Excel 2007: Publish to Excel Services Option Missing
When I tried to publish an Excel worksheet to Excel Services in MOSS 2007 last month, I was puzzled since I couldn't find the menu option from the Microsoft Office logo button. I followed the instructions exactly from the offline and online help, but cannot find it anywhere. So I just publish the worksheet to a "Document Management Server". However this is not an elegant solution, since the whole worksheet (which may contain sensitive data) was visible to all who can access the report library -- let's wish nobody knows that
. I remembered the option existed when I was using Beta 2 and TR.
I googled (oops... I mean "Windows Lived" -- is it a verb yet?) but couldn't find anything about it last time.
Today I thought I would Windows Lived again to see if anyone has got a solution. At last from this discussion forum I knew that it was because I was using Office Professional! Office Professional doesn't have the Publish to Excel Services feature. Why didn't they say that on the Excel help! So I installed Office Enterprise and voilà, I got what I wanted.