Result Area in workbook is selected

[mrmdrv]

Hello Experts,

I am facing a problem with my workbook.

Upon opening the workbook and after query refresh, all the result area gets selected. [Like we select any cell with Shift Key] And when I click anywhere in the workbook, it goes away.

I tried -

To remove result area, remove query from the workbook, save workbook as new etc. options, but nothing works.

Please advice if anyone knows the solution for this Problem. Thanks.

[mrmdrv]

The problem is resolved.

This was happening because of the macro we have on the workbook. The macro is for removing # signs from the result. We changed the code and then now it is fine.

[Former Member]

HI

I had the same problem. This problem raises generally if you change the query after hiding the sheet and then executing the query. Unhide all the sheets whatever you hide in a workbook and go to query designer save the query (one by one) and execute. Now hide all the sheets which u want to hide. Save the existing workbook.

To test it.Open the workbook and click on refresh.Say yes to refresh all the queries then it will execute fine. This is the case iam talking where you have a query result displayed with different colours or formats in seperate sheet which is linked to original sheet which is hide.

Thanks

k