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.
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.
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 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.
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.
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 :)