Posted to microsoft.public.excel.misc

Vanessa Simmonds Vanessa Simmonds is offline

external usenet poster

Posts: 17

SUMPRODUCT Formula

Good Morning,

I have a big spreadsheet which is populated by sumproduct formulas.

The spreadsheet has about 173 rows and 15 columns. Every cell is populated
by at least two sumproduct formulas.

This is making the workbook extremely slow and most of the time is crashes.

Is there anything i can do to make it quicker?

Thank you very much.

Vanessa Simmonds

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with SUMPRODUCT formula	Craig	Excel Discussion (Misc queries)	4	November 4th 08 01:13 PM
Nesting a sumproduct formula within a sumif formula.	jerrymcm	Excel Discussion (Misc queries)	2	October 3rd 07 03:35 PM
SUMPRODUCT Formula	Dan	Excel Worksheet Functions	6	February 21st 07 02:25 PM
Sumproduct Formula Help	Harley	Excel Discussion (Misc queries)	3	January 6th 07 07:26 PM
SumProduct Formula	carl	Excel Worksheet Functions	2	January 31st 06 08:14 PM

All times are GMT +1. The time now is 01:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us