ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2000 pivot table problem (https://www.excelbanter.com/excel-worksheet-functions/87514-excel-2000-pivot-table-problem.html)

Andy S.

Excel 2000 pivot table problem
 
In Excel 2000, I am working with the page header of a pivot table and
trying to make multiple choices. In Excel 2003, I can do this, but in Excel
2000, I click on the dropdown, and I get a dropdown where only one item can
be selected. Is there an option to make multiple choices available in the
drop down of a page header or is this an Excel 2003 enhancement?


--

*************************************************
Andy S.


Please remove "noreply" before replying.

This posting is provided "as is" with
no warranties and confers no rights.

*************************************************



DM Unseen

Excel 2000 pivot table problem
 
Depens what the source of the pivottable is, is it an (OLAP) cube or
non OLAP source ?


Andy S.

Excel 2000 pivot table problem
 
It is an OLAP cube from SQL Analysis Services 2000.

"DM Unseen" wrote in message
oups.com...
Depens what the source of the pivottable is, is it an (OLAP) cube or
non OLAP source ?




DM Unseen

Excel 2000 pivot table problem
 
I suspect it is an XL 2000 limitation(I cannot verify this here at the
moment).

DM Unseen



All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com