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