After years of happily copying Excel formulae and/or results, I now
have a problem.
I'm copying from a worksheet saved in Excel 97. I'm working in Excel
2003. I open the saved worksheet and copy a cell such as:

=VARPA(B3:AB3)

When I paste it into a new worksheet (created in Excel 2003) the value
is pasted and not the formula.

Can anyone help me copy the formula?

Steve

wrote in news:1123715732.078417.170900
@g43g2000cwa.googlegroups.com:

After years of happily copying Excel formulae and/or results, I now
have a problem.
I'm copying from a worksheet saved in Excel 97. I'm working in Excel
2003. I open the saved worksheet and copy a cell such as:

=VARPA(B3:AB3)

When I paste it into a new worksheet (created in Excel 2003) the value
is pasted and not the formula.

Can anyone help me copy the formula?

Steve



What does the Number Format property show for that cell?

And if you hit F2 and Enter on that cell?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

Both cells show Number format. hit F2 and Enter and nothing happens!

Steve

wrote in news:1123716547.158387.4890
@z14g2000cwz.googlegroups.com:

Both cells show Number format. hit F2 and Enter and nothing happens!

Steve



Do you see the same contents in the cell and in the Formula Bar above?
No apostrophe or something else in front of it?

Does the cell accept the same formula if you input it yourself?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

Do you have two instances of excel running?

Open the first workbook (any way you want)
then File|open the second.

Then try your copy|paste.

And if this doesn't apply, do you have any rows that are hidden and are copying
discontiguous rows?

wrote:

After years of happily copying Excel formulae and/or results, I now
have a problem.
I'm copying from a worksheet saved in Excel 97. I'm working in Excel
2003. I open the saved worksheet and copy a cell such as:

=VARPA(B3:AB3)

When I paste it into a new worksheet (created in Excel 2003) the value
is pasted and not the formula.

Can anyone help me copy the formula?

Steve

--

Dave Peterson

Steve
Did you use paste special ??
and select all or formulas
HTH
Michael Mitchelson


" wrote:

After years of happily copying Excel formulae and/or results, I now
have a problem.
I'm copying from a worksheet saved in Excel 97. I'm working in Excel
2003. I open the saved worksheet and copy a cell such as:

=VARPA(B3:AB3)

When I paste it into a new worksheet (created in Excel 2003) the value
is pasted and not the formula.

Can anyone help me copy the formula?

Steve

Dave,

That's the answer. I had two (or more) instances of Excel running.
I'm sure I must have made the same mistake in the past without noticing
this strange behaviour.#

Thanks,

Steve