View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PhilB
 
Posts: n/a
Default Linking worksheets in Excel

I update my costs using linked worksheet. Chairs have 3 or more parts that
lead to the final cost. When I open the worksheet for the finished chair,
costs are not automatically updated from the linked worksheets for the Back,
Seat and Frame. I need to open these sheets manually, in order for the
updates to flow to the finished Chair sheet. Is there some way to have all
linked sheets open when the finished "Chair" sheet opens, so that all the
cost updates flow to that worksheet? Thanks.
--
PhilB