+ Reply to Thread
Results 1 to 4 of 4

A workbook which is exhibiting strange behaviour,

  1. #1
    Registered User
    Join Date
    03-26-2015
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    75

    A workbook which is exhibiting strange behaviour,

    Hi all,

    I have a heavy workbook that has calculations set to manual but now has now refused to calculate sheets when I press the 'calculate sheet' button. Also turning back on automatic calculations doesnt work. It only recalculates when I manually select a cell's content and press enter. In addition, when the file is set to manual calculations it wants to calculate whenever I am saving (It never used to do that). Anyone know what could be the cause?

    EDIT: I ask this in the VBA section because I have used code before that could explain why it isn't recalculating, such as this:

    ThisWorkbook.Sheets("sheet1").EnableCalculation = True

    But have since reversed the effect and removed the code.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: A workbook which is exhibiting strange behaviour,

    Hi Ronnet,

    This sounds like you have some VBA that changes the calculation mode to manual or automatic in your code. Then this code is fired leaving you wondering what mode is in effect.

    I've been confused by this type of stuff by having EnableEvents code. Then if my code stops after events have stopped, my code doesn't seem to work. I need to then turn events on again in the Immediate Window, using a manual command, to get it back to the desired state.

    Rem out your EnableCalculation code or add Calculate code to insure you are in the correct state to see if that is the problem.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-26-2015
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    75

    Re: A workbook which is exhibiting strange behaviour,

    Hi Marvin, I couldn't figure it out. I removed all code I could find but it continued to happen. So what I did was copy the sheet and gave the copy a slightly different name. This copy worked fine so it must have been some code stuck somewhere.

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: A workbook which is exhibiting strange behaviour,

    Maybe you can do some tests...
    If you reduce the size of the sheet (maybe chop out quite a lot of the data so it is smaller than it was in the past) does it start working?
    Or is it a problem even when you reduce the file down to a small light one?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Strange Macro behaviour
    By Steve6386 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2014, 05:43 AM
  2. [SOLVED] XIRR strange behaviour
    By phe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2013, 01:51 AM
  3. vlookup strange behaviour . . . why?
    By homasa in forum Excel General
    Replies: 2
    Last Post: 08-23-2010, 11:02 AM
  4. Strange Behaviour
    By Mark@Work in forum Excel General
    Replies: 2
    Last Post: 09-30-2008, 12:22 PM
  5. [SOLVED] Strange if(***) behaviour?
    By Excel 2003 - SPB in forum Excel General
    Replies: 6
    Last Post: 08-06-2006, 12:35 PM
  6. Strange VBA Behaviour
    By Ricko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2005, 03:05 AM
  7. Strange behaviour
    By Edgar Thoemmes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2005, 12:06 PM

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