Auto Fill problem

[Usagi]

Since yesterday, I can't see the result of Auto Fill until I save the file.
When I drag the fill handle, cells were showing each value as the mouse goes.
But since yesterday, each cell shows same value of the original cell (like
only numbers are copied). The formulas are right ones. I took long time to
try it again and again but same thing happens all the time. I have to save
to see if the value is right. I did disk cleanup but didn't work. How can i
fix this?

 

[Charles Williams]

Sounds like you are in Manual Calculation mode.

Try switching to Automatic (Tools-->Options-->Calculation)

Note that an Excel session only has one calculation mode at any point in
time, rather than a calculation mode for each workbook, and the initial
calculation mode is set from the first workbook opened.


Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[Usagi]

Thank you, Charles!

I have never touched that part so I have no idea why and how the setting had
changed. Strangely, it happend even I changed to Automatic, but much less
frequency.