Skip to Content
0
Former Member
May 17, 2010 at 11:06 AM

Variables from workbook are not visible in the Planning function

135 Views

Hi,

We're using a workbook with a bunch of queries in it. Every query has a lot of variables declared that are calculated based on two input ready variable that users are required to fill the first time.

Everything works as expected until the save data function is called, which in turn calls the planning function.

Here, the user exit variable try to be recalculated again. Unfortunately, this planning function loses track of the two input ready variables that were on the workbook, so the user exit variables have no values.

Can you please suggest a method so that:

a) The user exit processing in the planning function "sees" the two input ready variables

b) The user exit processing is not triggered in the planning function and it's taking the already calculated values

Let me know if you require further information.

Best regards,

George