Solved

Sharepoint Server 3.0 and Excel 2010 synchronize issue

Posted on 2010-09-22
3
824 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
  • 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now