Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linked cells not working
I am trying to link cells from one worksheet to multiple worksheets.For
example, I am using the formula =sheet1!A26 with a value of 32 this being the cell I want referenced. When i set up the formula in the other worksheets, the 32 is displayed, but when I change the value say to 25, in sheet1 A26, none of the values in the other worksheets change. I tried creating a new workbook and also restoring an old version of my workbook, but I am getting the same results. This workbook has worked properly in the past. Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
linked cells not working
Press F9 to manually force Excel to recalculate.
Also, go to Tools--Options--Calculation and make sure automatic calculation is selected. Dave -- Brevity is the soul of wit. "Brjrsw" wrote: I am trying to link cells from one worksheet to multiple worksheets.For example, I am using the formula =sheet1!A26 with a value of 32 this being the cell I want referenced. When i set up the formula in the other worksheets, the 32 is displayed, but when I change the value say to 25, in sheet1 A26, none of the values in the other worksheets change. I tried creating a new workbook and also restoring an old version of my workbook, but I am getting the same results. This workbook has worked properly in the past. Please help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
linked cells not working
Press F9, it sounds like calculation is set to manual. If this updates the
formula results you can reset the calculation method by clicking TOOLS in the menu, and selecting OPTIONS. In the OPTIONS dialog box click the CALCULATION tab and click the AUTOMATIC option button. -- Kevin Backmann "Brjrsw" wrote: I am trying to link cells from one worksheet to multiple worksheets.For example, I am using the formula =sheet1!A26 with a value of 32 this being the cell I want referenced. When i set up the formula in the other worksheets, the 32 is displayed, but when I change the value say to 25, in sheet1 A26, none of the values in the other worksheets change. I tried creating a new workbook and also restoring an old version of my workbook, but I am getting the same results. This workbook has worked properly in the past. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
Linked cells and text boxes | Excel Discussion (Misc queries) | |||
0 in linked cells when watched | Excel Worksheet Functions | |||
Locking linked cells | Excel Worksheet Functions | |||
Show cells have been read - linked | Excel Discussion (Misc queries) |