Using An Excel Table Problem

I am having an issue with Excel. I have an appsheet table to capture invoices info. Everything worked perfect until I changed my source in excel to an excel table. Now when I add a new entry into appsheet it records it 70 rows down instead of the next available row. I need source data to be in excel table because I am referencing it in an external excel pivot table. Any help is much appreciated. I have attached some screen shots.

What does this mean?

I don’t remember for sure, but I don’t think AppSheet likes dealing with defined tables in an Excel sheet.

But what I do know, is that the only part of you worksheet/table that should be stored in bold text is your headers. AppSheet uses bold text to figure out where your table headers start, and every row looks bold in your screenshot, though the resolution/font makes it difficult to tell.

1 Like