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