Sharepoint Server 3.0 and Excel 2010 synchronize issue
Posted on 2010-09-22
I am having an issue with something I know should work and need some input on this. I have a sharepoint server 3.0 running on SBS and when an employee opens a shared document from the library all goes well. They are able to edit the document right from the browser and everyone is alerted on the changes and such. But there is one employee that wants to be able to export the document, make changes to it and synch the doc back to the server using excel 2010. The problem I am bumping into is when the document opens in Excel the "Synchronize List" button highlighted but the doc asks do you want to enable or disable macros. She clicks on enable and the doc opens and then the "Synchronize List" button becomes greyed out. We even tried to disable macros and the doc doesnt even open so that is not our option. Just trying to find out I guess if this is even possible using Excel 2010 with Sharepoint Server 3.0. All help is appreciated.