Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003 file doesn't update certain cells
I have an EXCEL file in which a few cells simply reference other cells
(e.g., = sheet2!a1) but when I changed the other cells on sheet 2, they did not update. Yes, it is set to auto calculation.Originally, it was auot except tables, but i changed it, clicked save, closed EXCEL, and reopened and it did not help. I even reboooted the computer. If I go into the formula and edit it, that will fix it. If I save the file with a new name, or even do a file save as and use the same name, it updates. But if I merely hit the save icon in EXCEL, it stil does not update, even if I shut down my computer and re-open, it still has the old value. The file does have a long name, although so do the new files that I save it as, and thye are then fine, and react to further changes. I even ran detect and repair. Does anyone have a better answer than my file must be corrupt. It seems that simply saving the file as a new name fixes this corruption, but who can be sure it doesn't exist somewhere else? I set it to manual, then back to automatic, but that didn't help either. In the past, closing EXCEL or even rebooting has made these kinds of problems go away, but not this time. Thanks Dean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003 file doesn't update certain cells
On 23/09/2010 19:31, DA wrote:
I have an EXCEL file in which a few cells simply reference other cells (e.g., = sheet2!a1) but when I changed the other cells on sheet 2, they did not update. Yes, it is set to auto calculation.Originally, it was auot except tables, but i changed it, clicked save, closed EXCEL, and reopened and it did not help. I even reboooted the computer. If I go into the formula and edit it, that will fix it. If I save the file with a new name, or even do a file save as and use the same name, it updates. But if I merely hit the save icon in EXCEL, it stil does not update, even if I shut down my computer and re-open, it still has the old value. The file does have a long name, although so do the new files that I save it as, and thye are then fine, and react to further changes. I even ran detect and repair. Does anyone have a better answer than my file must be corrupt. It seems that simply saving the file as a new name fixes this corruption, but who can be sure it doesn't exist somewhere else? I set it to manual, then back to automatic, but that didn't help either. In the past, closing EXCEL or even rebooting has made these kinds of problems go away, but not this time. Thanks Dean I've seen something like this in a workbook in which I was using UDFs. Changing a cell on one of the "feeder" sheets didn't update the result sheet properly. After trying to figure out what the problem was I settled for a work-around. In the result sheet code page: Private Sub Worksheet_Activate() ActiveSheet.UsedRange.Columns("P:P").Calculate End Sub HTH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 Can I stop the 'update links' option when file is opened? | Links and Linking in Excel | |||
Automatic Chart update Excel File 2003 | Excel Programming | |||
after saving excel 2003 file, functions do not update anymore | Excel Discussion (Misc queries) | |||
Linked cells don't automatically update in Excel 2003. Why? | Excel Worksheet Functions | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming |