I have a local spreadsheet, Book1. Saved a copy of spreadsheet, Book2 on a
network shared directory. For any cells that are updated on local
spreadsheet, Book1, I need to have the network spreadsheet, Book2 update with
same changes. If I put formula on Book2 cell to = Book1 cell, the changes
will update if I open Book2 on local PC. If another network PC opens shared
Book2, the source is not available for the Book1 spreadsheet. What formula
can I use so that a network PC view an updated shared Book2 linked to the
local Book1 spreadsheet?