Copying and pasting formulas doesn't work!!

Originally Posted by Bill-E-BoB

This is driving me absolutely NUTS! Before I throw my computer out the window, I figured you guys might be able to help me out. I've got a spreadsheet with 4 columns of numbers: met, missed, grand total, and percent met. To get the percent, I've got a formula in there that just says =B2/D2 where B2 is the met column and D2 is the total column. You copy it down the column for all the rows you need a percentage on, and whamm-o, it changes to =B3/D3, =B4/D4, etc. I've been doing it for ages & its always worked just fine.

Today I go to do the same thing, and it won't work! It copies the formulas correctly, changing row by row the way its supposed to...but the value it displays is the value from the first cell. If I double-click in each cell after pasting, it updates with the correct value for that row...but I've got over 25,000 rows this month and there is NO WAY I'm going to manually sit here and double click 25,000 cells just to get a formula to update.

Does anybody know why its doing this and how I can get it to go back to normal before I pull whats left of my hair out?

Hi,

try Tools, Options, calculation, set to Automatic.

hth
---

Originally Posted by Bill-E-BoB

Ahh, that fixed it. Thank you!!!!

I wonder why it reverted to manual, the only system update between today & last friday was daylight savings time...screwy.

This won't have any impact on my macros will it?

Hi,

does you macro set and unset the 'automatic' feature? (usually not)

I think that a mixture of Key depressions (un)sets the 'Calculate' (as CTRL/~ sets show Formula mode etc), but have not been able to prove what I mis-type to achieve it.

hth
---

Originally Posted by Bill-E-BoB

Nope, no changes to the auto feature in my macros...to be honest, I didn't even know it existed before so I never thought to write it into a script. I still can't imagine when I'd ever want it NOT to update cells, but hey...I guess it could happen.

I use enough keyboard commands that its very likely my finger hit some random combination that shut that feature off, hadn't even thought of that. Now I don't have to fear that my computer was possessed. Thanks!

good to see your problem resolved, sorry that I have no real idea as to how it occurs. Thanks for your response.
---