Re: 2007 pivot tables in 2003
- From: nick_hodge@xxxxxxxxx
- Date: 21 Mar 2007 12:43:28 -0700
Scott
If you either
1) Create the PT in Excel 2003
2) Save the file as a 97-2003 in 2007
You should be able to open and interact with the PT in Excel 2003. If
you use any new features in 2007 you will get the compatibility
checker warning of what may be lost, so you should stick to things and
limits that apply in 2003.
Onece you have a file as an *.xls (2003) file saving in 2007 will
retain this, you wll have to explicitly save to an *.xlsx to upgrade
it and of course you will loose the intercativity in prior versions
HTH
Nick Hodge
Microsoft MVP - Excel
www.nickhodge.co.uk
On Mar 21, 10:22 am, ScottStonehouse
<ScottStoneho...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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).
.
- Prev by Date: Macro Totaling a Column of Numbers
- Next by Date: Re: Missing Drawing Toolbar in Excel 2007
- Previous by thread: Macro Totaling a Column of Numbers
- Next by thread: Re: 2007 pivot tables in 2003
- Index(es):
Relevant Pages
|
