Pivot table question
 

Hi

I have spreadsheets that take data via a pivot table from an OLAP cube that
is held on a terminal server.

The spreadsheets hold figures entered by me and figures obtain from the
pivot table.

I want to enable the automatic update on the pivot table but the pivot table
is sorted by a project number obtained from the OLAP cube. My problem is if
a new project is added to the OLAP cube then it is automatically selected
from the drop down list. I want to be able to turn this off so that it only
selects the project I have previously chosed. For example if I have selected
the filter number of 518 and a new project is added to the OLAP cube of
ABC123 when a refresh of the data is enabled it will select both 518 and
ABC123 and I want it to only select 518 on the refresh.

How do I do it please.

Thanks

Pivot table question
 

Depending on the Version of Excel , but you should be able to select the drop
down arrow next to the shaded field on your Pivot table and choose only the
items you want to keep. This means that once you choose these and if a new
items is added to your DB and you hit refresh, it should not add it to your
pivot report.

"Beverly Darvill" wrote:

Hi

I have spreadsheets that take data via a pivot table from an OLAP cube that
is held on a terminal server.

The spreadsheets hold figures entered by me and figures obtain from the
pivot table.

I want to enable the automatic update on the pivot table but the pivot table
is sorted by a project number obtained from the OLAP cube. My problem is if
a new project is added to the OLAP cube then it is automatically selected
from the drop down list. I want to be able to turn this off so that it only
selects the project I have previously chosed. For example if I have selected
the filter number of 518 and a new project is added to the OLAP cube of
ABC123 when a refresh of the data is enabled it will select both 518 and
ABC123 and I want it to only select 518 on the refresh.

How do I do it please.

Thanks

Pivot table question
 

I am running Excel 2003 but it still adds new projects :-(

"Don" wrote:

Depending on the Version of Excel , but you should be able to select the drop
down arrow next to the shaded field on your Pivot table and choose only the
items you want to keep. This means that once you choose these and if a new
items is added to your DB and you hit refresh, it should not add it to your
pivot report.

"Beverly Darvill" wrote:

Hi

I have spreadsheets that take data via a pivot table from an OLAP cube that
is held on a terminal server.

The spreadsheets hold figures entered by me and figures obtain from the
pivot table.

I want to enable the automatic update on the pivot table but the pivot table
is sorted by a project number obtained from the OLAP cube. My problem is if
a new project is added to the OLAP cube then it is automatically selected
from the drop down list. I want to be able to turn this off so that it only
selects the project I have previously chosed. For example if I have selected
the filter number of 518 and a new project is added to the OLAP cube of
ABC123 when a refresh of the data is enabled it will select both 518 and
ABC123 and I want it to only select 518 on the refresh.

How do I do it please.

Thanks