Copy formulas across workbook

Solved/Closed
AKK - Jun 21, 2011 at 05:43 AM
 1234551 - Jul 8, 2015 at 01:50 PM
Hello,

I want to copy Excel 2007 formulas from one workbook and past to the other workbook without the workbook name in the pasted formulas. Can this be done? Anyone knows, please help.

Thanks

Related:

3 replies

Alternatively, just paste it in with the links and do a find replace. Paste the link information into find, and replace with "". Replace all. Worked good for me.
22
TrowaD
Posts
2900
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 12, 2022
523
Jun 21, 2011 at 09:30 AM
Hi AKK,

Excel needs to know which workbook it needs to retrieve information from.

If the information from the source workbook doesn't change, you can copy/paste special the formula as value in the same cell.

Hope this helps.

Best regards,
Trowa
4
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Jun 22, 2011 at 05:23 PM
Are you sure Trowa ?
i just create two workbooks (did not save them) In one wb I had formula =A2
i copied that cell and pasted on the other book and there too it showed up as =A2. I did not get any ref to book or sheet. Obviously I am missing some steps here. Question is which ones
0
TrowaD
Posts
2900
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 12, 2022
523
Jun 23, 2011 at 09:24 AM
Guess I interpreted the question a different way.

I thought he wanted to link the data between workbooks.

After reading his post again I think you are right.

If he wants to just copy the formula between workbooks, he needs to copy the formula from the formula bar instead of copying the cell.

After testing I noticed that saving or not saving the workbook makes the difference. When you don't save, Excel doesn't know from which workbook the formula came from, so the workbook reference is left out.

Laters,
Trowa
0
Dear All,
Thanks for your help. I have tried as suggested by copying formular from the formular box and paste to another workbook. It's giving me what I want i.e. no workbook name is pasted with the formular. Thanks a lot.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Jun 23, 2011 at 12:00 PM
Thanks for the info Trowa about behaviour shift between saved and unsaved book. Ah the wonders of Excel and Microsoft products. Cannot live with them, cannot live without them :)
0
TrowaD
Posts
2900
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 12, 2022
523
Jun 24, 2011 at 09:34 AM
You have helped me so much that I'm glad I can finally give some knowledge back.

See you around,
Trowa
0
An even simpler way is to select "paste special" from the right click menu, then "keep source formatting (k)"
-3