I used to use MIcrosoft's OWC with VFP9. I almost exclusively used the Pivot Table object. I implemented it mostly for use connected to SSAS cubes. What I liked most about this control was that it could be exported as an Excel PivotTable but always connected to the cube. So if a user used the cube and arranged it the way they wanted, they could export it as an Excel PivotTable and said table was the one that the user used in their daily work and every time they wanted to see the updated data they simply opened the table and it refreshed her.
But now the export function no longer works correctly, sometimes it does, sometimes it doesn't and I think it is due to the new versions of Excel.
Is there an ActiveX or .NET control that can be used with VFP9 that can replace OWC and connect to SSAS cubes?