Combing Excel worksheets

Copper Contributor

Hi, all: I'm having to download a number of files from Facebook. For each page I'm managing, there are about 20 Excel files that are produced with about 15 worksheets within each file. I went through Power Query to try and merge all these files together. The files are all the same, but when going through the process, I'm given the error: "External table is not in the expected format." I'm not sure where the hang-up is or what I'm doing incorrectly. Any help would be greatly appreciated. Thanks. 

1 Reply
Hi Dan, are you performing any Unpivotting?

That warning pops up if there are DIV/0 or #N/A errors in your source files - especially when unpivotting.