View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Falcon248 Falcon248 is offline
external usenet poster
 
Posts: 11
Default Linking separate spreadsheets

Is there a way in Excel 2003 to link to multiple workbooks/worksheets so that
when you open a workbook with the links in it, a current copy of the linked
spreadsheets are loaded into the opening workbook's worksheets? I know we
can use copy/paste, but it would be nice if it could be automatic. Sort of
like MS Project does. I think there is a way in Excel 2007, but I don't see
a way in 2003..