excelformulas

One long sheet vs many sheets


I am planing to start a porject in excel which will eventually contain about 25 tables, each one with something like 70x30 cells and one main table that draws information from all other tables are presents results accordingly. Since I don't know the exact number of rows and columns and I don't want to leaves spaces to make up for future needed rows/cols, I was thinking about putting each table in a separated sheet. Now my question is how will it affect the speed performance of my poject? (all the cells in the tables contain about a line long formula with calculations)


Solution

  • Can't answer for Google but for Excel distributing over many sheets will not make a significant difference.