D
Dave
I have a workbook that uses GETPIVOTDATA to pull column subtotals out
of a couple of pivot tables that works just fine under (various
versions of) Excel on Windows, but not on the Mac:
=GETPIVOTDATA("PageViews",Pivot_Other_Views!$B$11,
Pivot_Other_Views!$B$12,Raw_Other!$H$10,
Pivot_Other_Views!$D$11,Pivot_Other_Views!$D$12
)
Where:
- Pivot_Other_Views!$B$12 points to the "Page Type" field
- Raw_Other!$H$10 points to a page type value
- Raw_Other_Views!$D$11 points to the "Week of" field
- Raw_Other_Views!$D!12 points to a week number
The references above appear in several columns with different "Page
Type" values and a number of rows for each of the week numbers.
On Windows, I get what I'd expect: the subtotals for each week for each
page type.
On Mac, I get a #VALUE! error for every cell.
A quick glance at the Mac help seems to suggest that the Mac and
Windows have *very* different ideas about how GETPIVOTDATA works.
Am I hosed, or what? Isn't Excel supposed to be cross-platform?
of a couple of pivot tables that works just fine under (various
versions of) Excel on Windows, but not on the Mac:
=GETPIVOTDATA("PageViews",Pivot_Other_Views!$B$11,
Pivot_Other_Views!$B$12,Raw_Other!$H$10,
Pivot_Other_Views!$D$11,Pivot_Other_Views!$D$12
)
Where:
- Pivot_Other_Views!$B$12 points to the "Page Type" field
- Raw_Other!$H$10 points to a page type value
- Raw_Other_Views!$D$11 points to the "Week of" field
- Raw_Other_Views!$D!12 points to a week number
The references above appear in several columns with different "Page
Type" values and a number of rows for each of the week numbers.
On Windows, I get what I'd expect: the subtotals for each week for each
page type.
On Mac, I get a #VALUE! error for every cell.
A quick glance at the Mac help seems to suggest that the Mac and
Windows have *very* different ideas about how GETPIVOTDATA works.
Am I hosed, or what? Isn't Excel supposed to be cross-platform?