Calculations may not occur in an Excel

's Computer Specifications

Hi, I'm having the exact same problems with multiple users on different excel workbooks; formulas just don't recalculates values, combination of F9 and cell format methods didn't solve the issue.
The only workaround I've found is copying a cell value within the calculation problem range and then pasting it to the rest of the range cells, then values are calculated correctly.
Have anyone found a permanent solution or identified the root cause?

Thanks.

Rubens Onofrio wrote:

ALT-CNTRL-F9
09-Sep-09

Hi Bob, Excuse my intrusion, but I'm having the same problem. I tried ALT-CNTRL-F9 and it works, but I have to press these 3 keys every time I enter a new data int the worksheet.

EggHeadCafe - Software Developer Portal of Choice
Dynamic Sql-based Self-Caching RSS 2.0 Feed Generator ASHX
http://www.eggheadcafe.com/tutorials...ed-selfca.aspx

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get excel to list values that occur within raw data	=?Utf-8?B?ZGVubmlzMzQ=?=	Microsoft Excel Misc	2	5th Oct 2005 12:09 PM
Will problems mostly occur when import from Excel??	=?Utf-8?B?S2VsbHkgTGlt?=	Microsoft Access External Data	2	16th May 2005 02:29 PM
Auto recovery of Excel file when error occur	=?Utf-8?B?SnVsaWU=?=	Microsoft Excel Worksheet Functions	2	19th Oct 2004 12:40 AM
Show 4 Records that occur more often...and how often they occur.	Miguel Dias Moura	Microsoft ASP .NET	4	6th May 2004 04:40 PM
Show 4 Records that occur more often...and how often they occur.	Miguel Dias Moura	Microsoft VB .NET	5	6th May 2004 04:19 PM