Following is log of an error that we are frequently getting while invoking excel and perfoming calculations using asp.net (Excel 2007)
17Jul2009 13:03:42 INFO ODSReports.OrdStatsByPercentGraph - .Creating chart for OrdStatsBySKU
17Jul2009 14:14:51 WARN ODSReports.ODSExcelFunctions - Unable to programmatically set
>>>>>>>.Exception here - Remote procedure call failed. Note that the chart prep has taken 1 hr +
17Jul2009 14:14:51 WARN ODSReports.ODSExcelFunctions - Unable to programmatically set
>>>>>> RPC is unavailable...
Notes:
1) We get this error only when we use a large dataset (e.g. working with > 10000 rows). Things work perfectly when we use smaller datasets (e.g. 1000 rows etc)
2) We did not see this on Excel 2003. Excel 2007 seems to be slower and also having this problem.
Do you know of any info/issues regarding excel 2007 and RPC disconnect/timeout etc ?
Thanks a lot for your time
Replies
Know the answer? Post it — somebody with the same question will find it here.