Excel pasting value not formula
Excel pasting value not formula
(OP)
When I <Ctrl-C><ctrl-V) to copy a formula from one file to another file Excel 2007 is suddenly pasting the value instead of the formula. I only expect this operation when I <paste-special>. Did some setting get flipped somewhere that this is the new default?
Thanks,
Z
Thanks,
Z





RE: Excel pasting value not formula
=====================================
(2B)+(2B)' ?
RE: Excel pasting value not formula
Oddly enough, even copying a cell within the worksheet isn't updating the links. If I copy cell C1 (content is '=B1') to cell C2, the result is '=B1' instead of '=B2'. Something is very broken.
RE: Excel pasting value not formula
=====================================
(2B)+(2B)' ?
RE: Excel pasting value not formula
At any rate in 2003, we have lots of control over the method of copy (8 choices), and it's all controllable by that little clipboard icon.
=====================================
(2B)+(2B)' ?
RE: Excel pasting value not formula
RE: Excel pasting value not formula
=====================================
(2B)+(2B)' ?
RE: Excel pasting value not formula
Z
PS I also noticed that when the two spreadsheets are open in separate instances you cannot use the Format Painter to copy info from one to another.
RE: Excel pasting value not formula
RE: Excel pasting value not formula
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel pasting value not formula
Z
RE: Excel pasting value not formula