+ Reply to Thread
Results 1 to 17 of 17

Why does my workbook not calculate now?

  1. #1
    Registered User
    Join Date
    03-09-2014
    Location
    Canada
    MS-Off Ver
    Excel Mac 2011
    Posts
    5

    Question Why does my workbook not calculate now?

    Hello:

    I know you are all thinking "Excel isn't crazy, it must be user error", I hope you are right

    I have a self created home budget in excel that worked fine. I open the file, everything appears to be working fine until I enter any data on one sheet. Then everything stops calculating (even the cells that were working fine when I opened the file).
    • When I undo the data I entered, it will still not calculate older data (which was calculated when the sheet was opened) and remains blank.
    • I have replaced the data sheet with a copy, and it still will not cause the cells to recalculate (as they did when the file is opened).
    • Even adding a new row to the sheet will cause everything to uncalculate. Removing this row does not cause the file to revert back
    • Only changes to columns A,B,C,D seem to be affected. I can edit the other columns without the other sheets going blank

    The excel file has about 6 sheets, 5 of which take information from 1 sheet (named 'Data') and calculate it.

    Example:

    FLOP, Revenue, Expenses, Assets, Liabilities, Data

    It is when I change, or type anything on the 'Data' sheet (columns A,B,C,D) the other sheets calculate nothing. Any ideas? :S

    Here is a copy of the file if you want to see for yourself. I only have one months worth of data on it (sorry my personal finance numbers are not impressive I will be trying it on my wives computer to see if it is just me.
    Personal Books 2014(copy).xlsx
    Last edited by FDibbins; 03-09-2014 at 05:03 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: In need of help--Excel is crazy!

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Ben Van Johnson

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: In need of help--Excel is crazy!

    Please respond to the Elder Statesman's request to change your thread title ... then maybe we can open a discussion.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: In need of help--Excel is crazy!

    Works fine for me, change your title to something more descriptive, and we can discuss it further
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: In need of help--Excel is crazy!

    Yep, same for me. But my thoughts must remain my own ...

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: In need of help--Excel is crazy!

    @Ford: as a Moderator, you could do the "decent thing" ...

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Why does my workbook not calculate now?

    Good point Trevor.


    Check to see if you have calc set to manual?

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: Why does my workbook not calculate now?

    When I opened the workbook, it asked if I wanted to update links. I generally don't as, normally, I wouldn't have the linked workbook.

    In this case, I checked, and the links referred to the original workbook (in my downloads folder). I would suggest that using Data | Edit Links | Change Source | and navigate back to the source (this/original) and OK'ing out would resolve the issue. Otherwise, making changes probably means that the links would need to be refreshed.

    Regards, TMS

  9. #9
    Registered User
    Join Date
    03-09-2014
    Location
    Canada
    MS-Off Ver
    Excel Mac 2011
    Posts
    5

    Re: Why does my workbook not calculate now?

    It looks like someone was kind enough to change my title for me--should I change it again? Sorry about that, I did not mean to break the rules I will check out the advice given and let you know if it works.

    Thank you all for your time and help--I do really appreciate it.

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: Why does my workbook not calculate now?

    should I change it
    If you have a better choice of title, yes. But there's probably no need.

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Why does my workbook not calculate now?

    No, You can leave it as is, unless you feel you want to change it

  12. #12
    Registered User
    Join Date
    03-09-2014
    Location
    Canada
    MS-Off Ver
    Excel Mac 2011
    Posts
    5

    Re: Why does my workbook not calculate now?

    Ok, I have tried both steps. Calculations are set to Automatic and I updated the source links. Unfortunately the problem is still here. When I type something in column A/b/c/d on the 'Data' sheet, it still creates blank calculations where there were previous numbers.

    Here are some screen shots to give you a better idea of what I mean.

    WORKBOOK IS ATTACHED


    BEFORE, NOTE THE NUMBER TOTALS
    Attachment 303065

    THE CHANGE. I TYPED 'TEST'
    Attachment 303066

    AFTER, NOTE THE NUMBER TOTALS--THEY ARE GONE.
    Attachment 303067
    Attached Files Attached Files

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Why does my workbook not calculate now?

    Sorry, but screen shots wont let us see whats happening inside the workbook, please upload a sample workbook

  14. #14
    Registered User
    Join Date
    03-09-2014
    Location
    Canada
    MS-Off Ver
    Excel Mac 2011
    Posts
    5

    Re: Why does my workbook not calculate now?

    I have the workbook in the original post, but it is a good idea to upload it again with the screenshots to keep everything together. Edit made!

  15. #15
    Registered User
    Join Date
    03-09-2014
    Location
    Canada
    MS-Off Ver
    Excel Mac 2011
    Posts
    5

    Re: Why does my workbook not calculate now?

    This must be a hard one I take it no one else knows why it is doing this?

  16. #16
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Why does my workbook not calculate now?

    I think the problem is with your date criteria. It is correct for me when I change formulas to use DATE function:
    =SUMIFS(Data!$C:$C,Data!$A:$A,">="&DATE(2014,1,1),Data!$A:$A,"<="&DATE(2014,1,31),Data!$B:$B,$A5)
    for example.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  17. #17
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Re: Why does my workbook not calculate now?

    Please see the attached updated example.

    Formulas have been modified for the DATE function. For example:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The SUM of SUMIFS on the Expenses sheet is redundant/

    Sample data has been added purely to check that it is recorded in the correct column

    Regards, TMS
    Attached Files Attached Files

+ 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. Permissions gone crazy in Excel
    By osborn in forum Excel General
    Replies: 6
    Last Post: 04-21-2011, 07:14 AM
  2. Excel 2007 : Crazy Excel Question
    By digitalrookie in forum Excel General
    Replies: 2
    Last Post: 01-03-2010, 11:14 PM
  3. Excel cant count or I am crazy!
    By StevenAFC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2009, 10:50 AM
  4. Excel 2003 has gone crazy!!
    By Amenette in forum Excel General
    Replies: 1
    Last Post: 03-28-2006, 12:25 PM
  5. Excel is going crazy!
    By Grotifant in forum Excel General
    Replies: 0
    Last Post: 02-17-2005, 08:34 AM

Tags for this Thread

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