RE: $$Excel-Macros$$ Please guide me to save time.

2010-02-26 Thread Dave Bonallack
ve. 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 prob

$$Excel-Macros$$ Please guide me to save time.

2010-02-26 Thread Vinu
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.