Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel formulas


  • Please log in to reply

#1
JosephWatchery

JosephWatchery

    New Member

  • Member
  • Pip
  • 4 posts
although when i click on the cell, it shows that there should be a formula, it just does not calculate it, did anyone ever encounter this problem? Does anyone know how to fix this?

Thanks so much.

Joseph
  • 0

Advertisements


#2
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Welcome to Geeks to Go.

It sounds like manual calculation is turned on. In your spreadsheet, if you press the F9 key, do your calculations happen? If so, go to Tools, Options, Calculation tab, and check Automatic (this will uncheck Manual).

Did that do it? If not, please confirm your version of Excel. Is it completely up-to-date with Microsoft updates?
  • 0

#3
JosephWatchery

JosephWatchery

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
thanks so much for your quick reply! i did try to press the F9 key and it worked, do you know how to make it work without pressing the F9 key? It just worked earlier today. Please advise.

PS, I will make sure to donate via Paypal!!!
  • 0

#4
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Check the Calculation tab (Tools, Options). The top of that tab has a place for Automatic (to the left) or Manual (to the rigth). Choose Automatic. Save the worksheet, close Excel, then open everything back up.
  • 0

#5
JosephWatchery

JosephWatchery

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
I actually just made the donation! I am very impressed with your speed! i am sure that you will help me with this!
  • 0

#6
JosephWatchery

JosephWatchery

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
thanks so much!!! It worked! Did you get the paypal payment?
  • 0

#7
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Yes, thank you so much. :whistling:
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP