Links failing to update when power query is refreshed

[Teleporpoise]

Hello Mr. Excel Friends,

I have a few sheets linked to a master data sheet via power query. I had added some columns to the master sheet, but when I refresh the queries on the other sheets they do not update to include the new set (for example there was a table that initially had 23 columns, now it has 25 in the master, but when I refresh on the linked sheet it remains 23 columns).

Does anyone know why this is? And How can I fix it?

Thank you,

 

[SpillerBD]

You will need to update the Query.
There are ways to allow the Query to handle new columns and ways to have a Query exclude new columns.

 

[Teleporpoise]

Hi SpillerBD, thanks for your response. Can you elaborate on how I can do that please?