Consolidate Multiple Workbooks - Excel 2007

N

Nadine

I have a summary worksheet in multiple workbooks, want to summarize them all
into one workbook.

I named the range in each workbook, but when try to consolidate into a new
workbook, I get error "reference is not valid" okay to that then get "cannot
open consolidation source file "name of my file"

When I select Consolidate - in the Reference field, I browse for the file,
and at the end of the filename path after the exclamation mark ! I add the
name of the Range, select add (am I putting the range name in the wrong
spot, the help doesnt' show you where to add the range when browsing for
another file, just says add the range, but not where in the path to add it).

i.e. 'TEAM A - 2009 Statistics.xlsx'!Summary

Also tried it with having the Team workbook open in the background.
Can I no longer do this by range name anymore?
I took off all the document protection had in the team workbook.
Each of the team workbooks, contain multiple worksheets, but the first
worksheet summaries all the monthly worksheets sheets into a team summary by
month
all the workbooks have all the same formatting an layout.
Pivot table doesn't meet my needs.
 

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