View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ScottStonehouse ScottStonehouse is offline
external usenet poster
 
Posts: 3
Default 2007 pivot tables in 2003

I have done some reading on using 2007 pivot tables in 2003. So I know that
the pivot tables get a version stamp and you can't edit a 2007 pivot table in
2003.

Is there any way in 2007 to create a 2003 pivot table?

I have an application that dumps data into a spreadsheet (from SQL Server)
and then pivots a report. These reports are interactive reports, in that the
end user can change the pivot table to see what they are interested in.

If I do this in 2007, and my end users are in 2003, they no longer have that
interactivity. I need to correct this problem or live with 2003 until all
our users upgrade (could be years).