It seems that I can’t reference a single Excel column such that LO will update a table adding entries as new entries are saved in the Excel file as what happens with the reference A1:End.
Is there a reference that I can use that will do A1:Column A End ?
If I enter a reference, say, A1:A10 and only A1:A3 have data then LO will show a table A1:A10 with empty cells.
In an attempt to replicate table referencing for a single column like A1:End, I created a master worksheet that I can edit all my data easily in one place and then created single column worksheets that link to the master worksheet for each category of data. It is these worksheets containing a single column that LO references.
The problem I have is that when I had only one worksheet, updating the table in LO was quite speedy but now with extra worksheets it has become very slow to update my tables.