Prev: Ad-In Rowliner
Next: consolidating data for a report - HELP - pivot tables no good for
From: Shirley on 14 Apr 2010 08:43
Cannot get this to stay at automatic. Any thoughts why?

New workbook, nothing complicated (b2/b3). I save the document, reopen and
set to recalculate. The next day when I open, it's back to manual.

I hate when things weird out.


From: Fred Smith on 14 Apr 2010 09:50
The recalculation setting comes from the first workbook you open. Do you
have another workbook that has its setting to manual?

Regards,
Fred

"Shirley" <Shirley(a)discussions.microsoft.com> wrote in message
news:6FE5E667-2461-4E2D-9BE7-DDED889B2336(a)microsoft.com...
> Cannot get this to stay at automatic. Any thoughts why?
>
> New workbook, nothing complicated (b2/b3). I save the document, reopen
> and
> set to recalculate. The next day when I open, it's back to manual.
>
> I hate when things weird out.
>
>

From: Bernard Liengme on 14 Apr 2010 11:58
As a follow on to Fred's answer - do you have workbooks in the XLSTART
folder?
These will open every time you start Excel and could be hidden
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"Shirley" <Shirley(a)discussions.microsoft.com> wrote in message
news:6FE5E667-2461-4E2D-9BE7-DDED889B2336(a)microsoft.com...
> Cannot get this to stay at automatic. Any thoughts why?
>
> New workbook, nothing complicated (b2/b3). I save the document, reopen
> and
> set to recalculate. The next day when I open, it's back to manual.
>
> I hate when things weird out.
>
>
 | 
Pages: 1
Prev: Ad-In Rowliner
Next: consolidating data for a report - HELP - pivot tables no good for