Misc Excel Copy Question

[Edward]

My question is stupid but simple:

I have two spreadsheets, spreadsheet A & B, I tried to copy the most
simplest formula from A to B, and i expect the formula is retained in
B, e.g., in cell A1of A : =(1)+(2), then copy to B, it's still
=(1)+(2), very simple right?

The problem is it suddenly not working in one of my office computers,
yes, only one, then weird thing is, when I try the copy function
above, the cell in B only have the value inside, i.e., 3, but not the
formula =(1)+(2), (seems like paste by values, but what I did is only
Ctrl+c and Ctrl+v), when i try to use paste by values, I was promoted
that I need to insert a object something. very strange.

Just would like to know if this related to settings something?

Thanks in advance.

 

[Bill>M]

I have a question, why are you using the same cell for data entry as the
cell for your formula or do I not understand your question?
A good practice is to use cell (A) for your formulas then hide row (A) to
protect your sheet formulas..
use row (B) for data entry and color code row (B) font using conditional
formatting and place your answer in row (D) and use conditional formatting
for Answers..
Hopefully this will help you protect your formulas..

 

[Edward]

I am not asking methods to protect my formula. thanks.

just I try to copy one formular from one spreadsheet to another, but
didn't work, only values is retained. but I use simple copy & paste
which should retain the formula. It only happened to one of my
computers, other computers are okay! I suspect it's a settings problem
but can't figure out why. That's my problem.

 

[Bill>M]

my mistake, what happens if you use paste special

 

[Edward]

a box prompted out saying that "paste special"
Source : Microsoft Office Excel Worksheet Object.

one news! very strange, I try to help my colleague to diagnosis the
problem in my computer, now my behaviour is exactly the same!! I
really supsect it's somehow a settings problem.

 

[Edward]

I found out the solution finally, it's because the first file is open
as "Read Only". How could you imagine this makes a difference?

 

[Dave Peterson]

I don't think so.

I think it's because you opened each workbook in separate instances of excel.

Close one of those instances of excel and use File|Open to open the second file.

Then try your Copy|paste.