Linking to external tables/Graphs

G

Gaijintendo

How do you insert a table from an external file dynamically.

Say for example I have a xls file called "TopTen.xls" and I want to use the
table from that in my new file, how can I insert it?

I need to be able to update "TopTen.xls", and possibly replace it every week
with a new identically formatted "TopTen.xls" file.

I then have to repeat this problem with graphs too.
 
G

Gaijintendo

A link to a tutorial would be great... anything really. I suspect this is
fairly trivial...
 

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

Similar Threads

Creating graphs from data in other files 1
update graphs automatically either from same book or a new spreads 1
Converting Graphs from 2003 to 2007 3
Unable to insert table 2
Linking to individual Excel worksheets 1
Replacing part of a (too) long formula 5
absolute cells when linking to an external file 2
Importing Data from a pre-existing spreadsheet 2

Top