G
Guest
I have an Access 2000 database and a copy converted to Access 2003. I
upgraded to Office 2003 Pro (and have all the patches). When I attempt to
refresh pivot tables in either the 2000 or 2003 database (with the pivot
tables created in Access 2000), I get the very informative Microsoft Excel
error, "Problems obtaining data."
If I move either database to another computer running Access/Excel 2003, the
pivot tables refresh fine. I can create a new pivot table in the 2000 or 2003
database and it works fine, although I hate the new format (different topic
and sore subject). I have deinstalled and reinstalled Office 2003 Pro five
times and the problem remains.
Why can't the machine update a pivot table created in Access 2000? It is an
OLE issue where a registry setting may not be set correctly?
upgraded to Office 2003 Pro (and have all the patches). When I attempt to
refresh pivot tables in either the 2000 or 2003 database (with the pivot
tables created in Access 2000), I get the very informative Microsoft Excel
error, "Problems obtaining data."
If I move either database to another computer running Access/Excel 2003, the
pivot tables refresh fine. I can create a new pivot table in the 2000 or 2003
database and it works fine, although I hate the new format (different topic
and sore subject). I have deinstalled and reinstalled Office 2003 Pro five
times and the problem remains.
Why can't the machine update a pivot table created in Access 2000? It is an
OLE issue where a registry setting may not be set correctly?