Sharepoint 2010 and Excel 2007

Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.

 

This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.

 

Can you let me know why is problem is coming and how to resolve this.

 

Thanks

Sanjeev Tiwari

 

Does Sharepoint 2007 Server support the new Excel 2010 feaures like slicers? Or do i have to have Sharepoint 2010 to get that working (considering all other components besides Sharepoint 2010 are available in my Sharepoint 2007 environment) ?

- Thanks

RK

 

Hi,

 

I am creating a windows utility where user select list from a windows form combo box and inserting the excel data into the sharepoint list.

Issue that i am facing is, SharePoint runs on VS2010 project properties Platform Target as "Any CPU" while excel 2007 driver "Microsoft.ACE.OLEDB.12.0;" workins with Platform target as "x86".

 

Both are not working with each other, while if I am running them separately, they are working.

 

Kindly suggest.

 

Samagra

 

 

Are you looking to learn about Excel Services programmability capabilities? Learn about Excel Web Services, UDFs, the Excel Web Access Web Part, REST, and ECMAScript support.

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Learn about the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Download sample code that demonstrates the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

This article describes a rich document assembly solution that takes Word 2010 documents, Excel 2010 documents, and PowerPoint 2010 documents and merges them together to form a final report in Word. It does all of this from a SharePoint 2010 Web Part.

Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)

Watch the video and explore code as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

Explore the code in this visual how-to article as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

Is it possible to have the same look and feel/theme of sharepoint 2007 in SP 2010? Even when you upgrade from 2007 to 2010, how can you retain the default look and feel of 2007 in your new SP 2010? thanks.

After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

I have a SPF server that I recently upgraded from WSS 3 using the database attach method. The new server configuration is SQL 2008 R2 with SPF 2010 on Windows 2008 64bit SP2. Mostly things are working fairly well, though there have been a few fires to put out. The latest inflamation seems to be centered around ActiveX controls for Office 2007. I'm getting the following message whenever I try to create a new document using the New button: " 'New Document' requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the 'Upload Document' button." On the client side, the browser is IE8 on Windows 7 (Windows is 64bit, though the browser is in 32 bit mode.) using Office 2007. I've also had the same problem with systems running XP. In terms of troubleshooting, other activeX related features seem to be working fine. I can open datasheet views, if I click on a document, it will open in the appropriate client. However, I have some libraries where the Word document template opens the document information panel and those will give thhe following message on open: "One or more ActiveX controls could not be displayed because either: 1)Your current security settings prohibit running ActiveX controls on thi page , or 2) You have blocked a publisher of one of the contols. As a result the page mi

hi, i am looking, if some one know about the details or link, for the details about the Sharepoint 2010 integration with Office 2003, 2007 and 2010 versions. We will be migrate in couple of months to 2010 but we have mixed flavor of the office version in our environment. We have 2003, 2007 and 2010. Is their any blog post or anyone know what is now possible with 2010 but not in the 2007 or 2003. like a comparison chart.   thanks WSi am at entry level administrator