What's faster? 1 workbook or multiple workbooks?

  • Thread starter Thread starter WTG
  • Start date Start date
W

WTG

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
 
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
 
You must log in or register to reply here.

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

Similar Threads

Excel Move or Copy Stopped Working? 0
Aggregating data among multiple workbooks 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel 2007 - Linking workbooks 1
Compile data from several workbooks 1
trouble with closed workbook 2
Copying Worksheets From Different Workbooks using Marco 4
Find matching data in two workbooks 1

Back
Top