Solved

SharePoint 2010 and Excel 2010 questions

Posted on 2011-09-04
4
871 Views
Last Modified: 2012-05-12
I’m currently using SharePoint 2007 with Excel 2010.

I have many excel files on my SP 2007 server and I can click on them and open them with Excel 2010 and click the edit button in excel to be able to edit the excel file and save the changes back to SharePoint.

My question regarding SharePoint 2010 with Excel 2010 is does SharePoint 2010 allow you to do this?  In other words, does SharePoint 2010 (enterprise version) allow you to open excel file in Excel 2010 (not just in read only mode) and be able to edit the file in Excel 2010 and save it right back to SharePoint 2010?

Or do I need office web apps installed on SharePoint 2010 to accomplish this task?

Thanks
0
Comment
Question by:speedway
[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
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
Mike12341567890 earned 500 total points
ID: 36481265
It works the same way as in SharePoint 2007. The office web apps are not needed. The advantage of the web apps is that you can edit and view the files direcly in SharePoint if you want. You can disable this behaviour by activating/deactivating a included feature.
0
 

Author Comment

by:speedway
ID: 36482038
Thanks for the prompt answer.  However, I’m not getting SP 2010 Excel files to open correctly on the new setup.

I’ve installed SharePoint 2010 on a Windows 2008 server and copied over my database.  I guess some things have changed regarding Excel services in SP 2010.  When I click on an Excel file on my SP 2010 server in a document library, IE9 automatically opens it in the browser unlike previously in SP 2007, it only opens up Excel web access content in the browser.

However, when I click on File - open in Excel or click on the dropdown box for the file and choose open in Excel, my Excel 2010 gives me error saying “could not open file” and then another error box “cannot find the file…”

Open Error1
Open Error2
I have no problem downloading a copy to my local computer and then opening it.

I checked my setup and I believe it looks like the same as my SP 2007.  I have only Windows authentication enabled.  I tried both on the intranet without SSL/security and on the internet with SSL and had the same problem.

On FireFox, when I click on a file, the FF browser prompts to either open it or save it.  If I open it, Excel 2010 does open the file but it is in read only mode and if I make changes and save it, it saves to my local computer’s temp folder.

My setup is Windows 7 64bit with Office 2010 64bit using IE9 32bit.

I tried this on a Windows XP machine with Office 2007 it would open it but only in read only mode with no option to edit it (like I had before with SP 2007).

I tried on a Windows 7 32bit machine with Office 2010 32bit.  Excel on that machine would prompt me with the option to open it in read only mode or edit it but whatever option I choose, I would get the same “could not open file error in IE”

Since I have this working with my SP 2007 server on with my Windows 7 64 and Excel 2010 in the same network and environment, am I missing some configuration on the SP 2010 server?

Are there changes I need to make to Office 2010?

I’ve searched on the web for answers and so far have tried many tweaks to my IE9 and Office 2010’s settings and had no luck.

Excel files in .xls, .xlsx and Word docs all have the same error.  PDF files open my browser without problem.  
0
 

Author Comment

by:speedway
ID: 36492669
Can anyone confirm Office 2010 works with SharePoint 2010 from actually using or testing these two products together?

What I mean is, can you actually open a word or excel file from SharePoint 2010 from your Office 2010 program on your personal computer?

I have not been able to get this working so far.
0
 

Author Closing Comment

by:speedway
ID: 36506827
I did confirm with SP 2010 site admin he indeed can use Excel 2010 to open files on this site.  Must some misconfiguration with my setup.  Thought haven't find the cause yet.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
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.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

628 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