Copy formulas across workbook [Solved/Closed]

AKK - Jun 21, 2011 at 05:43 AM - Latest reply:  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

See more 

9 replies

Best answer
20
Thank you
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.

Thank you, Nick S 20

Something to say? Add comment

CCM has helped 1810 users this month

TrowaD 2433 Posts Sunday September 12, 2010Registration dateContributorStatus September 17, 2018 Last seen - Jun 21, 2011 at 09:30 AM
4
Thank you
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
TrowaD 2433 Posts Sunday September 12, 2010Registration dateContributorStatus September 17, 2018 Last seen - 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
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.
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - 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 :)
TrowaD 2433 Posts Sunday September 12, 2010Registration dateContributorStatus September 17, 2018 Last seen - 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
jwicksy 1 Posts Thursday April 30, 2015Registration date April 30, 2015 Last seen - Apr 30, 2015 at 10:39 AM
There is a way around all of this.

If you select the cells you would like to copy, click on the formula tab and select show formula, you can then copy the text in to word.

You can then copy the text straight out of word in to excel and it will input the text as formulas.

I hope this helps, it took me far too long to work this out!
-3
Thank you
An even simpler way is to select "paste special" from the right click menu, then "keep source formatting (k)"