Two Queries in one Worksheet
I'd like to know what the disadvantages are of having two queries in the same worksheet of a workbook. Is it correct that the results of one query can overflow to the area of the second? How about issues with authorization, are there any?
Parth Kulkarni replied
Yes, result of one can flow over the other if you are using simple report with characteristics and output may vary.
Actually you apply basic Excel logic and its like 2 diff report on it.
Mostly you add more Fixed format reports to a single sheet. So that number of report rows dont increase and also you dont have any free characteristics to drilldown.
About authorization, that depends on individual reports. If a user doesnt have proper authorization for 1 of the reports then that report would throw error while other would show result.