I have just spent an hour or so struggling with this - in my case, it was two things:

1. spaces in formulae
2. setting the cell format to 'General' if it was 'text'

The weird thing is that Excel allows you to edit the formula in the Function Arguments dialog box but still won't display the result....incredibly anoying.

Hope this helps

This happens to me too. As far as I've been able to determine it only happens when there is an invisible excel.exe in your proces list. Use the taskmanager to kill the process, or reboot, and in my case the problem was solved.

Another effect of this is that the personal macro's don't load.

Good luck.

I also encountered the problem with formulas/cells not calculating. Discovered that there were a series of circular references embedded in the sheet. Killed those by hard-coding values, and the remaining cells calculated just fine.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

[placey]

Just wanted to weigh in on this as Damion Young's post nailed it for me. I found that the only cells that had this problem were those that were formatted as Text. Once I changed the cell formatting to General and refreshed the formula (I just d-clicked to enter "edit mode" on the cell then hit Enter) it displayed the result of the formula.

Thanks Damion!!

[jonesse2]

This could simply be due to a circular reference, I just made that mistake

Jon

[yt_L9]

I'm having a similar issue that seams to stem from copying data from excel 2003 that was dumped there by a SQL database. When pasted into Excel 2007 none of the formulas depending on those values work (they don't work in 2003 either, I did check). As a simple example:

# GROSS NET GROSS NET %
1 $125.00 $75.00 $0.00 $0.00 0%

The formulas for where it states 0 are
Gross : =B2/A2
Net : =C2/A2
% : =1-C2/B2

I don't have a hidden excel running, at least not visible from task-manager and there aren't any circular references. My personal workbook also is working fine.

When I use the insert function button with the formula in place it returns the proper value but it will still show up as a 0 in the cell.

[Geet]

Hi All,

Even I faced the same prob. And could find the reason atleast in my case. Not sure if this is applicable for all others who face the same.

In my case, the formula that i had used was a user-defined one. Logic was created with vb. In my logic I had to send certain non-contiguous cells to be processed further. I had sent these cells as "range"(data type) as I came to know range datatype supports both contiguous and non-contiguous cells.

As such the formula "works" but never "updates". I had to forcefully update it by repasting and saving. Setting automatic option, or formatting cell to general, ctrl+` and lot others din work.

Finally once i changed the cells from non-contiguous to contiguous cells the formula started updating. Wen i tried changing back to non-contiguous cells it failed.

So to my knowledge though range accepts and processes non-contiguous cell data successfully issue occurs in formula updation.

I am sure this might not be the scenario in all of your cases but hope it helps atleast a few.

[florin_bv]

Hello
I have the same problem in Excel 2007 with autocalculation enabled.
I generate formulas in cells using VBA.
Some cells show correct result, some show nothing.
If I open the file using Excel 2003, Excel Starter or OpenOfice the results are OK ! ! !
I close the file (without saving), open with Excel 2007 and the results are not OK.
(They work with F2 and enter, for each cell)
When I add a new sheet all cells autocalculate and show correct result. Then I delete this new sheet.
Florin