×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Reference to multiple workbooks?

Reference to multiple workbooks?

Reference to multiple workbooks?

(OP)
Is it possible to get data from multiple files into a single "Summary" book? I was trying to create a form for estimating purposes. Some of our projects are quite large and broken into parts A, B, C, etc...

So, I wanted to make a folder for estimating that would contain one file "Project.xls", another file "A.xls", "B.xls", etc...

I managed to do this and when the folder is copied the links to other workbooks in the Project file DOES always look in the same directory, so that's good. However, it doesn't seem to update the data unless I open all the other files. Excel only seems to be able to retrieve data from a single other file. So typically when I open "Project.xls" it will update the data for "A.xls" but will not update the others.

I am currently using Excel 97 (maybe that's part of the issue...)

I appologize that I can't be more clear about when it updates and things, but I eventually gave up and just created one file with many tabs.

Any ideas? Thanks, MechEng2005

RE: Reference to multiple workbooks?

You can set up a database query instead.
Go to Data/Import External Data/New Database Query... and link to the spreadsheets. It helps if the source spreadsheets have range names defined for the exported data.

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: Reference to multiple workbooks?

(OP)
Thank you!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources