So just a few questions.
- You just do ctrl-c on the old cell and ctrl-v on the new cell?
- Does it work correctly in all NEW workbooks and incorrectly in (some) OLD ones? Or isn't it as simple as that?
- If you try Edit>Paste Special and choose 'formulas' or 'all', does it work?
I had a problem today with Excel 2003(Win XP)not copying formulas. When I copied and pasted, I would get the results of the formula as it/they existed in the original cell(s) rather than the formula(s). I reloaded Excel at one point and that seemed to clear things up, but when I loaded a second workbook it repeated the non-copying behavior for the second....when I closed out of the second workbook, it behaved properly with the first workbook???
Does anyone have any idea what is going on? The Excel program has been on the computer for a long time..perhaps it's corrupted in some fashion?