View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Excel cells randomly don't get updated

Check this list:

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Lost in Excel" wrote in message
...
| Hello Everyone
|
|
| We are having a random problem where Workbook Cells don't get updated unless
| the user goes into the cell and presses enter in each cell. F9 does not work
| when the problem occurs. Most of the time everything works perfectly but just
| at random times it hiccups. The smallest workbook is around 20 Megabytes in
| size and it contains a numerous amount of sheets that are tied to each other
| with forumlas and a total sheet in the begining that gets the numbers from
| previous sheets up to 4 levels deep. We usually see this problem in the Total
| Sheet and when a deeper level sheet gets changed. This occurs across several
| different machines. We also tested this with Excel 2007 on our most powerful
| PC and saw the same problem. Some of the machines are dual cores with 2 gigs
| of ram. This has happened with different workbooks, both locally and on the
| network. There are no Macros no errors. We even had support check our
| workbooks and everything looks sound and within Excel's capabilities. They
| also confirmend that all of our settings are correct. The machines are all
| running Windows XP SP3, Office 2003, McAfee 8.5, Groupwise 7.0.2 to 7.0.3
| (With integration turned off), Adobe Reader. Does anyone have any ideas? Any
| help is really appreciated. I tried CTRL +SHIFT +ALT +F9, That did not work.
|
|
|
| Thank you,
|
|