Get data from Excel - missing last column in navigation; gets visible after modification to original

Hello all,

I have an issue when loading an Excel file into PowerQuery: we receive a sales forecast file from an external partner that contains 18 columns of data. When I try to load this .xlsx file PowerQuery only recognizes 17 columns - the 18th column is not showing (which is a column I actually need). If I make a small modification to the original Excel file (e.g. as simple as just adding a random number to a random cell in any of the worksheets, not even the one I need) - the last column is recognized 🤔.

Attached a print screen of the behaviour of both orginal file behaviour and after modification behaviour.

Did anyone experience this before and has a potential workaround (other than modifying and saving the file like I do today). I have a PowerAutomate solution running that saves the Outlook attachments automatically upon receipt and would like to avoid any manual intervention to the files. 

Thx a lot for your feedback!

Kind regards,

Michiel