I don't know what you mean by "the query" but I can send you the workbook
for your inspection if you like.

Ron

"Mary" wrote in message
...
Ron,
can you post the query?
Mary

"Bogey Man" escribió en el mensaje de noticias
...
I have created over the years a pivot table using Excel 2000 that tracks
heating every day of the year. When I bring the Excel 2000 workbook into
Excel 2007, the pivot table looks ok but when I refresh the data, I get
very strange results. The pivot table is actually a summary of furnace
usage and sums the usage for each month and gives a grand total for each
year at the bottom.

How can I get to use the Excel 2000 data and Pivot Table in Excel 2007?

Thank you

--
Ron P

If we are what we eat then: I'm fast,
cheap and easy







--
Ron P

If we are what we eat then: I'm fast,
cheap and easy