Power query not picking up extra data in Excel table.

[farmerscott]

Hi Everybody,

I am using Excel 365.

On a sheet I have a table that I add data to. When I look at its dimensions, it increases as data is added.

However, my query within power query does not pick up the extra rows. The query is based upon the table not the sheet.

Manual refreshing does update any new rows.

My table is 160 rows by 9 cols, so I am sure I am no maxing out Excel's capabilities.

Any ideas?

thanks,

 

[RoryA]

It shouldn't have generated that if you used the Data from Table/Range option. That is the code for accessing an external workbook.