Table Selection Warning Follow
We are on Bartender 2019 R9.
I am having an issue using Designer. Here is how my system is setup:
I have an excel document with one sheet named "TagInfo" and a table in the range A5:F503. The whole table is not completely filled with records, however I have that many rows incase they are needed in the future. I setup the label and made the database connection to the excel file. When adding the table in the database connection wizard, I specify that the records are in rows, and check both boxes below that ("First row has field names" and "specify range"). The range I specified is the range mentioned above, as that is where the table headers and records reside.
After clicking OK, I am able to right click the table and view the data. Everything looks good until after I close the database wizard and open it back up and go to the "Tables" tab, where I get an error message with the header "Table Selection Warning". The message says "Table 'TagInfo#A5:F503 is no longer available. Do you want to remove it?" and gives the yes/no options.
I know that the issue is revolving around the fact that I am specifying the range because I tested with a copy of the document where the table begins at A1 and there was no issue. However that does not work for this particular application because there are fields I need in the excel file above the table.
Any suggestions on what I am doing wrong here?
Please sign in to leave a comment.