Calculation is set by the method specified in the FIRST file to open
If you have book.xlt and it is set to automatic then open it first. I have
my excel open to a Menu.xls which does have automatic set by the properties
in a desktop button.

C:\myfolder\MENU.xls
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Amy" wrote in message
...
If I'm opening an existing document, that's true. When I just open Excel,
new
doc, it is defaulted to manual calc mode. I do this a lot because I'm
pasting
data from other programs and then running a macro to create a report.

How can I set it, so that when I open Excel, it opens in automatic calc
mode??

Thanks!


"Don Guillett" wrote:


Calculation is set by the method specified in the FIRST file to open

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rhos" wrote in message
...
Okay. the calculation being set to manual seems to the problem.

But when I change it to automatic, it reverts to manual the next time I
open
Excel! Is there somewhere else that I can change this default setting?

Thanks to all!

Amy

"Mike H" wrote:

Amy,

two thoughts:-

is calculation set to manual?
Tools|Options - Calculation tab and select auto.

Are these cells formatted as text when you enter a formula?
Ensure they are formatted as 'general'

Mike

"Amy" wrote:

On several occasions lately I've had the misfortune of my
spreadsheet
refusing to treat a formula as a formula. Instead it shows me the
formula.
i.e. "=A2+A4" instead of "16". What causes this??? How do I avoid
it?

Also, when the formula does work, I'm having an issue when I drag
the
formula to other cells that it doesn't process unless I manually go
into that
cell and hit enter. The formula reads correctly, but the result is
the
same
that was in the first cell until I click in the cell and hit enter.
(This is
not a relative/absolute reference issue)

If these ring a bell to anyone...please help!!