Hi,<br/><br/>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.<br/><br/>Are there any best practices surrounding this?<br/><br/>Best Regards© 2009 Microsoft Corporation. All rights reserved.Tue, 07 Jul 2009 22:58:26 Z40662bf3-dbed-4f10-8443-cff63a15fec4http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/40662bf3-dbed-4f10-8443-cff63a15fec4#40662bf3-dbed-4f10-8443-cff63a15fec4http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/40662bf3-dbed-4f10-8443-cff63a15fec4#40662bf3-dbed-4f10-8443-cff63a15fec4Amar Dhttp://social.msdn.microsoft.com/Profile/en-US/?user=Amar%20DHi,<br/><br/>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.<br/><br/>Are there any best practices surrounding this?<br/><br/>Best RegardsMon, 29 Jun 2009 19:58:45 Z2009-06-29T19:58:45Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/40662bf3-dbed-4f10-8443-cff63a15fec4#5f9a4ea3-b160-40a8-97d6-3e3f271c5d68http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/40662bf3-dbed-4f10-8443-cff63a15fec4#5f9a4ea3-b160-40a8-97d6-3e3f271c5d68Shahar Prish - MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=Shahar%20Prish%20-%20MSFTIt 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).<br/><br/>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.<hr class="sig">Shahar Prish Blog: http://blogs.msdn.com/CumGranoSalis Professional Excel Services: http://www.amazon.com/Professional-Excel-Services-Programmer/dp/0470104864Tue, 07 Jul 2009 22:58:26 Z2009-07-07T22:58:26Z