My whole data is messed up when updating power query

[Martin sherk]

So i try to find a way to update my connections tables without messing up the view so i choose table design >> properties >> and remove the tick from adjust column width but then when i refresh data the below message appears



so i tried the last option overwrite exsiting cells and my tables are moving everywhere in my sheet when i refresh data



what shall I do to have my tables in place in the sheet and doesn't mess up or change places, as I have 4 big tables under each other representing data

 

[johnny51981]

I run into a situation fairly similar from time to time. Keep the Adjust column width un-ticked, as you are wanting.

But you will have to right click on the Query in the Queries and Connections pane of your workbook, right click and then select "Load To", then the radial next to "Only Create Connection". Then click "OK".

This will obviously cause your data to go bye-bye.

Do the same thing again, but in reverse, selecting the "Table" radial in the "Load To". Make sure that you have selected the location on the existing sheet that you are wanting to put it back in. Click "OK" and your data will then reload.

Sometimes, there is either a formatting or funky text that gets thrown in there, and the Power Query doesn't want to trip over it, because it isn't apart of its sandbox.

Hopefully this helps.

 

[Martin sherk]

I run into a situation fairly similar from time to time. Keep the Adjust column width un-ticked, as you are wanting.

But you will have to right click on the Query in the Queries and Connections pane of your workbook, right click and then select "Load To", then the radial next to "Only Create Connection". Then click "OK".

This will obviously cause your data to go bye-bye.

Do the same thing again, but in reverse, selecting the "Table" radial in the "Load To". Make sure that you have selected the location on the existing sheet that you are wanting to put it back in. Click "OK" and your data will then reload.

Sometimes, there is either a formatting or funky text that gets thrown in there, and the Power Query doesn't want to trip over it, because it isn't apart of its sandbox.

Hopefully this helps.

I've never seen this method before, i will definitely try it! and give you feedback, i really appreciate your time sharing this idea with me. Thanks!