I have a pivot chart report which pulls its source data from SQL
Server database. I have created a copy of this file to point to a
different SQL Server (exact same tables). When I refresh the report,
the chart and pivot are refreshed correctly from the new server.
However the original data still remains (as well as the new data) in
the drop down selection box for the columns.

i.e.
the chart is showing ExecuteDate in the ROW area, JobName in the
COLUMN area and the number of minutes each job ran each day as the
DATA. The graph plots each job showing the duration over the last 30
days.

In the JobName dropdown, I can see all of the jobs from the original
SQL Server, as well as the second one.
In reality I have copied this file over 5 servers, so I have lots of
redundant data I can't seem to remove!!

How can I clear this out?

Thanks, Ben.