Well, this is an old one, but I always forget about it when I encounter it. When you use a stand alone SharePoint server (for example in a virtual machine like Microsoft VPC or VMware) to develop or test something, not all of the features work. For example:
- DataSheet view will not update rows in a list or document library and will show you an error stating it is offline. "Cannot connect to the server at this time. Changes to your data cannot be saved."
- Office task pane that is supposed to show you "document updates" and "Shared workspace", is also telling you you are offline. "You are currently working offline. Check your network connection and then click get updates."
The reason for this behavior is that the office objects that connects office to sharepoint are checking the network status and they see that you don't have a network (since you are on a standalone server).
Well, one way would be to setup another machine and connect the two, or maybe set up a loopback adapter.
But the easy way to solve this is to just stop the network sensing mechanism and fooling office! Here is how you do it:
- Close all office applications and internet explorer windows.
- Click Start>Run
- write in the text box "net stop sens" and press enter.
that's it! Now the datasheet view will update items and office-sharepoint integration will work smoothly!