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

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

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

Unfortunately, moving to 2007 was to enhance functionality...but not all
customers of the data have migrated. So forcing everyone to upgrade is not
an option. Nor is working in 2003 because we are reaching the limits of 2003
capability. It was just to slow.

Any other thoughts?

I agree 2007 is cool...but this is going to be a problem.

Thanks

"Nick Hodge" wrote:

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

Pivotman

You will not like this answer. If you are reaching the limits of 2003's PTs,
you are using the wrong tool entirely. The limit of PTs in 2003 are many
thousands of rows. You cannot possibly 'read' that many rows successfully or
see any data pattern. You may want to look at Crosstab queries in Access but
generally these are not as flexible or user friendly as PTs.

So, with your constraints on versions, you are a litlle stumped in excel I'm
afraid

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





"PivotMan" wrote in message
...
Unfortunately, moving to 2007 was to enhance functionality...but not all
customers of the data have migrated. So forcing everyone to upgrade is
not
an option. Nor is working in 2003 because we are reaching the limits of
2003
capability. It was just to slow.

Any other thoughts?

I agree 2007 is cool...but this is going to be a problem.

Thanks

"Nick Hodge" wrote:

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

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