I've appended two Excel tables (A and B) using Power Query. So far so good. Table A is a connection only to another Excel file. Table B is in another sheet of the workbook where my query results get loaded.
Table B has to be manually updated on occasion - it's a list of exceptions to append to the standard Table A. When I add rows to Table B, those rows do not show up when I refresh the queries. I've tried refreshing all together and each separately.
Anyone have any ideas why my edits in Table B are not being picked up by any of my queries? It's driving me nuts and The Google hasn't been much help either.
Table B has to be manually updated on occasion - it's a list of exceptions to append to the standard Table A. When I add rows to Table B, those rows do not show up when I refresh the queries. I've tried refreshing all together and each separately.
Anyone have any ideas why my edits in Table B are not being picked up by any of my queries? It's driving me nuts and The Google hasn't been much help either.