can't modify pivot in older version

jenn · External Since: May 30, 2006 Posts: 45

I have 2007. I send pivot tables to someone with 2003 (with the compatibility
pak installed). They try to make modifications and they can warned that they
can't because they are using an older version of excel. Is there another
compatibility pak?

Nick Hodge · External Since: Aug 08, 2007 Posts: 20

Jenn

The Pivot Tables were ramped up dramatically in 2007 so you have only a
couple of choices

1) Save the file as a 2003 version and accept the changes made by the
compatibility checker
2) Save as a 2007 file and the user with the comp. pack will have a
read-only view of the PT

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT DeleteThis @zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog

"jenn" <jenn DeleteThis @discussions.microsoft.com> wrote in message
news:EB56B3AF-BD62-471E-8C5D-5FEA0F304799@microsoft.com...
>I have 2007. I send pivot tables to someone with 2003 (with the
>compatibility
> pak installed). They try to make modifications and they can warned that
> they
> can't because they are using an older version of excel. Is there another
> compatibility pak?