Mac Excel 08 puts "#VALUE!" in all pivottable references when opening an WIN Excel 97 file.

[John_Golfin]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I recently bought a MacBook Pro 15.4, 3.06GHz, 8GB RAM running Mac Excel 2008 (v12.1.0 080409). When I use Mac Excel 2008 to open excel files that I created in Windows Excel 97 2004, all my pivot tables convert correctly but any REFERENCES to any fields within the pivot table do NOT show the valid values that Excel 97 showed. Instead all refrences have "#VALUE!" in the cell. There is a valid reference startement there but no valid value. How can I fix this?

 

[John McGhie]

You are a few updates behind: make sure your copy of Mac Excel is fully
up-to-date.

Also: Check the Excel KNOWN ISSUES Help topic. There is an issue with using
GETPIVOTDATA in .XLSB format.

Hope this helps

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I recently bought a MacBook Pro 15.4, 3.06GHz, 8GB RAM running Mac Excel 2008
(v12.1.0 080409). When I use Mac Excel 2008 to open excel files that I created
in Windows Excel 97 2004, all my pivot tables convert correctly but any
REFERENCES to any fields within the pivot table do NOT show the valid values
that Excel 97 showed. Instead all refrences have "#VALUE!" in the cell. There
is a valid reference startement there but no valid value. How can I fix this?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[John_Golfin]

Thanks John.

I upgraded to the very latest Mac Excel version and still get the same problem.

Where do I find the "Excel KNOWN ISSUES Help topic"?

Regards
John Golfin

 

[John McGhie]

Hi John:

It's in the Excel Help. Make sure you're looking at the EXCEL help, not the
Mac Help

If you search in the EXCEL help for GETPIVOTDATA, it will be the second
item.

Basically, it says "This doesn't work if the file format is .XLSB".

Hope this helps

Thanks John.

I upgraded to the very latest Mac Excel version and still get the same
problem.

Where do I find the "Excel KNOWN ISSUES Help topic"?

Regards
John Golfin

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[John_Golfin]

Hi John

I found the known issue you refer to and it does not apply to me. I also checked other issues and they also do not apply. I am surprised that no one else has reported this since this a highly visible error as you cannot see any refrenced value to a Pivot Table.

Has anyone else seen this?

Regards
John Golfin

 

[XinXin]

Hi John, I can help further investigate this trouble, if you can send me ([email protected]) a copy of your workbook.

Thanks,
XinXin Liu
Test Lead, Macintosh Business Unit, Microsoft

 

[John McGhie]

See my response a moment ago: I suspect he has been hit by the reverse
syntax bug.

Cheers

Hi John, I can help further investigate this trouble, if you can send me
([email protected]) a copy of your workbook.

Thanks,
XinXin Liu
Test Lead, Macintosh Business Unit, Microsoft

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]