I have a pivot table that accesses an Analysis Services cube. I have a
customer dimension structured as follows:

Level: Account
Key: Account
Name: Account + Region + Description

The Problem
Office Excel 2003 users select multiple accounts from the dimension they
have dragged onto the page field of the pivot table and save speadsheets onto
their local hard drives and enable automatic refresh against the cube. When a
customers region changes, they get a message box stating that the olap item
is not found in the database and the account number(s) they have selected are
no longer selected, and sometime, only the All Customers value is selected.

The Question
Is there anything I can do to prevent changing customer names from being
de-selected from the customer dimension drop-down in the pivot table?

Thanks!