I created 2 queries because of technical constraint. 1 query is set with a certain setting that affects another display requirement. So, 2nd query is created.
Can 1 workbook use 2 queries but allow drilldown such that the formatting will not be affected adversely in the workbook?
That is, if a workbook is drilled-down, eg. show more information in the rows , by displaying additional characteristic columns, if there is formatting/Excel formula in certain cells, how can this formatting/cell formula be preserved?
For example, workbook achieves the display requirement by referrencing the cells from the 2 queries. But the user needs to drill down in the workbook. How will the referencing be affected or preserved?
Please let me know if this is possible.