Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Empty spreadssheet

Hi.  I've set up a dashboard that loads excel sheets from folders each month. If a spreadsheet is put into a folder but it contains no entries how do I get it to oad no data without showing an error?   Can i get it to put in a dummy row so it will load?

 

Cheers

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous not sure why you will put a dummy row and what errors you are getting, you can always use Remove Errors rows and I believe that will take care of it.

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Load a sheet with no entries works fine and with no error on my side, Can you describe the error message after delete confidential information?

     

     

    Best regards,

     

    Community Support Team _ DongLi
    If this post helps, then please consider Accept it as the solution to help the other members find it more