can't modify pivot in older version

[jenn]

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]

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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog