Sharepoint Musings

We were successfully able to load MOSS 2007 on a production box and have couple of sites up and running. Everything was working till the other day, a user complained that he could not find "Connect to outlook" and other Office integration options in the menu when he chose Calendar view on the calendar. There was also no "Datasheet View" on the All Events view of the calendar list. See image below:

Searched all internet and finally found a place in comments somewhere it was mentioned that Client Integration needed to be enabled in order to see this.

So, the solution was in Central Administration->Application Management->Authentication Providers--->Here there is an option to enable client integration. Enable this for the correct application and it works. The menus are now shown as expected.

Next, when I was testing the datasheet option, it wouldn't export but gave me an error stating that the wss Datasheet component was not correctly loaded....

Apparently, the problem was I did not have Office 2007 loaded on my client PC. The web datasheet option is only available if you have Access 2007 on your client machine. However, later I found the following article and followed it.

http://support.microsoft.com/kb/833714

I installed sharepoint support to my installed Office application as above and the datasheet option now works just fine.