# Copy formulas across workbook

Solved/Closed
Related:

- Copy formula from one workbook to another without workbook reference
- Number to words in excel formula without vba - Guide
- Transfer data from one excel worksheet to another automatically formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide

## 3 responses

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.

TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552

Jun 21, 2011 at 09:30 AM

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

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

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Jun 22, 2011 at 05:23 PM

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

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

TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552

Jun 23, 2011 at 09:24 AM

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

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

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Jun 23, 2011 at 12:00 PM

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
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552

Jun 24, 2011 at 09:34 AM

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

See you around,

Trowa