• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Calculate appearing on the left hand courner


I was asked to help someone yesterday with the their the Excel (2003) spreadsheet.  It was a basic sum problem.  I used the sum formula, pressed F9 and for some reason it wouldn't caluclate.  The format was in numbers, and the work calculate appeared in the left hand corner of excel.

Would anyone know what caused this.  I don't have the spreadsheet available to show you.

1 Solution
It is taking as text value......Is it imported from Access or something? You might want to select that column and from Data -> Text to Column and will solve the issue
greg_cAuthor Commented:
Nope, I coverted it to numerical data.
Saqib Husain, SyedEngineerCommented:
Is calculation in automatic mode or mannual
Is there a circular reference?
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

greg_cAuthor Commented:
Calcualtion was in automatic mode, and there were no circular references
Rory ArchibaldCommented:
What did it return? A formula always tries to calculate if it is entered manually into a cell like that, even if calculation is set to manual.
For possible reasons for Calculate in the status bar see here: http://www.decisionmodels.com/calcsecretsf.htm

greg_cAuthor Commented:
Thank you.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now