Hi All,
We have some code in a Access2010 DB that runs query, creates a pivot table and then exports this to Excel.
It works fine if the host PC is using Excel2007 or better but most of the PC's here at work are using Excel 2002/2003 and it just won't work. The query runs but excel will not open and accept the data and create the pivot table.
I have installed a file convertor on the 2002/2003 PC's to covert excel 2010 to 2002/3 but this still does not work.
I have installed the Access2010 SP1 update, but this also does nothing.
The only PC that does have 2002 excel that does except and open the pivot data has full Access2010 running, the rest, that will not work are using Runtime2010, but can't see that as an issue?
Any ideas anyone?
JohnG
We have some code in a Access2010 DB that runs query, creates a pivot table and then exports this to Excel.
It works fine if the host PC is using Excel2007 or better but most of the PC's here at work are using Excel 2002/2003 and it just won't work. The query runs but excel will not open and accept the data and create the pivot table.
I have installed a file convertor on the 2002/2003 PC's to covert excel 2010 to 2002/3 but this still does not work.
I have installed the Access2010 SP1 update, but this also does nothing.
The only PC that does have 2002 excel that does except and open the pivot data has full Access2010 running, the rest, that will not work are using Runtime2010, but can't see that as an issue?
Any ideas anyone?
JohnG
