Help me fixing parameters in Pivot query (with chart) !

[mrexcelid]

Dear all,

Please forgive me if i ask too easy question, but i need some help. thx.


I m trying to create a pivot query chart based on parameters i enter in excel.

as shown in attached screenshot of my pivot chart, i have successfully added parameters and linked them with pivot. So when i REFRESH pivot it reads from excel cell values of parameters given and gives me data.

Now the problems is , the linking i've done, between excel cell values and pivot parameters works only as long as i keep this excel file open. (yes i've checked the checkbox to use the same cell value in future refreshes) So, i've to reenter all 6 parameters whenever i close the file and open it again.

Is there any workaround ?

 

[mrexcelid]

One more screen shot to explain,how it asks to enter all parameters again when i reopen the sheet.

 

[mrexcelid]

Not a single reply !

is it too silly question or difficult to understand !

 

[andrepws]

Whit the same problem! Still trying to find a solution...!