An issue regarding the formula

  • Thread starter Thread starter HuaMin
  • Start date Start date
H

HuaMin

Hi,
It's OK to copy the formula from one cell to another one within the
same sheet. How about that to copy the formula from one Excel file to
another one? It seems only the value of that cell will be copied to
that file but not the formula inside it. I even have tried to copy the
corr. formula within that again but just the copied formula will not
work successfully in there.

Thks & Rgds,
HuaMin
 
You have other replies at your other thread.

But a couple of questions...

Are both workbooks open in the same instance of excel (do you see both names
under the Window option on the worksheet menu bar?)

If you don't, then close one, and open it using File|open in that first
instance.

Are you copying from a filtered list?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An issue regarding the formula 2
Hidden cells 2
Copying Formulas 2
Copy Exact Formula 1
Copying Formula Issue 3
Copy/Paste formulas in merged cells 2
Excel Help to copy information from one row at a time to another sheet 1
CountIf formula problem when referencing a column. 4

Back
Top