excel source code copy and auto update

Occasional Visitor

Hello everyone,


I have an excel file (table) that is updated daily by several users. This update is done via Ms Forms.

Certain fields are not required to be filled in in the form and must still be able to be filled in at a later time (via excel table).

Also, some fields may not be visible to the users (log data). I thought to solve this by using a power query. But every time I run this PQ, the data that I had added afterwards is deleted.

How can I ensure that an automatic copy/update can be made of the source data WITHOUT losing the data (and layout!) that was later attached?

Here is an example of the table.

I work with Office 365 for Business.

Hopefully there is a solution for this without VBA because I have no knowledge of that at all!

Thanks in advance.




0 Replies