Large Excel File

[SportsNerd]

I've create an Excel document that is 38.8 MB. This Excel document is a measuring College Basketball Elo rankings. I have one tab for Game Results, one tab the calculates the Elo ranking after everyday (everyday is represented by row in the Game Results tab) based on the Game Results tab, I have one tab that figures the standing based the differences in the Elo Rating tab, and then I have two tabs to calculate and show the chances on each team to win the NCAA tournament based on current Elo rankings. I have VLOOKUP's and INDEX/MATCH formulas in many different places. Can someone help me make this excel file smaller?

 

[cooper645]

Without knowing how much data we're dealing with, or how many formulas, its hard to say.

The main cause of large files is arguably the formatting. A useful page here and well worth a read to see if it can help you reduce your file size.