ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   One Sheet or More?? Help (https://www.excelbanter.com/excel-worksheet-functions/39431-one-sheet-more-help.html)

WTG

One Sheet or More?? Help
 
I have a rather large spreadsheet that does a lot of calculations
Yep, same one I've been working on these last three months :)
by the way thank you all for all the help you've been giving me.
But because it's so large it's very Slow............Really, VERY SLOW
:(

I was just reading a post about multiple work books.

If I understood it right, it sounds like they have one work book file
for each area and then one workbook with a summary sheet that access
the other workbook for the needed information...

would this make the summary sheet work faster because it's not so
large, or slower because it has to access different workbooks?

and if quicker, how do I do it?

Thanks

Wally






All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com