>If your e-mail doesn't work, you can try this:
>Download the sample data from
http://www.sunsoft.sk/ftp/test.zip>Open TEST1.XLS - there are two pivottables on the sheet connected to the same pivotcache. Open VFP and try this code:
>xl=GETOBJECT(,"Excel.Application")
>pc=xl.ActiveWorkbook.PivotCaches(1)
>pc.CommandText = 'select * from DS1 ds1'
>... and I get error OLE error code 0x800a03ec: Unknown COM status code... :-(
>When I open TEST2 with one pivottable, all works fine.
>
>Do you have any idea how to reslove this problem?
>Thanks
> Norbert
I haven't seen your data yet but might it be it's related to properties of your cache such as MaintainConnection = .f. Try commenting any properties other than connectionstring, commandtext.
Cetin