We have 6 Queries attached in a work book and each query is with input variables.
Query 1 is having profit centre,company code,Fiscal Year, Fiscal Year Period similarly for
Query 2 , Query 3 and etc.
Some variable entries are similar acorss all the queris ie similar technical names and hence getting refreshed only once.
During the autorefresh.
But Query 1 & 2 profit centre is not getting refreshed even though it is similar to Query 4 profit centre.Query 4 profit centre is getting refreshed during the autorefresh.
Individual Query refresh in the work bokk is running fine but auto refesh is not happening for all the queris.
We tried saving the Queris in the work book again as per the sequence however not able to achieve the correct results.
Work book is very complex and difficult to redesign and detach and attach also not working.
Please suggest at the earliest.