Excel 2010 slow update of worksheet

		Microsoft Office Forums > Microsoft Excel > Excel
Excel 2010 slow update of worksheet

FAQ

Thread Tools

Display Modes

03-28-2012, 01:11 AM

bosve73

Windows 7 64bit Excel 2010 slow update of worksheet

Office 2010 32bit

Novice

Join Date: Aug 2010

Posts: 6

I narrowed it down to the formula that I use SUMPRODUCT is what is causing the slowdown:

=SUMPRODUCT((Department="Red")*(Status="Start"))
Is there a better way to do this?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - Color Worksheet Tabs	avie layne	Excel	4	11-12-2012 04:45 PM
Distortion trying to embed excel worksheet	Sugaratias	Word	0	11-26-2011 11:26 AM
Embedded Excel in Word very slow to update	delaneybob	Word	0	02-11-2011 10:03 AM
VB Code in Excel Active worksheet	shakilhyd	Excel	2	05-17-2010 07:50 AM
PowerPoint Master - 50 LINKED slides - SLOW Update	salfonsi	PowerPoint	0	09-27-2008 02:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 PM.