Solved

Sharepoint Server 3.0 and Excel 2010 synchronize issue

Posted on 2010-09-22
3
862 Views
Last Modified: 2012-08-14
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.
0
Comment
Question by:jay_mcdaniel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
chapmanjw earned 500 total points
ID: 33738723
The Excel 2010 synchronization feature is designed for SharePoint 2010.  It basically lets two people edit the Excel document at the same time.

SharePoint 2007 (3.0) doesn't support the synchronization  feature, and sometimes Office 2010 doesn't always differentiate between 2007 and 2010 when it displays features.  (Like, in my opinion, it would be nice that since SharePoint 2007 doesn't support this feature to have the button not even display.)
0
 

Author Comment

by:jay_mcdaniel
ID: 33748628
Well that will be such a bummer for them. Looks like everyone will have to downgrade or just use the IE browser to edit files. Thanks a bunch for clearing that up for me chapmanjw.
0
 

Author Closing Comment

by:jay_mcdaniel
ID: 33748643
The answer was just as I thought it was, just not compatible.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question