| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine multiple spreadsheets into one workbook
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combine multiple spreadsheets into one workbook
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine several spreadsheets with multiple worksheets into 1 file | Excel Worksheet Functions | |||
| Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
| How do I combine 50 spreadsheets into 1 workbook with 50 sheets | Excel Worksheet Functions | |||
| excel: combine several spreadsheets into one workbook | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
