Linked worksheets-Please help

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?
 
J

Justin Etheredge

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?
Click to expand...

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
 
Top