Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2009
    Posts
    10

    Unanswered: How can I stop this template from locking up

    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.
    Attached Files Attached Files

  2. #2
    Join Date
    May 2009
    Posts
    258
    All of your formulas go all the way down to 65536... are you really going to need over 65,000 devices?

  3. #3
    Join Date
    Jul 2009
    Posts
    10
    Not really. I figure it was to to be redundant. To make sure I don't miss any devices.

  4. #4
    Join Date
    May 2009
    Posts
    258
    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

  5. #5
    Join Date
    Jul 2009
    Posts
    10
    I will give it a try thanks.

  6. #6
    Join Date
    May 2009
    Posts
    258
    No problem, let us know how it turns out.

  7. #7
    Join Date
    Jul 2009
    Posts
    10
    Ax,
    Sorry took so long to get back, was on a much needed vacation. Everything worked great thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •