I'm helping a gentleman with some data analysis, using Power Query to combine files by adding more to a folder, like this: http://www.excel-bytes.com/how-to-combine-files-using-power-query-in-excel/ He is only up to around 12,000 lines of data. Any thoughts on why this is occurring? Using Excel 2016. Anyone have any suggestions as to why we are getting this error message? "The Query Returned More Data Than Will Fit On A Worksheet"

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

The Query Returned More Data Than Will Fit On A Worksheet

Thread starter excelbytes
Start date Oct 16, 2017
Tags

data fit query returned worksheet

excelbytes

Active Member

Oct 16, 2017

[COLOR=rgba(0, 0, 0, 0.7)][FONT=&quot]I'm helping a gentleman with some data analysis, using Power Query to combine files by adding more to a folder, like this: [/FONT][/COLOR]http://www.excel-bytes.com/how-to-combine-files-using-power-query-in-excel/[COLOR=rgba(0, 0, 0, 0.7)][FONT=&quot] He is only up to around 12,000 lines of data. Any thoughts on why this is occurring? Using Excel 2016. Anyone have any suggestions as to why we are getting this error message? "The Query Returned More Data Than Will Fit On A Worksheet"[/FONT][/COLOR]