I have a pivot table based on a SQL Server view. The data from the view
(basic select with no where clauses) which is stored in "Sheet1"

I created the Pivot table, selecting the "Create New Worksheet" putting the
Pivot Table on Sheet4.

If I select "Refresh Data" on the Pivot Table (Sheet4), it doesn't actually
refresh the data in Sheet1 (i.e. re-running the select from the database) it
only refresh's the Pivot Table from the data already contained in Sheet1,
effectively doing nothing.


The workaround is to go to Sheet1, select "Refresh Data" which querys the
database, then go to Sheet4 & select "Refresh Data" which refresh's the
Pivot Table contents.

I *used* to be able to refresh directly from Sheet4 which re-ran the db
query & updated the Pivot Table in one go..

How is this done?