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?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top