I have data in one base spreadsheet that has been filtered, copied, and
pasted as a link in another spreadsheet within the same workbook. If I
resort, or add, or delete from the base spreadsheet, then the data in the
linked spreadsheet is different. Is it possible to 'lock' the data in the
base spreadsheet so any changes to it does not change the filtered and linked
data?