How can I stop this template from locking up

Fire Alarm · #1 (**permalink**) 07-20-09, 12:26

I created this template to help in counting devices but with all of the formulas, it keeps locking up when I try to paste in the devices or add a formula. I attached the form. You just need to change the file extension from a .txt back to .xls.

Ax238 · #2 (**permalink**) 07-21-09, 09:57

All of your formulas go all the way down to 65536... are you really going to need over 65,000 devices?

Fire Alarm · #3 (**permalink**) 07-21-09, 10:00

Not really. I figure it was to to be redundant. To make sure I don't miss any devices.

Ax238 · #4 (**permalink**) 07-21-09, 13:50

If they aren't needed, start stripping them down.

Use a formula like the following to get the total number of rows:

Code:

=ROW(OFFSET('FIRE ALARM DEVICES'!A1,COUNTA('FIRE ALARM DEVICES'!A:'FIRE ALARM DEVICES'!A)-1,0))

You can put this on the second and third sheet in say, C1. So then your formulas would be:

Code:

=COUNTIF('FIRE ALARM DEVICES'!$A$2:OFFSET('FIRE ALARM DEVICES'!$A$2,$C$1,0),"SIGA-PS")

Ax

Fire Alarm · #5 (**permalink**) 07-21-09, 15:35

I will give it a try thanks.

Ax238 · #6 (**permalink**) 07-22-09, 09:16

No problem, let us know how it turns out.

Fire Alarm · #7 (**permalink**) 07-28-09, 07:08

Ax,
Sorry took so long to get back, was on a much needed vacation. Everything worked great thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech