Variable Sequence issue

[Former Member]

Dear All,

I have situation where I have 3 work books in a query. I have variable sequence A,B,C,D,E in the query properties set now when open the workbook I am getting the sequence as A C E B D. I am confused why would this happen as the sequence should be same as the order set in the query properties.

I have checked all 3 queries of these 3 work books have same sequence ABCDE in the query properties.

can any please advise why would this happen and how can I rectify this quickly

Thanks,

tati

[Former Member]

Hi Santhosh,

Try to log on to individual queries, delete and recreate one of the variables, arrange the variable sequence and check it by executing the queries individually. Finally if all the queries are showing the same sequence then try to execute your workbook.

It should work. Please provide any further details if it doesnt work.

Regards,

Santosh

[former_member183777]

You might want to reset the query to global definition to see if that solves the issue. ANother test is to run query and make sure the variable sequence is correct.