best way to referencing and updating cells
 

I am creating a teacher planner with two different formats (top down and
then, side-by-side) that each need identical event information on any given
day. For example, both need to reflect faculty meeting on the 7th and an
assembly on the 23rd. I only want to type the info once, and then let it
update on the other worksheet.

I don't think I've been doing it the best way because it's not updating.

This is what I am doing to try and get worksheet 2 to reference to worksheet
1 info. Worheet 1 is complete with information.

1. in worksheet 2 , say A3, type =
2. go to worksheet 1 and click B5, then press enter.
3. the info shows up in worksheet 2, cell A3 (with a little green triangle)

This is fine - so far. However, when I change something in worksheet 1, it
does not update worksheet 2. Could you please enlighten me as to the best way
to do this, or tell me what I'm doing wrong? I followed some info on another
post that sounded familiar in procedure, but alas, this is not working for me.

Thanks for your help. -becky

best way to referencing and updating cells
 

It sound to me as if Calculation is set to Manual try:

Tools Options Calculation and make sure that Automatic calculation is
selected.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
I am creating a teacher planner with two different formats (top down and
then, side-by-side) that each need identical event information on any
given
day. For example, both need to reflect faculty meeting on the 7th and an
assembly on the 23rd. I only want to type the info once, and then let it
update on the other worksheet.

I don't think I've been doing it the best way because it's not updating.

This is what I am doing to try and get worksheet 2 to reference to
worksheet
1 info. Worheet 1 is complete with information.

1. in worksheet 2 , say A3, type =
2. go to worksheet 1 and click B5, then press enter.
3. the info shows up in worksheet 2, cell A3 (with a little green
triangle)

This is fine - so far. However, when I change something in worksheet 1, it
does not update worksheet 2. Could you please enlighten me as to the best
way
to do this, or tell me what I'm doing wrong? I followed some info on
another
post that sounded familiar in procedure, but alas, this is not working for
me.

Thanks for your help. -becky

best way to referencing and updating cells
 

Fabulous! That's what it was. Now I have another tool in my pocket. Thanks
Sandy.

"Sandy Mann" wrote:

It sound to me as if Calculation is set to Manual try:

Tools Options Calculation and make sure that Automatic calculation is
selected.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
I am creating a teacher planner with two different formats (top down and
then, side-by-side) that each need identical event information on any
given
day. For example, both need to reflect faculty meeting on the 7th and an
assembly on the 23rd. I only want to type the info once, and then let it
update on the other worksheet.

I don't think I've been doing it the best way because it's not updating.

This is what I am doing to try and get worksheet 2 to reference to
worksheet
1 info. Worheet 1 is complete with information.

1. in worksheet 2 , say A3, type =
2. go to worksheet 1 and click B5, then press enter.
3. the info shows up in worksheet 2, cell A3 (with a little green
triangle)

This is fine - so far. However, when I change something in worksheet 1, it
does not update worksheet 2. Could you please enlighten me as to the best
way
to do this, or tell me what I'm doing wrong? I followed some info on
another
post that sounded familiar in procedure, but alas, this is not working for
me.

Thanks for your help. -becky

best way to referencing and updating cells
 

You are very welcome. Excel takes that setting from the first Workbook
opened in that session, all W/B after that are opened as Manual Calculation
unless you reset it.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
Fabulous! That's what it was. Now I have another tool in my pocket. Thanks
Sandy.

"Sandy Mann" wrote:

It sound to me as if Calculation is set to Manual try:

Tools Options Calculation and make sure that Automatic calculation is
selected.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
I am creating a teacher planner with two different formats (top down and
then, side-by-side) that each need identical event information on any
given
day. For example, both need to reflect faculty meeting on the 7th and
an
assembly on the 23rd. I only want to type the info once, and then let
it
update on the other worksheet.

I don't think I've been doing it the best way because it's not
updating.

This is what I am doing to try and get worksheet 2 to reference to
worksheet
1 info. Worheet 1 is complete with information.

1. in worksheet 2 , say A3, type =
2. go to worksheet 1 and click B5, then press enter.
3. the info shows up in worksheet 2, cell A3 (with a little green
triangle)

This is fine - so far. However, when I change something in worksheet 1,
it
does not update worksheet 2. Could you please enlighten me as to the
best
way
to do this, or tell me what I'm doing wrong? I followed some info on
another
post that sounded familiar in procedure, but alas, this is not working
for
me.

Thanks for your help. -becky

best way to referencing and updating cells
 

I thought the Calculation setting was an Application setting. While you can
change it in workbook code, I don't believe it's something that's
specifically a workbook setting. I can change it from one workbook to the
next within my code.

Someone please correct me if I'm wrong.

Barb Reinhardt



"Sandy Mann" wrote:

You are very welcome. Excel takes that setting from the first Workbook
opened in that session, all W/B after that are opened as Manual Calculation
unless you reset it.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
Fabulous! That's what it was. Now I have another tool in my pocket. Thanks
Sandy.

