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't getting any traction over at https://stackoverflow.com/q/69214875/139698

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.

Refresh Data join with extra Excel columns

7 Replies

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.
- rodsan724
  Brass Contributor
  Sep 26, 2021
  I setup the self-referencing table and it worked great. I tried to add another column next to notes column that contains a formula but every time I refresh the data the formula is replaced with just value of the formula. Is there not a way to have formula persist during a refresh data?
  - 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.

Forum Discussion

Refresh Data join with extra Excel columns

7 Replies

Resources