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 ?
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 ?
Last edited:
