ExcelBanter - updating external data sheet causes loss of data on linked pages

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - updating external data sheet causes loss of data on linked pages (https://www.excelbanter.com/excel-worksheet-functions/156189-updating-external-data-sheet-causes-loss-data-linked-pages.html)

C_F_Dewey

updating external data sheet causes loss of data on linked pages

I have 6 sheets in a workbook. 1 contains external data and 5 link to this
sheet. When I update the external data sheet ,some of the data lines on the
other pages disappear. Any help would be appreciated

All times are GMT +1. The time now is 06:00 PM.