Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SharePoint 2010 and Excel 2010 questions

Posted on 2011-09-04
4
Medium Priority
?
884 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 2000 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

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

721 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