Question: Formulas not pasting properly

[Knut]

I'm working in Excel 2007, and am having difficulty pasting formulas. For some reason, when I paste a formula into an adjacent cell, it returns the value of the cell that was copied. OK, so that may sound like I pasted values... but when I click in the formula in the pasted cell, it has updated correctly. And if I hit enter, the correct value is then computed and displayed.

As a result, I can't paste formulas and get the correct result unless I go into the formula in each pasted cell individually and hit enter. Weird. Anybody else experience this, or know how it can be corrected?

Thanks!!

[Richard Buttrey]

I'm working in Excel 2007, and am having difficulty pasting formulas. For some reason, when I paste a formula into an adjacent cell, it returns the value of the cell that was copied. OK, so that may sound like I pasted values... but when I click in the formula in the pasted cell, it has updated correctly. And if I hit enter, the correct value is then computed and displayed.

As a result, I can't paste formulas and get the correct result unless I go into the formula in each pasted cell individually and hit enter. Weird. Anybody else experience this, or know how it can be corrected?

Thanks!!

Hi,

Sounds very much like you're in Manual Calculation mode. This sometimes happens if you open another workbook which someone else has set to Manual. Your Excel Application will retain this parameter until you change it.

I think it's Tools Preferences and the Calculation Tab in Windows, but I use a Mac and it's slightly different.

HTH

[Knut]

That worked! Thanks, hexaflexagon!