Copy Problem

S

steve2

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
 
D

Dodo

[email protected] wrote in @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
Click to expand...

What does the Number Format property show for that cell?

And if you hit F2 and Enter on that cell?
 
D

Dodo

[email protected] wrote in @z14g2000cwz.googlegroups.com:
Both cells show Number format. hit F2 and Enter and nothing happens!

Steve
Click to expand...

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?
 
D

Dave Peterson

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?
 
M

Michael

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

steve2

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
 
Top