I'm trying to store the result of a form in a Hugo website to an excel file. I think that the problem might be with the sharing permissions since for some reason when I go to the file I cant click on share with everyone. I'm using office for business.
For this problem, you can't input Sheet1 into the "Table" box because sheet doesn't belong to table. In my test, when I input Sheet1 as custom value, it will show same error message as yours.
You need to go to your excel and click "Insert" --> "Table" to insert a table to your excel.
Then we can select the table in the drop-down box of "Table".
