View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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!