Hi,
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 <CenterFooter> of PageSetup. Page formats might be incorrect. Please check and set Page setup options manually.The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
>>>>>>>.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 <RightFooter> of PageSetup. Page formats might be incorrect. Please check and set Page setup options manually.The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
>>>>>> 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