View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bogey Man Bogey Man is offline
external usenet poster
 
Posts: 9
Default Excel 2000 Pivot table in Excel 2007

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