0

Drilldown error on conditionally hidden rows

When I am trying to drilldown on a specific account and there is conditional hide formulas. I will select the drilldown button and for some reason, it will automatically select the next cell above the one i have selected and give me the information or give me the error "Drilldown cannot be desplayed. The cell formula may not be valid for drilldown" when the cell abobe the one I have selected is equal to 0 (zero).

The drilldwon "will" work properly however when the conditional hide is removed.

Anyone have a possible solution to this problem other than removing the conditional hide?

See attached screen print.

Thanks
Nathan

2 comments

Please sign in to leave a comment.