How to change SQL database location used in Excel 2000 pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have moved the relevant database from one SQL server to another, changed
the relevant ODBC data source which now works for other applications but all
of the pivot tables etc linked to the database through Excel cannot be
redirected to the new database location. Final solution is to recreate them
all from scratch.
 
Not familiar with connections to sql, but can you not re-invoke the pivot
table wizard and press the back button in the dialog that results, this
should give you the option to re-establish the data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Database links? 3
Excel / Sql Server / Pivot Tables 2
Pivot Table Range ("Database") 1
Grouping dates in pivot table 3
Easy way to change Pivot table source files? 5
Refreshing a pivot table 1
Limit using pivot table with Access database? 1
Q: Change pivot table source path? 1

Back
Top