Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dede McEachern
 
Posts: n/a
Default Linking Workbooks

I am having a problem with my linked workbooks. The workbooks are in three
levels and I can't get the top level workbook to reflect data from the bottom
level workbook unless the middle level workbook is open.

Example:
Imagine I work at GM. I have a data entry workbook in which I enter basic
information for types of cars we sold. That data entry workbook populates
specific data into worksheets in mid level workbooks for each brand of car we
sell. There would a separate mid-level workbook for each Cheverolet, GMC,
Oldsmobile, Pontiac, Buick, Hummer and Saturn. In the Cheverolet workbook,
there would separate worksheets for Prius, Silverado, Tahoe, Cavalier and
Malibu. Each of those worksheets is populated with linked from the data
entry workbook. There is a summary page for each mid-level workbook on which
data from each worksheet in that workbook is summed.

The top level workbook contains separate wooksheets that are linked to each
summary worksheet in the corresponding mid-level workbook. In my example,
there would be a separate worksheet for Cheverolet, GMC, Oldsmobile, Pontiac,
Buick, Hummer and Saturn and an "overall summary" worksheet that sums all of
these worksheets together to give me raw statistics about GM cars, such as
how many cars did GM sell last year.

My problem is that these links do not work reliably. In order to get the
information populated into the top-layer workbook, I have to have each of the
corresponding mid-level workbooks open. I don't seem to have a problem
linking the data from the data entry workbook to the mid-level workbook when
the data entry workbook is closed.

Having all of these mid-level workbooks open (there are 32 of them) defeats
the purpose of linking. Is there any way to correct this problem?

--
Dede McEachern
Director of Licensing
Texas Department of Licensing and Regulation
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tools/Compare and Merge Workbooks - Excel 2003 Pro Laura Excel Worksheet Functions 1 January 3rd 05 06:45 PM
Automatic updating worksheet data between different workbooks Yiannis Excel Worksheet Functions 0 December 28th 04 01:01 PM
Linking Workbooks madge Excel Worksheet Functions 2 December 22nd 04 02:15 PM
Workbooks...I'll try this again... Markster Excel Discussion (Misc queries) 10 December 7th 04 11:12 PM
Linking to other workbooks Adam Excel Discussion (Misc queries) 1 December 6th 04 04:24 PM


All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"