Using power query in excel to combine 3 excel spreadsheets into one error field content of the record was not found???
I get the following error message and it will not merge the files. Expression.Error: The field 'content' of the record wasn't found.
I get the same for each of the files I want to merge??? Not sure how to resolve
Did you select Combine & Load after you'd selected the folder and the files were listed?
select object to be extracted
sample file: first file and a drop down with the spreadsheets --- Do I choose something here I can only choose one sheet at a time. Do I have to choose each sheet seperatly to load them into one master blank spreadsheet that I want to create??? Not sure the steps to take in this menu to load all my sheets into one master excel sheet... Perhaps there is a better path??? Thanks
I am using microsoft office professional 2016
When you follow the steps outlined in that link does everything described happen?
For example, do you see a list of files once you've browsed and selected the relevant folder?
UTF-8 can represent any character in the Unicode standard and it is also backward compatible with ASCII as well. It is the most preferred encoding for e-mail and web pages. It is the dominant character encoding for the world wide web.Aug 10, 2016
I have not had a use for this, so I am no expert here.