Hi Ron

Thanks for that link. I just went there and had a browse around.
That was my old University, but when I was there microcomputers weren't
around, just a mainframe Elliott 803 .
Didn't have the luxury of an IT Services department then to help the
students, but its good to see that they provide it now.

--
Regards

Roger Govier


"Ron Coderre" wrote in message
...
See if this link:
http://www.rdg.ac.uk/ITS/info/traini...s/excel/query/

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Vic" wrote:

I have a workbook with several sheets that has a pivot table per
sheet. The
pivot tables access a sql database. The data is filtered on the
period. The
filter is hardcoded into Microsoft query. All the pivot tables uses
the same
filter, but very disparate data.

Is there any way that I can use a variable in the query that
references
cells in the workbook?