| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What's faster? 1 workbook or multiple workbooks?
I have a large workbook, with 25 worksheets.... it's very slow..... :(
some of the sheets just hold data. would it be quicker or slower if I move the data to other workbooks? Thanks |
|
#2
|
|||
|
|||
|
Slower. Perhaps you just need to clean up/troubleshoot your file?
http://www.officearticles.com/excel/...soft_excel.htm http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "WTG" wrote in message ... I have a large workbook, with 25 worksheets.... it's very slow..... :( some of the sheets just hold data. would it be quicker or slower if I move the data to other workbooks? Thanks |
|
#3
|
|||
|
|||
|
What kind of formulas do you have and how many?
Giants workbooks can recalculate in 1/10000 of a second if there are few or simple formulas -- Kind regards, Niek Otten Microsoft MVP - Excel "WTG" wrote in message ... I have a large workbook, with 25 worksheets.... it's very slow..... :( some of the sheets just hold data. would it be quicker or slower if I move the data to other workbooks? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
| Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
| import multiple workbooks into 1 workbook | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Linking Workbooks | Excel Worksheet Functions | |||
Linear Mode
