Hiding sheets and showing sheets depending on data availability

[#1]

Hello

I have a question when hiding and showing sheets depending on data availability.

I managed to hide sheets with null data by setting condition under sheet property.  (General-> Show Sheet -> Conditional -> Set Conditions)

It seems once the sheets are  hidden, they are  going to be hidden for good even thou the data is reloaded and I expect to see the sheets that I set to hide previously.

Is there any ways that I can reactivate the sheets?

Any advice would be appreciated.

Thanks much,

Hitomi

[jagan · Accepted solution]

Hi,

You can hide the sheets by using the conditions like this

=Sum(Sales) > 0

OR

=Count(Orders) > 0

If this type of conditions fails it hides the sheets  and if this condition pass then it will show the sheets.

Regards,

Jagan.

[#3]

Thank you so much Jagan!  It worked!!!!! 

[jagan]

Hi,

If you got the answer please close this thread by giving Correct Answer to the post which helps you in the getting the answer.

Regards,

Jagan.