I have an Excel sheet with a data table linked to a SQL database table. Works great, refreshes, can sort and filter what I need. Awesome.
My question is, and after much Googling I've yet to find any good answer: can I add a column to the data table that I can manually enter stuff into that will stick with the associated line when the dataset is refreshed? So like I have some data, and I add a note to each line, and then when I refresh and a new line is added, the notes follow with the existing lines and a blank space is added in the note column for the new line.
From everything I've tried, the added information either moves around randomly when the data is refreshed. disappears when I refresh, or I end up with a read-only column I can't write into.
I'm using Excel 2010, and the end user of this sheet is on Excel 2007.
My question is, and after much Googling I've yet to find any good answer: can I add a column to the data table that I can manually enter stuff into that will stick with the associated line when the dataset is refreshed? So like I have some data, and I add a note to each line, and then when I refresh and a new line is added, the notes follow with the existing lines and a blank space is added in the note column for the new line.
From everything I've tried, the added information either moves around randomly when the data is refreshed. disappears when I refresh, or I end up with a read-only column I can't write into.
I'm using Excel 2010, and the end user of this sheet is on Excel 2007.