.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

issue reproduces only in Excel 2010

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :.NET Framework
 

Hi,

 I am facing the issue only in Excel 2010 and this issue reproduces in the following code snippet. Please see the given details and help me on this.

 

 Interop dll and Version:

Microsoft.Office.Core                    -              version 14

Microsoft.Office.Interop.Excel -              version 14

 Issue Resolution:

-


View Complete Post


More Related Resource Links

Sharepoint 2010 w/ Webapps, Excel Services Webpart display issue.

  

I have Sharepoint 2010 installed with WebApps 2010, and can use it to edit documents in IE without any problems at all.  Word and Excel work just fine.

But on MOSS 2007, I could have it display the Excel page as a webpart, that you can click on, and open it anyways.   But no matter what I try in 2010, all I get is the Webpart heading has a link to the file that works, but the contents always reads:

To display a workbook in this Web Part, you must first select the workbook.

To select a workbook, open the tool pane, and then edit the Workbook property.
Click here to open the tool pane.

 

How can I fix the preview in the webpart?

 

Thanks!

-Mark


Outlook 2010 / Sharepoint authenthication issue

  

Hi all,

I'm using Outlook 2010 on Windows 7 64bit.

My company uses a hosted Sharepoint server (I guess it's Sharepoint 2010). There's a team calendar, which I would like to connect to my Outlook 2010. Linking it to Outlook works fine until it tries to update the calendar with the Sharepoint server. I shows the following error:


Error (0x80070005) when running the task "SharePoint": "You are not authorized to view the SharePoint list (team calendar). Contact the administrator of SharePoint site. HTTP 401."

So this tells me, I'm not authorized to connect - which is quite clear because Outlook never asked my for any username or password.

Funny thing is when I try to add an internet calendar (Right mouse click on calendars, Add calendar, Internet calendar) and use the url of the sharepoint list, it asks me for username and password, but then fails to add the calendar, as it isn't a webcal (which is OK).

BUT: As Outlook at this moment has the username and password, the exisiting Sharepoint calendar synchronizes correctly. This works until Outlook is being restarted.

Does anyone have an idea why I'm not asked for any authentication? Maybe there's some setting I haven't found yet? It works with trying to add the webcal any time when I start Outlook, but t

In sharepoint excel working fine in office 2007 but not in office 2010

  

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

 


export to excel issue

  

Hello ,

I have a browser enabled form which i published to sharepoint ..now i want to export the contents of the form to excel..i have 1 repeating table and two repeating sections ..whenever i go to export to excel and then choose just one repeating table or a repeating section or any option other than export all form data i get an error ...first the progress bar just freezes and then when i end the task through task m anager i get a msg that microsoft excel could not start.make sure excel is installed correctly and then try again....

Can somebody tell me how to debug this..i have tried the export of a form containg repeating table and sections and it works good ..so that means there is some problem with my form..so now can somebody give me an idea as to what can the problem be and how can i debug it.

Thanks


Sharepoint 2007 and Excel 2010 features

  

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

 


Sharepoint 2010 power tools visual sandboxed web part issue!!

  

Hi guys

I tried to use a simple hello world web part with with sharepoint power tools the solution is added ok but when I try to add the web part to the page I get this error "Unable to load assembly group. The user assembly group provider...." Any thoughts

Regards

Rodolfo

 

 


rsoares

ASP.NET Excel Export Issue

  

Hi,

I am trying to export data from SP to a .xlsx sheet. Total no of rows is more  than 15000 with total of 13 columns.The data is generated with the help of SQL Server SP. Till this point it is working fine. However while exporting to excel I do not get any data , the excel  has blank content.

If I have records less than 12000 it generated the excel report with  relevant data. However as row increases the report is blank.

Also the excel is generated through the code but when I deploy to server and try to generate it generates a blank excel. 

 Please advice what needs to be done. I have tried multiple options but none works.


SharePoint 2010: Excel Services Resource Center

  
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.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

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

Sample: Business Connectivity Services Excel 2010 Add-In

  
Download a sample add-in that shows how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

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

Sample: Developing Applications in SharePoint 2010 Using 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.

Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word

  
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.

Video: Excel Services and SharePoint 2010 Business Intelligence

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

Data mining addin for excel 2010

  
Anyone know when be available the data mining addin for excel 2010?  in this moment the current addin doesnt work in excel 2010 .. Thanks for any infoJuan Alvarado - MVP SQL SERVER

Infopath 2010 Browser Based Form Vs Infopath 2010 Filler Based Form Issue

  
I have created a detailed infopath form that is connecting to multiple sharepoint lists, some of which contain thousands of rows and dozens of columns.  To tailor for the data load i have enabled the form to only pull in data as needed and on some of the lists i have created 5 or 6 data connections to the same list, each only looking at a certain set of data, and as you make your way through the form selecting your options, the data is pulled in. If i preview this form from within Infopath or if i launch it using Infopath filler this works great, the data is pulled through in under a second.  However if i then publish the form to the browser and launch it through the browser, it now takes roughly 30 seconds to pull in the data. My question is therefore this,  Is there something i can do to speed up the way the data is pulled in when launched through the browser?  are there transport protocols i can alter or something like that? maybe config in central admin or infopath config? any help would be gratefully appreciated as if i can not get the form to pull the data in fast through the browser then the whole project is a waste of time as my management team will never go for the solution if it is slow and will get slower as more data is added. thanks

Infopath 2010 Browser Based Form Vs Infopath 2010 Filler Based Form Issue

  
I have created a detailed infopath form that is connecting to multiple sharepoint lists, some of which contain thousands of rows and dozens of columns.  To tailor for the data load i have enabled the form to only pull in data as needed and on some of the lists i have created 5 or 6 data connections to the same list, each only looking at a certain set of data, and as you make your way through the form selecting your options, the data is pulled in. If i preview this form from within Infopath or if i launch it using Infopath filler this works great, the data is pulled through in under a second.  However if i then publish the form to the browser and launch it through the browser, it now takes roughly 30 seconds to pull in the data. My question is therefore this,  Is there something i can do to speed up the way the data is pulled in when launched through the browser?  are there transport protocols i can alter or something like that? maybe config in central admin or infopath config? any help would be gratefully appreciated as if i can not get the form to pull the data in fast through the browser then the whole project is a waste of time as my management team will never go for the solution if it is slow and will get slower as more data is added. thanks
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend