I am trying to create a pivot table report whch uses data from two separate
spreadsheets (Excel 2000). Is there any way to combine two page fields into
one, e.g.; the first spreadsheet has data from the year 2000-2001 and the
second sheet has the same type of data for the years 2002-2003. I would like
to create a pivot table report which combines both year ranges into one page
field?

Can anyone help?

Thx,
--
LPS