I have a pivot table (*.xls), which has beyond others a dimension named "area".
It has different countries as the following pic shows.



Each country has analysis values. (The values are from MS Analysis Services.)

Application Rules:
A Web Admin is allowed to see data from all countries.
A Country Admin e.g. USA is allowed to see only data from his country.

Within the Excel file, where the pivot table is,
I can decide which country I would like to see.



My goal is to present the content on Internet. Therefore I save the Excel file as html file,
(with the interactive option for pivot table).

Next pic shows, how it looks on Internet Explorer.




My problem is the next pic.



As you see, the US Coutry Admin has the posibility to see
also data from other countries,
even I have selected the country USA before I saved as html file.
He only needs to check the country he wants to see,
which is against the rules.

Question:
How Can I disbale this area, so that USA Country Admin
(same for other Country Admins) can only see data
from his country.
(He should not get the chance to select another country.)

Aykut