Change Pivot Table Data-Source Connection

[Beema]

I have a fairly huge Pivot Table which source's its data from a SQL Server
ODBC connection.

I need to change this connection but keep the pivot table - I can't seem to
do this. When I click on Pivot table, then the back button to show the list
of tables, it won't allow me to go back another time to re-choose the actual
ODBC connection?

Is this possible?

My last resport is to re-create the whole Pivot table again, but I'm trying
to avoid this......

Thanks
Ben