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 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.

rodsan724

Brass Contributor

Oct 20, 2021

@Detif Lewin, I did the example that's in the link and it works great! Thanks again. However, I noticed if I put a hyperlink in the extra columns and do a Data Refresh the text stays but the hyperlink goes away? Any thoughts?

Detlef_Lewin
Silver Contributor
Oct 20, 2021
rodsan724
It's the same in the Excel grid. If you do a lookup only the value is returned not the hyperlink.