Skip to Content
Former Member
Dec 24, 2011 at 10:58 AM

Dynamic workbook allowing drilldown not affecting format?


Dear Experts

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.

Happy holidays.