I have one spreadsheet (A) using array formulas to pull data from another spreadsheet (B, data dump) within the same file but I can't seem to find a way for A to update without opening both spreadsheets. Is this posible and if so how do I setup A to automatically update or is there a force refresh option that can be used rather than opening both?
Bookmarks