Home

Combing Excel worksheets

Dan Scapusio
Occasional Visitor

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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies