Forum Discussion
I believe this is what you're looking for:
Can Parameter Prompts be Removed When the Cube View is Opened in Excel?
Authored by Paula Mihalko
Question
If you have a cube view that has a prompt (say for Entity) and you open the cube view in Excel, every time you refresh the prompt will pop up. Is there a way to "remember" the selection for that parameter or otherwise remove the prompt?
Answer
Yes, by setting up a NAMED RANGE cell with the same name as the parameter.
Example cube view - note there's a prompt for the Entity:
Open the Cube View in Excel
By creating a Cube View Connection
Here's what the Cube View looks like:
To "replace" the need for the prompt, add a single cell named range with the same name as the parameter:
Then when the sheet is refreshed, there's no popup for the parameter.