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