R
roger.camargo
We have a cube with 1 dimension that has 4 levels, when displaying up
to the 4th level the data is displayed OK on the OWC, but when
exported, in some places there are some "#N/A".
Digging up a little bit, I've found that if I open directly the cube
from EXCEL 2007, and I browse up to the 4th level there isn't any "#N/
A".
Then I thought that there are version of the pivot tables on excel,
and certainly does:
xlPivotTableVersion2000 => Excel 2000 (0)
xlPivotTableVersion10 => Excel 2002 (1)
xlPivotTableVersion11 => Excel 2003 (2)
xlPivotTableVersion12 => Excel 2007 (3)
xlPivotTableVersion14 => Excel 2010 (4)
Making a macro to print the version of the pivot table used showed me
that the PivotTable created from the Export feature of the OWC
pivottable, is using xlPivotTableVersion2000, and the version that was
OK, created from Excel 2007, is using... well xlPivotTableVersion12.
The same "#N/A" is shown when I create the PivotTable directly from
Excel 2003, so I assume that this was fixed on 2007.
To summarize everything, many of our users relies on the Export
feature of the OWC, is there a way to export and use the
xlPivotTableVersion12 version of the PivotTable (where they have Excel
2007). I'd tried modifying the Export htm file but I could manage to
upgrade the version from xlPivotTableVersion2000 UP TO
xlPivotTableVersion11, but I couldn't manage to get the
xlPivotTableVersion12. Or if there isn't any, is there any way to
"upgrade" the version on EXCEL itself, maybe a macro, something like
SAVE the format, and open it again RETRIEVING the format but using the
latest Pivot Table?
to the 4th level the data is displayed OK on the OWC, but when
exported, in some places there are some "#N/A".
Digging up a little bit, I've found that if I open directly the cube
from EXCEL 2007, and I browse up to the 4th level there isn't any "#N/
A".
Then I thought that there are version of the pivot tables on excel,
and certainly does:
xlPivotTableVersion2000 => Excel 2000 (0)
xlPivotTableVersion10 => Excel 2002 (1)
xlPivotTableVersion11 => Excel 2003 (2)
xlPivotTableVersion12 => Excel 2007 (3)
xlPivotTableVersion14 => Excel 2010 (4)
Making a macro to print the version of the pivot table used showed me
that the PivotTable created from the Export feature of the OWC
pivottable, is using xlPivotTableVersion2000, and the version that was
OK, created from Excel 2007, is using... well xlPivotTableVersion12.
The same "#N/A" is shown when I create the PivotTable directly from
Excel 2003, so I assume that this was fixed on 2007.
To summarize everything, many of our users relies on the Export
feature of the OWC, is there a way to export and use the
xlPivotTableVersion12 version of the PivotTable (where they have Excel
2007). I'd tried modifying the Export htm file but I could manage to
upgrade the version from xlPivotTableVersion2000 UP TO
xlPivotTableVersion11, but I couldn't manage to get the
xlPivotTableVersion12. Or if there isn't any, is there any way to
"upgrade" the version on EXCEL itself, maybe a macro, something like
SAVE the format, and open it again RETRIEVING the format but using the
latest Pivot Table?