combine multiple spreadsheets into one workbook

's Computer Specifications

i have approx 800 individual excel files. i want to put them all into one
excel workbook - creating one workbook with 800 worksheet tabs.
Is this possible without opening them all and dragging them into the one
workbook one at a time?

's Computer Specifications

Jen - You may run into a limit on the # of tabs in a workbook. Not sure
about that. Even if there isn't a limit, you are looking at an enormous
amount of memory required to open such a workbook. However, if you want to
try, look at Ron de Bruin's add in that will merge workbooks

http://www.rondebruin.nl/merge.htm

"Jen" wrote:

> i have approx 800 individual excel files. i want to put them all into one
> excel workbook - creating one workbook with 800 worksheet tabs.
> Is this possible without opening them all and dragging them into the one
> workbook one at a time?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine several spreadsheets with multiple worksheets into 1 file	jydoug	Microsoft Excel Worksheet Functions	5	12th Apr 2010 05:50 PM
Open multiple workbook then combine into single workbook butdifferent sheets	geniusideas	Microsoft Excel Programming	3	25th Nov 2009 11:47 PM
How do I combine 50 spreadsheets into 1 workbook with 50 sheets	excel@moorehead.net	Microsoft Excel Worksheet Functions	1	27th Oct 2008 01:10 PM
excel: combine several spreadsheets into one workbook	RickS	Microsoft Excel Misc	6	10th Jul 2008 04:45 PM
Combine Multiple Spreadsheets	CCourtois	Microsoft Excel Worksheet Functions	3	7th Oct 2003 09:38 PM