Can Excel pull values from a one spreadsheet's cells to calculate numbers in a different one? AFAIK, this isn't possible. It's easily done on the same spreadsheet which is why your totals and the averages autoupdate in the main spreadsheet (when configured properly), but the league spreadsheet is seperate, only stored at the same url. If the league scores were at the bottom of the main spreadsheet, it could autoupdate, but its a lot easier to access as it is.