Columns missing from imported Excel data

hello

this hasn't to do anything wtih power query

this is only a matter of settings in Excel.

The USEDRANGE is a read-only object that is determed by excel, if a range is used.

I will write you a VBA code to read this object. You can paste this to your files and check whether a the usedranges are the same. In addition is always dangerous to use an non dynamically approach when working with an unstructered data like Excel Table.RemoveColumns(Table, {"Column16"}) can lead to an unexpected result, as Column16 may not exist or not contain the data you are expecting (as you saw in your example, the usedranges may not be identically, even you have designed it like that - maybe used changed something)

Here now the VBA code to check

sub checkUsedRange ()

dim ws as worksheet

for each ws in thisworkbook.worksheets

debug.print ws.name & " - " & ws.usedrange.address

next ws

end sub

have fun

Jimmy