How can I copy a linked excel doc including the source database

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

Guest

I have an access database which is linked to an Excel doc via pivottables
when I copy both files the excel doc is still linked to the database on the
old location. How can I change the location to search in out of excel. It's
not working via data range properties (gray).
 
Click in pivot table and start the Pivot Table Wizard from the pivot table
toolbar. Go back a step or two and you can redefine ranges.
 
You must log in or register to reply here.

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

Link, drop link, relink 2
Excel Run-time error '1004' General ODBC Error 1
Scraping/listing document URLs on a server that don't have web pages/existing links? 2
Dynamically change the database a PivotTable references 2
Pasting Selected Excel Cells into a Word Doc 1
Auto Refresh Pivot Table after Source Data is Refreshed 0
Excel Create a New line in a Word Link without double "" around result 0
Copy value from changing cells without VBA 1

Back
Top