Nick, i just realized that I never said thanks...The advice, as always, was
great.

Regards

"Nick Hodge" wrote:

This may also help

http://blogs.msdn.com/excel/archive/...30/730796.aspx

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
web: www.excelusergroup.org




"Nick Hodge" wrote in message
...
Pivotman

This is an area you will really struggle with when backward saving an
XL2007 file.

This was completely re-worked... compact form, number of unique items,
etc, etc were all extended an 'improved'.

Certainly I would start with a file in Compatibility Mode as this will
restrict you to 2003 limits and features. take note of the compatibility
checker when saving and really, use 2003 if your users are mainly on that,
or the superb additional features of 2007 if your audience uses it too!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
web: www.excelusergroup.org



"PivotMan" wrote in message
...
I have upgraded to excel 2007 and am having a problem saving items down
to
2003. Specifically, If you create a pivot table that uses the entire
column
as a range in 2007 and then save the file down to 2003, it converts the
pivot
table to values.

Now I realize that there are more rows in 2007 than 2003, but that does
not
seem like a logical answer. I have 15,000 rows of data...well below the
limit in both 2003 and 2007.

Any insights..this is a major problem for me. I create the pivot tables
with open ranges to allow me to update the data set on a daily basis from
a
system feed. I need it to dynamically set the range..the only good
answer i
came up with is to open up the range.

As always appreciate any help.

Thanks