File size and server limit

  • Thread starter Thread starter mymk
  • Start date Start date
M

mymk

A spreadsheet I am building has reached a painful size of 32MB where
am getting calls from IT on a daily basis as the file ties up most o
the resources on the server.

Anyone has any idea on size limitation and speed?

A better question may be, if I were to modify the spreadsheet, what'
the minimal amount of MB's I need to reduce to be speed efficien
without congesting server?

Thanks for any input
 
To continue with earlier post, the function "sum if" is being use
throughout the spreadsheet - is this a taxing function in terms o
capacity and speed? What may be a good alternative function to use?

Thanks for your help
 
Back
Top