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

Calculate appearing on the left hand courner

Hi

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.

Greg
0
greg_c
Asked:
greg_c
1 Solution
 
hitsdoshi1Commented:
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
0
 
greg_cAuthor Commented:
Nope, I coverted it to numerical data.
0
 
Saqib Husain, SyedEngineerCommented:
Is calculation in automatic mode or mannual
Is there a circular reference?
0
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
0
 
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

Regards,
Rory
0
 
greg_cAuthor Commented:
Thank you.
0

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