I'm running Excel XP, and all of a sudden my workbook uses manual calc. I
go Tools --> options --> calculations and set it to Automatic. Next time I
open the workbook, its back to Manual
What am I doing wrong ???


Thanks
John

Calculation mode is set by the first workbook opened after a start up of Excel.

All subsequently opened workbooks will also take that mode.

1. Are you saving the workbook with auto-calc enabled?

2. Are you opening another workbook first?


Gord Dibben MS Excel MVP

On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net> wrote:

>I'm running Excel XP, and all of a sudden my workbook uses manual calc. I
>go Tools --> options --> calculations and set it to Automatic. Next time I
>open the workbook, its back to Manual
>What am I doing wrong ???
>
>
>Thanks
>John
>

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Calculation mode is set by the first workbook opened after a start up of
> Excel.
>
> All subsequently opened workbooks will also take that mode.
>
> 1. Are you saving the workbook with auto-calc enabled?

YUP !
>
> 2. Are you opening another workbook first?
>
NOPE


>
> Gord Dibben MS Excel MVP
>
> On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net> wrote:
>
>>I'm running Excel XP, and all of a sudden my workbook uses manual calc. I
>>go Tools --> options --> calculations and set it to Automatic. Next time
>>I
>>open the workbook, its back to Manual
>>What am I doing wrong ???
>>
>>
>>Thanks
>>John
>>
>

Do you use personal.xls?

For most users, it opens as a hidden file.

You may want to open excel
use windows|Unhide to unhide that personal.xls window
change the calculation setting to automatic
use windows|Hide to hide personal.xls window
close excel and answer yes to the "want to save" prompt.



JohnR wrote:
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:(E-Mail Removed)...
> > Calculation mode is set by the first workbook opened after a start up of
> > Excel.
> >
> > All subsequently opened workbooks will also take that mode.
> >
> > 1. Are you saving the workbook with auto-calc enabled?
>
> YUP !
> >
> > 2. Are you opening another workbook first?
> >
> NOPE
>
> >
> > Gord Dibben MS Excel MVP
> >
> > On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net> wrote:
> >
> >>I'm running Excel XP, and all of a sudden my workbook uses manual calc. I
> >>go Tools --> options --> calculations and set it to Automatic. Next time
> >>I
> >>open the workbook, its back to Manual
> >>What am I doing wrong ???
> >>
> >>
> >>Thanks
> >>John
> >>
> >

--

Dave Peterson

Dave

I experimented with this many times.

On my setup, Personal.xls when opening hidden does not set the calc mode for the
next workbook opened.

If I open it unhidden it does set the calc mode.


Gord

On Sat, 16 Jun 2007 06:46:32 -0500, Dave Peterson <(E-Mail Removed)>
wrote:

>Do you use personal.xls?
>
>For most users, it opens as a hidden file.
>
>You may want to open excel
>use windows|Unhide to unhide that personal.xls window
>change the calculation setting to automatic
>use windows|Hide to hide personal.xls window
>close excel and answer yes to the "want to save" prompt.
>
>
>
>JohnR wrote:
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:(E-Mail Removed)...
>> > Calculation mode is set by the first workbook opened after a start up of
>> > Excel.
>> >
>> > All subsequently opened workbooks will also take that mode.
>> >
>> > 1. Are you saving the workbook with auto-calc enabled?
>>
>> YUP !
>> >
>> > 2. Are you opening another workbook first?
>> >
>> NOPE
>>
>> >
>> > Gord Dibben MS Excel MVP
>> >
>> > On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net> wrote:
>> >
>> >>I'm running Excel XP, and all of a sudden my workbook uses manual calc. I
>> >>go Tools --> options --> calculations and set it to Automatic. Next time
>> >>I
>> >>open the workbook, its back to Manual
>> >>What am I doing wrong ???
>> >>
>> >>
>> >>Thanks
>> >>John
>> >>
>> >

That solved it. THANK YOU !




