Hi, Not sure if sumproduct is faster than sumifs. But it may be that much of your data is historical (past months or years) and doesn't update any more. All non-updating cells that contain formulas, could be replaced with just their numerical data. Since your workbook is large, you could write VBA code to help you do this. The simplest would be:
Sub FormulaToNumber ActiveCell = ActiveCell.Value End Sub Then give it a shortcut key like Ctrl+q, and just go through cell by cell pressing Ctrl+q But if there's thousands of these, you'd have to get a bit fancier. Regards - Dave. Date: Fri, 26 Feb 2010 18:20:50 +0530 Subject: $$Excel-Macros$$ Please guide me to save time. From: vinu1sm...@gmail.com To: excel-macros@googlegroups.com Hello Frnds, I am using 2007 excel. My file size is 21 MB. I used sumifs formulas extensively in each sheet(total 25 sheets). My problem is whenever I open the file or close or calculate or save it takes much time say 20 min. Would like to make my workbook faster. Could you please guide me. I have some idea like: Shall I use sumproduct instead of sumifs - sumproduct is faster than sumifs?? shall I use Pivot table and get pivot formula to get data. or any other ways. Please guide me. Regards, Vinu. -- Regards Vinod Kumar Bangalore +91-9986423819 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _________________________________________________________________ If it exists, you'll find it on SEEK. Australia's #1 job site http://clk.atdmt.com/NMN/go/157639755/direct/01/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
