Excel problem

  • Creator
    Topic
  • #188694
    y_u_no_pass
    Participant

    This is a little off-topic, but I’m desperate as I am the only one at my office right now. Suddenly formulas aren’t working. When I copy it over it starts copying just the values from prior cell. This is excel 2003, btw. Then I select copy formatting only, but the formula fills, but doesn’t work until I click on the cell and hit enter. Then the formula will update for any new info. Any ideas? Anyway I’m a little desperate because I still have 2 returns to finish tonight.

    Florida CPA!
    Took final exam 2/25/15.
    Sent in Application 3/12/15.
    Issued License 3/20/15.
    Used CPA Excel solely for all exams.

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #608126
    y_u_no_pass
    Participant

    I figured it out with google. In case anyone is wondering this is the fix.

    Tools > Options > Calcualtion Tab then click Auto Calc

    Not sure how to delete a post. But anyway thanks

    Florida CPA!
    Took final exam 2/25/15.
    Sent in Application 3/12/15.
    Issued License 3/20/15.
    Used CPA Excel solely for all exams.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.