Work Book Auto Refresh

[Former Member]

Hi,

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.

Regards,

SMS

[Former Member]

Sunil,

You said that "profit centre is not getting refreshed even though it is similar". Similar is not good enough here.

To refresh multiple queries with only one set of input parameters, you must use the SAME variable for each InfoObject in each of those queries.

Hope this helps...

Bob