Help with 0x800A03EC error

[dtqzdp]

Hi,<BR><BR>I am trying to create a pivot table in an excel workbook and I can do anything I want to the sheets but when I execute the following code, then line with 'create table' generates an error.<BR><BR>with objexcel.ActiveWorkbook.PivotCaches.Add(Excel.XlPi votTableSourceType.xlExternal)<BR>.CreatePivotTableTableDestination:=objexcel.active sheet.Range("A3"))<BR>end with<BR>I get...<BR><BR>Exception from HRESULT: 0x800A03EC. <BR>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <BR><BR>Exception Details: System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC.<BR><BR><BR>Any help would be greatly appreciated. By the way this code works fine in VB.net