An issue regarding the formula

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
 
D

Dave Peterson

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
Copying Formulas 2
incorrect output of if formula 6
locking part of look up formula 2
copying a formula 1
copy and paste 4
Odd Formula copying Behavior 3
Copy Exact Formula 1

Top