Forum Discussion
Adding a blank column & retaining data
Hi I have a attendance excel document which I'm getting data from a third party source but I want to add a notes column so they can add notes against a student. problem is I cant do this i...
Hi Ful56
Nope sorry you won't be able to do that. If you add a blank column in PQ and load that to your Excel sheet, then type data into that column - every time you refresh the query, that column will be overwritten with the blanks from the query/table inside PQ.
Regards
Phil