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
 
B

Bob Phillips

It should copy the formula from one workbook to another.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Dave Peterson

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
Need a formula to act as a value 1
Offset, Match Questiond 5
help with formula 3
COUNTIF + ADDRESS Issue 1
Crafting SUMIF formula 5
Clever formula required (to find the word directly preceding mychosen word) 3
sum 1

Top