BO Analysis for Excel - prompt not showing all values

Hello Everyone,

I have a BO analysis workbook with datasource as BEx query. One of BEx query variables is Manual input to select Cost center.

When I execute BEx query and in selection screen when I hit F4 I am able to see or search all possible values for Cost center available in BW. And I am also able to select a Cost center value for which I would like to see the result.

But when I try do the same in selection screen of BO Analysis for Excel at the time of workbook refresh I am not able to see the same cost center value which I am able to se in BEx selection screen. I changed the "Maximum number of Members Displayed in Filter Dialog in User Settings" but still no luck in finding the cost center I am interested in.

Can anyone throw some suggestion on this please? Thanks.