Cell reference error when refresh a Power Query

Question

Hello guys,

Here is the problem:

I have a Power Query From Web query that bring a list from a Webservice, that list is stored in a WorkSheet "Contacts".

I have other Worksheet that it is form to be printed by the user.

In this form I have references to the list table from the query: "=ContactBefore!$A2", the problem is that the list could be different because the parameters change. When I refresh the query and the list changed the reference has error because something happen in the form and the references show: "=ContactBefore!#REF".

My question is why that happen? because the value can change but the cells are always there?

Thank you

***Post moved by the moderator to the appropriate forum category.***

Answer 1

I guess PowerQuery is deleting rows.

You could try changing the reference to

=OFFSET(ContactBefore!$A$1,1,0)