PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 5.00 average.

Formulas not calculating in Excel in Office 2007- all set to autom

 
 
Damion Young
Guest
Posts: n/a
 
      13th Nov 2008
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


 
Reply With Quote
 
 
 
 
Smitten Kitten
Guest
Posts: n/a
 
      29th Dec 2008

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.
 
Reply With Quote
 
 
 
 
Jay Wynn
Guest
Posts: n/a
 
      13th Jan 2009
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
 
Reply With Quote
 
New Member
Join Date: Aug 2011
Posts: 1
 
      24th Aug 2011
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!!
 
Reply With Quote
 
New Member
Join Date: Mar 2012
Posts: 1
 
      26th Mar 2012
This could simply be due to a circular reference, I just made that mistake

Jon
 
Reply With Quote
 
New Member
Join Date: Apr 2012
Posts: 1
 
      16th Apr 2012
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.
 
Reply With Quote
 
New Member
Join Date: Sep 2012
Posts: 1
 
      18th Sep 2012
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.
 
Reply With Quote
 
New Member
Join Date: Jan 2013
Posts: 1
 
      24th Jan 2013
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendar is stuck on 2/23/09 & will not move to current day autom Calendar is stuck on 2/23/2009 Microsoft Outlook Calendar 1 31st Mar 2009 08:16 PM
Auto name check is on. When typing new e-mail, name is not autom. =?Utf-8?B?a3Jw?= Microsoft Outlook Discussion 1 3rd Feb 2006 10:12 PM
Excel - Autom. Filter "Empty / Non Empty cells" should come first =?Utf-8?B?Um9t?= Microsoft Excel Misc 0 10th Aug 2005 04:32 PM
OL 2000 should not autom send/receive on start Hans Microsoft Outlook 1 16th Jun 2004 07:46 AM
Email adress does not show up autom. compie1 Microsoft Outlook 0 12th Mar 2004 05:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:58 PM.