Currently data sources that are derived from XLS/XLSM sheets are counting formatted but otherwise empty rows as active rows.

If the spreadsheet has any formatting (alignment, word wrap, etc.) set for data rows, but no data in any row cells, the empty row is populated in Data Sources anyway. If one uses AutoNext / Loop for a title, this is a problem.

I had set up preformatted protected sheets for the staff to use to avoid mistakes and improve readability, but I had to remove all formatting. For long fields (like ticker data fields) that could use word wrap / automatic row height, this kind of sucks. We can get by, but this seems like something that would be relatively easy to fix for an upcoming release.