copying cell forumulas between page breaks

[hnking]

I am using excell11.3.3 on a mac computer ox 10.4.8
In a workbook, I am unable to copy a cell with a formula in it into a
cell on the next page of a worksheet. I have followed the
conventional cut and paste techniques to no avail. Please advise.
Thanks. HNK

 

[jpdphd]

I am using excell11.3.3 on a mac computer ox 10.4.8
In a workbook, I am unable to copy a cell with a formula in it into a
cell on the next page of a worksheet. I have followed the
conventional cut and paste techniques to no avail. Please advise.
Thanks. HNK

HNK,

Very strange!

One thing that occurs to me, are you using the sequence:
Copy
Insert > Page Break
Paste

If so, that could be the problem. If you copy a cell with a formula,
then do some other menu command, the copy buffer will be replaced by
the VALUE of the formula rather than the formula itself. When you
paste, you get the value, not the formula.

jpdphd

 

[Bob Greenblatt]

I am using excell11.3.3 on a mac computer ox 10.4.8
In a workbook, I am unable to copy a cell with a formula in it into a
cell on the next page of a worksheet. I have followed the
conventional cut and paste techniques to no avail. Please advise.
Thanks. HNK

Can you provide some more detail? Does the copy work - do you see the moving
marquee on the copied cells? Do you get an error when you try to paste? What
is the error? What happens? What does "unable to copy..." mean?