cancel
Showing results for 
Search instead for 
Did you mean: 

Selection variables upon opening workbook

Former Member
0 Kudos

Hi experts,

I have a workbook, which has 2 queries in seperate excel sheets. I have set the property to refresh upon opening under the property selection > All work books. Additionally I have enabled to show last refresh date and Status date for the both of the queries. now my problem is the work book works fine in Dev but I donot get variable selection screen and dates are not refeshed when I open in QA- the transported work book.... what cld have gone wrong here ?

thanks in advance

D Bret

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Did saved the properties in prod itself. It works..I know this is not the way

Former Member
0 Kudos

Hi Dave,

Check your settings of the variable used for dates.

Property->

1.Can be changed in Query Navigation.

That creates problem sometimes.

hope it helps,

regards,

Parth.

Former Member
0 Kudos

Partho,

The Last refreshed date I have picked from Layout ( icon on Explorer command buttons )> Display text element > General, deleted unwanted displays moved the Staus of Data and Last refreshed on the top empty rows. That way i am expecting the system gererated Status data and last refreshed date...

thanks for your quick reply

vinay_bedre2
Participant
0 Kudos

Hi Dave,

I just have a feeling that the query is not being refreshed. Check the property "refresh the query on workbook open" again in the test/prod system. Basically it should pass the new time stamps to you. Let me know how it works.?

Regards,

Vinay