"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Do you use personal.xls?
>
> For most users, it opens as a hidden file.
>
> You may want to open excel
> use windows|Unhide to unhide that personal.xls window
> change the calculation setting to automatic
> use windows|Hide to hide personal.xls window
> close excel and answer yes to the "want to save" prompt.
>
>
>
> JohnR wrote:
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:(E-Mail Removed)...
>> > Calculation mode is set by the first workbook opened after a start up
>> > of
>> > Excel.
>> >
>> > All subsequently opened workbooks will also take that mode.
>> >
>> > 1. Are you saving the workbook with auto-calc enabled?
>>
>> YUP !
>> >
>> > 2. Are you opening another workbook first?
>> >
>> NOPE
>>
>> >
>> > Gord Dibben MS Excel MVP
>> >
>> > On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net> wrote:
>> >
>> >>I'm running Excel XP, and all of a sudden my workbook uses manual calc.
>> >>I
>> >>go Tools --> options --> calculations and set it to Automatic. Next
>> >>time
>> >>I
>> >>open the workbook, its back to Manual
>> >>What am I doing wrong ???
>> >>
>> >>
>> >>Thanks
>> >>John
>> >>
>> >
>
> --
>
> Dave Peterson

I remember experimenting a while ago, and I thought that it did affect the calc
mode. But I could be wrong--I use a personal.xla file.

I wonder if the OP had his personal.xls hidden or visible?


Gord Dibben wrote:
>
> Dave
>
> I experimented with this many times.
>
> On my setup, Personal.xls when opening hidden does not set the calc mode for the
> next workbook opened.
>
> If I open it unhidden it does set the calc mode.
>
> Gord
>
> On Sat, 16 Jun 2007 06:46:32 -0500, Dave Peterson <(E-Mail Removed)>
> wrote:
>
> >Do you use personal.xls?
> >
> >For most users, it opens as a hidden file.
> >
> >You may want to open excel
> >use windows|Unhide to unhide that personal.xls window
> >change the calculation setting to automatic
> >use windows|Hide to hide personal.xls window
> >close excel and answer yes to the "want to save" prompt.
> >
> >
> >
> >JohnR wrote:
> >>
> >> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> >> news:(E-Mail Removed)...
> >> > Calculation mode is set by the first workbook opened after a start up of
> >> > Excel.
> >> >
> >> > All subsequently opened workbooks will also take that mode.
> >> >
> >> > 1. Are you saving the workbook with auto-calc enabled?
> >>
> >> YUP !
> >> >
> >> > 2. Are you opening another workbook first?
> >> >
> >> NOPE
> >>
> >> >
> >> > Gord Dibben MS Excel MVP
> >> >
> >> > On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net> wrote:
> >> >
> >> >>I'm running Excel XP, and all of a sudden my workbook uses manual calc. I
> >> >>go Tools --> options --> calculations and set it to Automatic. Next time
> >> >>I
> >> >>open the workbook, its back to Manual
> >> >>What am I doing wrong ???
> >> >>
> >> >>
> >> >>Thanks
> >> >>John
> >> >>
> >> >

--

Dave Peterson

Was your personal.xls file hidden or visible?

JohnR wrote:
>
> That solved it. THANK YOU !
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Do you use personal.xls?
> >
> > For most users, it opens as a hidden file.
> >
> > You may want to open excel
> > use windows|Unhide to unhide that personal.xls window
> > change the calculation setting to automatic
> > use windows|Hide to hide personal.xls window
> > close excel and answer yes to the "want to save" prompt.
> >
> >
> >
> > JohnR wrote:
> >>
> >> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> >> news:(E-Mail Removed)...
> >> > Calculation mode is set by the first workbook opened after a start up
> >> > of
> >> > Excel.
> >> >
> >> > All subsequently opened workbooks will also take that mode.
> >> >
> >> > 1. Are you saving the workbook with auto-calc enabled?
> >>
> >> YUP !
> >> >
> >> > 2. Are you opening another workbook first?
> >> >
> >> NOPE
> >>
> >> >
> >> > Gord Dibben MS Excel MVP
> >> >
> >> > On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net> wrote:
> >> >
> >> >>I'm running Excel XP, and all of a sudden my workbook uses manual calc.
> >> >>I
> >> >>go Tools --> options --> calculations and set it to Automatic. Next
> >> >>time
> >> >>I
> >> >>open the workbook, its back to Manual
> >> >>What am I doing wrong ???
> >> >>
> >> >>
> >> >>Thanks
> >> >>John
> >> >>
> >> >
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

