Hi again,

I've figured it out but if anyone knows a better way please advise...

Open the Wizard and click on 'Back' to go 'PivotTable and PivotChart Wizard
and click on the 'Get Data...' button.

You are prompted with the error [Microsoft][ODBC Microsoft Access. The
Microsoft Jet database engine cannot find the input table or query. Make
sure it exists and that its name is spelt correct.

I can't recall how but you get directed to the Microsoft Query Application
then click on view SQL and change it to the new path and/or table names.

Done!

--
Andrew


"Andrew" wrote:

Hi,

I have change the table name (from table A to Table B). In Excel I normally
use the 'Refresh Data' icon to refresh a pivot table with updated data. When
I try to update it now I get the error [Microsoft][ODBC Microsoft Access
Data] The Microsoft Jet database engine cannot find the input table or query.
Make sure it exists and that its name is spelt correctly.

I know the 'easy' option is to rename the table back to 'Table A' but alas I
can't.

How do I go about redirecting the source.

--
Andrew
260707