Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Gauteng, South Africa
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculate message on status bar (97SR1)

    One spreadsheet I use keeps on displaying the "Calculate" message on the status bar at the bottom. I've checked, and it is set to Automatic recalc (under Tools/Options). There are links, but these are also set to Automatic update, and the message does not display on an identical file with the same links. Pressing F9 does nothing, nor does pressing "Calc Sheet" on Tools/Options/Calculation. There is a Pivot table that was updated. Any ideas, anyone?
    Thanks

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate message on status bar (97SR1)

    Depending upon whether or not you use VBA code in the file, you may have stopped the code at some point. Try the following code to reset the status bar.

    Sub Start()
    Application.StatusBar = False
    End Sub

    This will reset the status bar to "Ready"

  3. #3
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate message on status bar (97SR1)

    May not be the case here, but I spotted somewhere that 'Calculate' in the status bar can also mean that Excel can't keep track of dependencies any more? Some number like 65,000(ish), limit? I fell over this myself recently by creating a 'sort of' circular reference. For some reason the circular reference only showed itself if I exported all my worksheets to a new workbook, and it also caused Excel 97 SR2 to crash during a File Save of the NEW workbook.

    Once I discovered and removed my inadvertant circular reference, the 'Calculate' status disappeared and Exporting to a new workbook and then file saving worked without problem.

    Just in case..

    Regards
    Peter

  4. #4
    New Lounger
    Join Date
    Nov 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate message on status bar (97SR1)

    See Microsoft KB article Q248179. In the past I have experienced this when I had defined too many custom number formats.

    Good Luck

  5. #5
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate message on status bar (97SR1)

    In my experience this means you have a circular reference somewhere.

    (not)stuck(at the moment)

  6. #6
    New Lounger
    Join Date
    Mar 2001
    Location
    Gauteng, South Africa
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate message on status bar (97SR1)

    Thanks guys (sheepish grin!), but I hate to admit that it was a circular reference. Strangely enough, it did not show the CIRC message in the status bar, which is why I didn't pursue that line of thought. When my colleague opened it on her PC, it showed CIRC and was easily traced and fixed. I didn't think to check with the circular reference toolbar, next time I'll know.
    Cheers & thanks.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Calculate message on status bar (97SR1)

    Do you have iterations checked?

    If either iterations is on OR calc is manual, Excel will not warn about circ references.

    Steve

  8. #8
    New Lounger
    Join Date
    Mar 2001
    Location
    Gauteng, South Africa
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate message on status bar (97SR1)

    Iterations were on indeed. Never knew that it would have this effect, though it makes sense. Thanks.

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate message on status bar (97SR1)

    To enlighten what XL does with its calc settings:

    - Calc settings are saved with a workbook but they are NOT workbook-specific, changed settings apply to the entire Excel session.
    - Excel keeps the Calc settings of the *first* normal workbook it loads (until one changes them of course), regardless of the saved settings of workbooks loaded after that first one.
    - If one closes all workbooks, Excel will pickup the calc settings of the next workbook that is loaded.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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