Visible !




"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Was your personal.xls file hidden or visible?
>
> JohnR wrote:
>>
>> That solved it. THANK YOU !
>>
>> "Dave Peterson" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Do you use personal.xls?
>> >
>> > For most users, it opens as a hidden file.
>> >
>> > You may want to open excel
>> > use windows|Unhide to unhide that personal.xls window
>> > change the calculation setting to automatic
>> > use windows|Hide to hide personal.xls window
>> > close excel and answer yes to the "want to save" prompt.
>> >
>> >
>> >
>> > JohnR wrote:
>> >>
>> >> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> >> news:(E-Mail Removed)...
>> >> > Calculation mode is set by the first workbook opened after a start
>> >> > up
>> >> > of
>> >> > Excel.
>> >> >
>> >> > All subsequently opened workbooks will also take that mode.
>> >> >
>> >> > 1. Are you saving the workbook with auto-calc enabled?
>> >>
>> >> YUP !
>> >> >
>> >> > 2. Are you opening another workbook first?
>> >> >
>> >> NOPE
>> >>
>> >> >
>> >> > Gord Dibben MS Excel MVP
>> >> >
>> >> > On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net>
>> >> > wrote:
>> >> >
>> >> >>I'm running Excel XP, and all of a sudden my workbook uses manual
>> >> >>calc.
>> >> >>I
>> >> >>go Tools --> options --> calculations and set it to Automatic. Next
>> >> >>time
>> >> >>I
>> >> >>open the workbook, its back to Manual
>> >> >>What am I doing wrong ???
>> >> >>
>> >> >>
>> >> >>Thanks
>> >> >>John
>> >> >>
>> >> >
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson

Thanks for posting back.

JohnR wrote:
>
> Visible !
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Was your personal.xls file hidden or visible?
> >
> > JohnR wrote:
> >>
> >> That solved it. THANK YOU !
> >>
> >> "Dave Peterson" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > Do you use personal.xls?
> >> >
> >> > For most users, it opens as a hidden file.
> >> >
> >> > You may want to open excel
> >> > use windows|Unhide to unhide that personal.xls window
> >> > change the calculation setting to automatic
> >> > use windows|Hide to hide personal.xls window
> >> > close excel and answer yes to the "want to save" prompt.
> >> >
> >> >
> >> >
> >> > JohnR wrote:
> >> >>
> >> >> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> >> >> news:(E-Mail Removed)...
> >> >> > Calculation mode is set by the first workbook opened after a start
> >> >> > up
> >> >> > of
> >> >> > Excel.
> >> >> >
> >> >> > All subsequently opened workbooks will also take that mode.
> >> >> >
> >> >> > 1. Are you saving the workbook with auto-calc enabled?
> >> >>
> >> >> YUP !
> >> >> >
> >> >> > 2. Are you opening another workbook first?
> >> >> >
> >> >> NOPE
> >> >>
> >> >> >
> >> >> > Gord Dibben MS Excel MVP
> >> >> >
> >> >> > On Fri, 15 Jun 2007 22:13:49 -0400, "JohnR" <onejmATcomcast.net>
> >> >> > wrote:
> >> >> >
> >> >> >>I'm running Excel XP, and all of a sudden my workbook uses manual
> >> >> >>calc.
> >> >> >>I
> >> >> >>go Tools --> options --> calculations and set it to Automatic. Next
> >> >> >>time
> >> >> >>I
> >> >> >>open the workbook, its back to Manual
> >> >> >>What am I doing wrong ???
> >> >> >>
> >> >> >>
> >> >> >>Thanks
> >> >> >>John
> >> >> >>
> >> >> >
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson