Linked worksheets-Please help

  • Thread starter Thread starter Claire
  • Start date Start date
C

Claire

Can anyone help me? I would like to know if there is any
way to view in a worksheet the cells that are linked to
other work sheets?
 
Can anyone help me? I would like to know if there is any
way to view in a worksheet the cells that are linked to
other work sheets?

Yes, there is, under the menu go to Data>Import External Data>Import
Data... then when the box pops up look at the bottom under Files of Type
and just scroll down until it says Excel Files. Then you select the file
you want, and tell it the sheet. You can even edit the query more to select
specific rows and such.

Justin Etheredge
 
Back
Top