Automatic cell population
 

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?

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?

Automatic cell population
 

I've tried this and it doesn't work. I also closed and reopened the workbook.

"Ron de Bruin" wrote:

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?

Automatic cell population
 

ok wait...it's working now. That is wierd because I tried this before and it
didn't work and now that I attempted again it seems to work now. The most
confusing part is that it was already defaulted to automatic.

Thank you!

"Ron de Bruin" wrote:

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?