Solved

SharePoint 2010 and Excel 2010 questions

Posted on 2011-09-04
4
863 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharepoint 3.0 migration 4 95
Sharepoint server slow 4 71
SharePoint 2016 Licensing - the same as 2013? 7 52
SharePoint 2013 Search not working 9 72
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…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

738 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