I have successfully created a pivot table in Excel 2007 (VERY much improved
process!). I save the workbook as Excel 2003 compatable and then send it to
another user who has Excel 2003. When that user opens the file, he can see
all the tables and charts, however, if he adds any data to the list and then
attempts to refresh all the tables and charts, it will not do so.

Am I trying to do "mission impossible" or am I doing something incorrectly?

Any help would be much appreciated.

Dan

Hi Dan

Afaik Pivot tables created in 2007 does not work with older versions.

HTH. Best wishes Harald

"DanL" wrote in message
...
I have successfully created a pivot table in Excel 2007 (VERY much improved
process!). I save the workbook as Excel 2003 compatable and then send it
to
another user who has Excel 2003. When that user opens the file, he can see
all the tables and charts, however, if he adds any data to the list and
then
attempts to refresh all the tables and charts, it will not do so.

Am I trying to do "mission impossible" or am I doing something
incorrectly?

Any help would be much appreciated.

Dan

AHA, said the non-texting blind man!! <g

Thank you again.

Dan

"BNT1 via OfficeKB.com" wrote:

As Far As I Know

regards

DanL wrote:
Thank you, Harald. I guess this falls under "suspicions confirmed"!!

would you mind telling me what "afaik' means in your reply?

Dan

Hi Dan

[quoted text clipped - 16 lines]

Dan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1

Gents,
I am having the same problem here.
I have created a pivot table in Excel 2007 and saved the workbook as Excel
2003 compatible and then send it to another user who has Excel 2003. When
that user opens the file, he can see all the pivots but cannot change them.
I have seen in this discussion here, that there is only a AFAIK response.

Does anyone know if we really cannot use 2007 pivots in 2003? If there is no
possibility and pivots are really not compatible, then this really seem to be
a big mistake from Microsoft...

Thanks.

R. Saddy




"DanL" wrote:

AHA, said the non-texting blind man!! <g

Thank you again.

Dan

"BNT1 via OfficeKB.com" wrote:

As Far As I Know

regards

DanL wrote:
Thank you, Harald. I guess this falls under "suspicions confirmed"!!

would you mind telling me what "afaik' means in your reply?

Dan

Hi Dan

[quoted text clipped - 16 lines]

Dan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1