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
 
It should copy the formula from one workbook to another.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
If it's not calculating correctly, make sure you're in autocalculation mode
(tools|Options|calculation tab).

If that's not the problem, you may want to post the troublesome formula and how
you're copy|pasting it.
 

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
Offset, Match Questiond 5
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Need a formula to act as a value 1
same formula and cells for different worksheets 1
Copy formula 6
About references 1
Excel Help to copy information from one row at a time to another sheet 1

Back
Top