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.

"Eelco" wrote:

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).
--
Mvg,

Eelco