COPY FORMULA FROM ONE WORKBOOK INTO ANOTHER WORKBOOK

E

EARL_IN_MODESTO

HI, I AM HAVING TROUBLE WITH OFFICE XP EXCEL, WHEN I COPY FORMULAS FROM ONE WORKBOOK AND PASTE IT INTO ANOTHER IT INSERTS A LINK TO THE WORKBOOK THAT I COPIED IT FROM INTO THE FORMULA AND ALL I WANT IS THE FORMULA, I HAVE TRIED PASTE SPECIAL OPTIONS AND IT STILL INSERTS THE LINK. AS YOU CAN PROBABLY TELL I HAVEN'T BEEN USING EXCEL FOR VERY LONG I USED LOTUS FOR YEARS BUT I HAD TO GET INTO THE 21ST CENTURY....... THANKS FOR ANY HELP YOU CAN GIVE ME ............ EARL
 
D

Don Guillett

Please re-post without the caps. Hard to read and considered rude in
newsgroups.


--
Don Guillett
SalesAid Software
(e-mail address removed)
"(e-mail address removed)"
HI, I AM HAVING TROUBLE WITH OFFICE XP EXCEL, WHEN I COPY FORMULAS FROM
Click to expand...
ONE WORKBOOK AND PASTE IT INTO ANOTHER IT INSERTS A LINK TO THE WORKBOOK
THAT I COPIED IT FROM INTO THE FORMULA AND ALL I WANT IS THE FORMULA, I HAVE
TRIED PASTE SPECIAL OPTIONS AND IT STILL INSERTS THE LINK. AS YOU CAN
PROBABLY TELL I HAVEN'T BEEN USING EXCEL FOR VERY LONG I USED LOTUS FOR
YEARS BUT I HAD TO GET INTO THE 21ST CENTURY....... THANKS FOR ANY HELP YOU
CAN GIVE ME ............ EARL
 
P

Peo Sjoblom

If you copy just a few formulas copy them from the formula bar, if you copy
a lot,
do an edit>replace, replace the = with a=, copy and paste, then in both
workbooks reverse the replace
and replace a= with =

Finally,please refrain from using all caps, it is considered rude (all caps
= shouting)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"(e-mail address removed)"
HI, I AM HAVING TROUBLE WITH OFFICE XP EXCEL, WHEN I COPY FORMULAS FROM
Click to expand...
ONE WORKBOOK AND PASTE IT INTO ANOTHER IT INSERTS A LINK TO THE WORKBOOK
THAT I COPIED IT FROM INTO THE FORMULA AND ALL I WANT IS THE FORMULA, I HAVE
TRIED PASTE SPECIAL OPTIONS AND IT STILL INSERTS THE LINK. AS YOU CAN
PROBABLY TELL I HAVEN'T BEEN USING EXCEL FOR VERY LONG I USED LOTUS FOR
YEARS BUT I HAD TO GET INTO THE 21ST CENTURY....... THANKS FOR ANY HELP YOU
CAN GIVE ME ............ EARL
 

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

Create a dynamic master file 1
Copy addition formula of non-consecutive horizontal cells 2
Embed the same Excel multiple times 0
Copy and paste slide from one presentation to another presentation gives an error 2
New computer, how do i move outlook 365 ENTIRELY? 0
linking sheets and workbooks 0
Excel paste special error in same workbook 1
VBA to copy from one workbook into another 0

Top