Power Query doesn't read an Excel file

Hi Anonymous 

Power Query is used to connect to data sources to load and transform data, it cannot modify the file itself that is connected to.You can try using some other methods like VBA or Office scripts to automate the Open file -> Save file -> Close file process. Here are some similar threads I found, hope they would be helpful:

automation - How do I automate the opening, saving, and closing of an Excel file on Windows? - Super User

Script to Automate an excel file to Open, wait 5 seconds, Save and Close - Software - Spiceworks Community

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!