Excerpts from netnews.comp.apps.spreadsheets: 23-Dec-94 Consolidation in
> I've read the manual and still don't understand this.
> Could someone step me through a simple link of two different workbooks
> summarized into a third? Each time I define my source area in one workbook,
> and then move to my destination workbook and choose "consolidate" . I then
> select the range name I want to cite from and choose OK. This results in
> the following error: "Source Reference overlaps destination area."
> like to consolidate by "position" (actually a range name in my source
> Any simple instructions would be appreciated. Thanks in advance.
> Jim Powell
> Jefferson Medical College
> Phila., PA 19107 (215)955-2132
What you need to do is first select the area on your destination sheet
where you want the consolidated data to reside in. Then select, Data
Consolidate (or whatever the relevant command is in 5.0; I use 4.0). At
that point a dialog box will appear asking what regions you want to
consolidate. You can type them manually or select Window and then the
relevant spreadsheet and highlight the first area to consolidate. Then
select Add from the dialog box. Repeat this process until all areas
have been added. At that point select OK. Your consolidated data will
be placed on the destination sheet.
NOTE: in my opinion the nicest thing about the data consolidation
feature is the ability to create links to the source data. If you check
this box before doing the consolidation, the destination spreadsheet
will be converted to an outlined spreadsheet that references the source
data. That way, if the source data changes, your consolidated
spreadsheet will update automatically.
If this still doesn't do the trick for you, let me know and we can walk
through this over the phone if you like.