Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why are the cells of my workbook not refreshing?
I have one worksheet linked to another worksheet in the same workbook. It was
working fine for several months. Yesterday I changed the data on one worksheet and the formulas on the worksheet linked to this one didn't refresh. The only way I could get it to work was to hit F2 and then enter. Later, I used a different workbook, and the same problem occurred. Why is this happening, and how can I prevent it from happening in the future? Thanks :) |
#2
|
|||
|
|||
Kurt, sounds like calculation is set to manual, go to tools, options,
calculation and check automatic -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kurt Paradise" wrote in message ... I have one worksheet linked to another worksheet in the same workbook. It was working fine for several months. Yesterday I changed the data on one worksheet and the formulas on the worksheet linked to this one didn't refresh. The only way I could get it to work was to hit F2 and then enter. Later, I used a different workbook, and the same problem occurred. Why is this happening, and how can I prevent it from happening in the future? Thanks :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
Protecting Workbook | Excel Discussion (Misc queries) | |||
Delete contents of unprotected cells in workbook | Excel Worksheet Functions |