UPDATING MULTIPLE SPREADSHEETS FROM A SOURCE DATABASE WORKBOOK. FINE TUNING ONE ASPECT ONLY

Question

My first effort linking a database source workbook to slave worksheets by cutting and pasting the link has worked perfectly and data updates as expected. However, being a virgin in this area, I inserted an additional line in the source workbook and don't fully understand why that action doesn't replicate in the slave worksheet. More importantly, CAN this issue be overcome so that line insertion in the source workbook replicates in the destination worksheets automatically and doesn't compromise results in the slave worksheets? Thank you.

Answer 1

Many thanks Bernie. I'll give that a go and see how I get on.

Answer 2

Use data connections rather than links. Basically, use Power Query to extract the data from the original source. The table in the database workbook will be converted to a data table, which will expand and contract to keep the data reference updated, and the destination workbooks can get the new data when the connection is refreshed.