Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I have a spreadsheet approximately 1800 rows and 20 columns. It was taking forever to calculate and always hangs up to where i "End Task" I have 4 colums of if formula to check the data but still giving me a whopper of a headache. Any thoughts on getting this worksheet to calculate without a "not Responding" error.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    It depends on the complexity of the formulas. Array formulas (explicit or implicit) for example tend to be calculation-intensive, so if you have 1800 * 4 = 7200 of them, this might explain the slowness.

  3. #3
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    [quote name='MNN' post='777905' date='02-Jun-2009 09:54']I have a spreadsheet approximately 1800 rows and 20 columns. It was taking forever to calculate and always hangs up to where i "End Task" I have 4 colums of if formula to check the data but still giving me a whopper of a headache. Any thoughts on getting this worksheet to calculate without a "not Responding" error.

    Thanks[/quote]
    If you spreadsheet if formulae are referring to other files in a VLookup formula, I have found that having the other files open at the same time can speed up the calculation process.

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

Posting Permissions

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