Best Practices for maximum workbook size

Question

Hi,

We are currently enabling excel services for a pilot group of people. Some of them have requested the maximum size of the workbook to be increased more than 10 MB, the default value. However, we have a concern that if we increase it too much it might mean a resource overload.

Are there any best practices surrounding this?

Best Regards

Answer 1

It all depends on the strength and stats of your server machine and on what operations people are going to do. It also depends on what the exact makeup of the file is (for example, if you have a pivot-cache in the file, less of it will be loaded into memory).

I suggest you slowly up the file size and see how it works for you, or try to give more information about your deployment (what machines, how many workbooks, what they contain etc) and I may be able to point you at a better way of figuring out a right number.

---

Shahar Prish Blog: http://blogs.msdn.com/CumGranoSalis Professional Excel Services: http://www.amazon.com/Professional-Excel-Services-Programmer/dp/0470104864