Consolidate Multiple Workbooks - Excel 2007
 

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.

Consolidate Multiple Workbooks - Excel 2007
 

Hi Nadine

I can help you with a VBA code example if you want.
You can start with the code on this page and if you need help let me know
http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Nadine" wrote in message ...
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.