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
|