+ Reply to Thread
Results 1 to 5 of 5

Calculate slowing sheet

  1. #1
    Forum Contributor
    Join Date
    11-24-2008
    Location
    leicester
    MS-Off Ver
    Windows 2003
    Posts
    153

    Calculate slowing sheet

    HI,

    If the below formula is activated - e.g. something is put into cell f8 or g8, the I get the word calculate in the bottom left hand size of the s/sheet.

    Anyone know how i can over come this?

    Thanks

    Antony


    Please Login or Register  to view this content.
    Last edited by antony moseley; 01-18-2010 at 05:26 AM. Reason: solved

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Calculate slowing sheet

    Hi antony,

    it looks as if this code has not been copied from a cell, but rather typed directly in the thread. What is in cells F8, G8, A1, A8??

    Slowness of calculation can be due to large amounts of data and/or volatile functions feedint the underlying cells.

    Care to post an example?

  3. #3
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Calculate slowing sheet

    What this formulae is supposed to do?
    Is is just concatenating related cells' contentents or smth else?
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  4. #4
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Calculate slowing sheet

    See if calculation is put manual in Excel. If yes then change it to automatic

    2007 excel
    formulas->calculation options->automatic

    older versions
    tools->options->calculation->automatic

    You can also try the following (got from John Walkenbach's book)

    F9 calculate the formulas (all open workbooks)

    shft+F9 calculate the formulas of active workbook

    ctrl+alt+F9 force a recalculation in all open workbooks

    ctrl+shft+alt+F9 recheck al the dependent formulas and force a recalculation on all open workbooks

    rgds

    johnjohns

  5. #5
    Forum Contributor
    Join Date
    11-24-2008
    Location
    leicester
    MS-Off Ver
    Windows 2003
    Posts
    153

    Re: Calculate slowing sheet

    Quote Originally Posted by johnjohns View Post
    See if calculation is put manual in Excel. If yes then change it to automatic

    2007 excel
    formulas->calculation options->automatic

    older versions
    tools->options->calculation->automatic
    Thanks john - this has sorted by issue - thanks to other that replied aswell

    Antony
    Last edited by DonkeyOte; 01-18-2010 at 05:22 AM. Reason: tags corrected

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1