​I have a number of Source data Excel Files which all have an identical structure. All have the same queries that load into the files and the same named ranges. I have checked and all the queries have the same privacy setting of Organizational. Previously the File Contents of the Source files would display like this in Power Query   And recently the file contents displays like this in Power Query. Which is missing the Columns for Item, Kind and Hidden  The result is that all the Power Queries that used to work are now breaking. If anyone can help me crack this case it would be hugely appreciated, I cant change my query because I need to combine the data from the old files and the new files.  I am running Excel Version 2407 Build 16.0.17830.20056) 32-bit    Read More

​