Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
WTG
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data from one sheet to several in sequential order! firecord New Users to Excel 6 June 22nd 05 05:10 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"