2 Replies Latest reply on Apr 27, 2017 2:11 PM by Ruofei Wang

    how to change title when there is no data in the worksheet?

    Ruofei Wang

      Hi All,


      My situation:


      if there is data in the worksheet, the title will be "Summary"

      if there is no data in the worksheet, which means it is empty. the title should be "No data this period"


      How can I achieve that?


      I've used another worksheet try to get it, but all I can do now is to make that title disappear as worksheet disappear. I'm not able to change to another text.