Plotting Problems

[Guest]

Hello,
I have a user with Excel 2002 on an NT 4.0 system. He's having problems
copying equations into certain cells. Instead of listing the equation, the
source location is pasted in (=A5). He has General selected under
Format-Cells-Numbers. Any ideas what could be the problem? Thanks in
advance,

 

[Guest]

Not sure this will help, but I'd try EDIT>COPY while in the cell and then to
see what is going on, EDIT>PASTE SPECIAL and see if it defaulting to
something other than ALL, FORMULAS or VALUES.

I'd also check FILE>PROPERTIES to see if it is read-only. If the sheet were
protected it shouldn't allow any kind of copying at all.

 

[Guest]

Hi Pete,
Thanks for the follow up. Here's some more info. from the user having the
problem. Hope this makes things a little clearer:

It defaults to all.
The problem is not copy. It is the "=" sign. For example, if I type "=A5" in
c5 cell, it will appear "=A5" in c5 cell.
Some other cells, it recognized the "=" sign for equation, but some were
not. All the cells are General type.