Copy formulas across workbook
Solved/Closed
Related:
- Copy formulas from one workbook to another
- Little alchemy formulas - Guide
- Spreadsheet formulas - Guide
- Transfer data from one excel worksheet to another automatically formula - Guide
- Number to words in excel formula - Guide
- Ms excel marksheet formulas pdf - 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
555
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
555
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
555
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
