Excel not changing formulas! :(

Discussion in 'Mac Apps and Mac App Store' started by davidg4781, Oct 29, 2006.

  1. davidg4781 macrumors 68000

    davidg4781

    Joined:
    Oct 28, 2006
    Location:
    Alice, TX
    #1
    Well, I'm slowly starting to move everything over to my new macbook from my desktop Windows XP PC. The latest thing I moved over was my financial stuff. I set up all my accounts on Quicken and put my budgets and hours list onto my USB drive. I was using this with Excel on the WXP and I'm opening them with Microsoft Office for Mac. Here's the problem...

    On my budget (13 worksheets, 1/period) the cells don't change as I enter numbers. If I save it, everything updates, but I don't like that idea. When I'm doing my school work and with the hours (one worksheet with 52 lines (for the weeks) and a few other formulas) I don't have this problem at all.

    I have the 2.0GHz Macbook with 512MB of RAM. Could that be the problem? I have no other applications running at the time when working on this.

    I hope someone can help me, I'd really like to try to get everything moved over to my Macbook. Well, mostly everything. I still like using a full size screen/keyboard/mouse/etc. but want to get used to using a Mac. My next desktop will PROBABLY be an iMac.
     
  2. davidg4781 thread starter macrumors 68000

    davidg4781

    Joined:
    Oct 28, 2006
    Location:
    Alice, TX
    #2
    Whoa! Update! It's not doing it on my PC either. Ok, maybe I have something weird checked. I'll have to check it out tonight. If someone knows of something, let me know.

    Thanks!
     
  3. Applespider macrumors G4

    Applespider

    Joined:
    Jan 20, 2004
    Location:
    looking through rose-tinted spectacles...
    #3
    Check if you've got auto-calculation or manual calculation set in Options.

    If so, it will always say Calculate on the bottom bar (on the PC at least) when you change a value. Hitting F9 on the PC will force it to calculate.
     
  4. davidg4781 thread starter macrumors 68000

    davidg4781

    Joined:
    Oct 28, 2006
    Location:
    Alice, TX
    #4
    Thanks! That did it. Now, if Missing Sync and a few of the protective accessories (marware, iKlear, etc.) were to suddenly go on sale, I'd be 100% happy.
     

Share This Page