Loosing Data Referencesfrom PC to Mac

[MattRD]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

H I - i have created an excel file on my PC which has several worksheets - the first has the base data, the second a pivot table (based on the first worksheet) and the third worksheet takes the data from the pivot and reorganizes it again.

When i send to it to my Mac (version 10.5.7),the third worksheet is not picking up the data at all from the pivot table. Likewise most of the formatting is also being lost.

anyone have any ideas???

cheers

Matt
Thanks

 

[CyberTaz]

Hi Matt;

I doubt that it has any bearing on the issue, but the only thing I can
determine from your message is that you're behind on your OS X updates...
10.5.8 is the current level.

In order to get help with the Excel problem you'll need to answer at least
these 4 questions:

1- What version of Win Excel was used to create the file?

2- What file format was it saved in?

3- What is your current update level of Mac Office?

4- How, exactly, is it that the third sheet "takes the data from the pivot
and reorganizes it again"?

Without that info I can't even tell whether I have the knowledge to help
but I'm sure there's somebody around here who can.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[MattRD]

Thanks Bob- sincerly appreciate your quick reponse.

Answers as follows:
1. MS Excel (on my PC) 2007 (12.0.4518.1014)

2.XLSM (but even in an ealier "xls" format the same problem I referred to was occuring)

3.MAC Office version 12.2.0

4. The third sheet just references the data from sheet 2. Ie If on worksheet 2 (the pivot), data exists in say Cell D2 - on the third sheet in a cell I just reference that cell with an "=D2" sign. This is where the proble lies as it is not read.

In fact on m PC the formula in sheet 3 looks like this : =GETPIVOTDATA("Sum of STORE TARRIF",'2- PIVOT'!$A$1,"ZONE","SOUTH")

Again thanks Bob for your interest - hopefully some help from somewhere may be forthcoming......

 

[CyberTaz]

OK, that helps a bit, Matt;

If the formula shown in your #4 is accurately represented as =D2 it explains
why there's no data being returned. The formula is referring to cell D2 on
that same sheet, which is probably empty. You need to also refer to the
sheet where the particular "D2" is located. The formula link should read as:

=Sheet2!D2 or =Sheet2!$D$2

That should return the content currently displayed in cell D2 of Sheet2, but
if you alter the Pivot Table's layout (hide columns or rows for example) &
something else [or nothing] winds up in cell Sheet2!D2 of the Pivot Table
your formula link on Sheet3 will update accordingly.

The =GETPIVOTDATA() function is more explicitly descriptive of what to
return based on labeling of the data within the PT rather than what cell on
the PT sheet it's displayed in. The formula will continue to return the
appropriate value even if its location changes in the PT as long as it's
still being displayed in the PT at all.

I'm still confused as to the issue: Are you saying that the workbook was
completed Excel 2007 to include the =GETPIVOTDATA() functions on Sheet3 of
the file but that these formulas *changed* to simple "=D2" when the file is
opened by Excel 2008? What were you referring to as "formatting" in your
original message? How did you generate the content of Sheet3 in the original
2007 file? There are a number of significant differences between PT features
in PC Excel v. Mac Excel -- perhaps you are a victim of something there.

HTH |:>)
Bob Jones
[MVP] Office:Mac