Forum Discussion

Brass Contributor

Sep 24, 2021

Solved

Refresh Data join with extra Excel columns

I have a table that is linked to my database table. I've added some extra related columns in my worksheet. When I click Refresh Data the added columns become out of sync. Any thoughts? Wasn'...

excel

Detlef_Lewin
Sep 24, 2021
rodsan724
You see the relation but Excel doesn't.

Either you create an extra table with your notes and join it to the existing table or you could try this.

Detlef_Lewin

Silver Contributor

Sep 26, 2021

rodsan724

I believe that is the culprit with self-referencing tables. You are joining the table with itself and at that point any formula you created on the Excel side is converted to its value.

Try to create the formula on the PQ side.

rodsan724

Brass Contributor

Sep 28, 2021

I notice that I have to refresh the first table that is connected to database, and then a 2nd time to refresh the 2nd table. I figured all I would need to do is one Refresh All but I have to do 2 of them. Am I understanding that correctly? Not a big deal, just curious.