"Sandy Mann" wrote:

It sound to me as if Calculation is set to Manual try:

Tools Options Calculation and make sure that Automatic calculation is
selected.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
I am creating a teacher planner with two different formats (top down and
then, side-by-side) that each need identical event information on any
given
day. For example, both need to reflect faculty meeting on the 7th and
an
assembly on the 23rd. I only want to type the info once, and then let
it
update on the other worksheet.

I don't think I've been doing it the best way because it's not
updating.

This is what I am doing to try and get worksheet 2 to reference to
worksheet
1 info. Worheet 1 is complete with information.

1. in worksheet 2 , say A3, type =
2. go to worksheet 1 and click B5, then press enter.
3. the info shows up in worksheet 2, cell A3 (with a little green
triangle)

This is fine - so far. However, when I change something in worksheet 1,
it
does not update worksheet 2. Could you please enlighten me as to the
best
way
to do this, or tell me what I'm doing wrong? I followed some info on
another
post that sounded familiar in procedure, but alas, this is not working
for
me.

Thanks for your help. -becky

best way to referencing and updating cells
 

Gord Dibben explained it in another post far better than I can:

Start of Gord's post
**********************************************
ToolsOptionsCalculation. Set to "Automatic.

ToolsOptionsCalculation can be Auto or Manual.

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g


Gord Dibben MS Excel MVP
************************************************
end of Gord's post

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Barb Reinhardt" wrote in message
...
I thought the Calculation setting was an Application setting. While you
can
change it in workbook code, I don't believe it's something that's
specifically a workbook setting. I can change it from one workbook to the
next within my code.

Someone please correct me if I'm wrong.

Barb Reinhardt



"Sandy Mann" wrote:

You are very welcome. Excel takes that setting from the first Workbook
opened in that session, all W/B after that are opened as Manual
Calculation
unless you reset it.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
Fabulous! That's what it was. Now I have another tool in my pocket.
Thanks
Sandy.

"Sandy Mann" wrote:

It sound to me as if Calculation is set to Manual try:

Tools Options Calculation and make sure that Automatic calculation
is
selected.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
I am creating a teacher planner with two different formats (top down
and
then, side-by-side) that each need identical event information on
any
given
day. For example, both need to reflect faculty meeting on the 7th
and
an
assembly on the 23rd. I only want to type the info once, and then
let
it
update on the other worksheet.

I don't think I've been doing it the best way because it's not
updating.

This is what I am doing to try and get worksheet 2 to reference to
worksheet
1 info. Worheet 1 is complete with information.

1. in worksheet 2 , say A3, type =
2. go to worksheet 1 and click B5, then press enter.
3. the info shows up in worksheet 2, cell A3 (with a little green
triangle)

This is fine - so far. However, when I change something in worksheet
1,
it
does not update worksheet 2. Could you please enlighten me as to the
best
way
to do this, or tell me what I'm doing wrong? I followed some info on
another
post that sounded familiar in procedure, but alas, this is not
working
for
me.

Thanks for your help. -becky

best way to referencing and updating cells
 

Calculation is an application setting, but it's a strange one.

Excel picks up this setting from the first workbook it opens in the session.

Barb Reinhardt wrote:

I thought the Calculation setting was an Application setting. While you can
change it in workbook code, I don't believe it's something that's
specifically a workbook setting. I can change it from one workbook to the
next within my code.

Someone please correct me if I'm wrong.

Barb Reinhardt

"Sandy Mann" wrote:

You are very welcome. Excel takes that setting from the first Workbook
opened in that session, all W/B after that are opened as Manual Calculation
unless you reset it.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
Fabulous! That's what it was. Now I have another tool in my pocket. Thanks
Sandy.

"Sandy Mann" wrote:

It sound to me as if Calculation is set to Manual try:

Tools Options Calculation and make sure that Automatic calculation is
selected.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"becder" wrote in message
...
I am creating a teacher planner with two different formats (top down and
then, side-by-side) that each need identical event information on any
given
day. For example, both need to reflect faculty meeting on the 7th and
an
assembly on the 23rd. I only want to type the info once, and then let
it
update on the other worksheet.

I don't think I've been doing it the best way because it's not
updating.

This is what I am doing to try and get worksheet 2 to reference to
worksheet
1 info. Worheet 1 is complete with information.

1. in worksheet 2 , say A3, type =
2. go to worksheet 1 and click B5, then press enter.
3. the info shows up in worksheet 2, cell A3 (with a little green
triangle)

This is fine - so far. However, when I change something in worksheet 1,
it
does not update worksheet 2. Could you please enlighten me as to the
best
way
to do this, or tell me what I'm doing wrong? I followed some info on
another
post that sounded familiar in procedure, but alas, this is not working
for
me.

Thanks for your help. -becky










--

Dave Peterson