View Single Post
  #1   Report Post  
matpoh
 
Posts: n/a
Default Which method is faster


I really dont have formulas that reference the sheets, but I do have one
"main menu" page that hyperlinks to all the individual sheets.

What I am thinking is pretty much what you suggested, put each new
season in its own file and just link to those files.

Currently the workbook is about 3-4 megs and it takes a while to open
and save, but moving within the workbook from sheet to sheet is pretty
quick.


--
matpoh
------------------------------------------------------------------------
matpoh's Profile: http://www.excelforum.com/member.php...o&userid=27024
View this thread: http://www.excelforum.com/showthread...hreadid=477923