View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Automatic cell population

Hi MazzyMirsa

Look in ToolsOptionsCalculation
Check Automatic

--
Regards Ron de Bruin
http://www.rondebruin.nl


"MazzyMirsa" wrote in message ...
I have a workbook with several worksheets. One worksheet is used for data
entry. The other worksheets have links to this data entry worksheet. (Ex.
cell A1 in Sheet 1 has "=Sheet2!A1". ) When I enter data into one sheet it
doesn't automatically update the other worksheets. This doesn't seem right.
Can I fix the workbook so that it updates other worksheets automatically?