| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 54735 | 2005-02-20 22:51:00 | "XL" Query | B.M. (505) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 326923 | 2005-02-20 22:51:00 | How do I copy only a formula from one workbook to another without any references to the workbook it’s copied from? I thought paste special, formula only, would do it but unfortunately it drags with it references to the workbook it’s copied from. :help: |
B.M. (505) | ||
| 326924 | 2005-02-20 23:19:00 | If the formula has cell specific references in it (absolute references) then it will take them with it. If not, only the formula should transfer. Can you post a typical formula that is not transferring? |
godfather (25) | ||
| 326925 | 2005-02-20 23:51:00 | That’s what I thought too GF. However, The first formula becomes the second formula even though it’s a Special Pasted, Formula Only! Unfortunately, this is quite a small one and there are others much larger, which I don’t feel like typing individually. It’s the workbook name [Meeting-TeRapa-5-2-05.xls] that’s causing my distress. =IF(IMPORT!AD6="","",IF(IMPORT!AD6="X","X",IF(IMPORT!AD6=0,10,IMPORT!AD6)) =IF('[Meeting-TeRapa-5-2-05.xls]IMPORT'!AD6="","",IF('[Meeting-TeRapa-5-2-05.xls]IMPORT'!AD6="X","X",IF('[Meeting-TeRapa-5-2-05.xls]IMPORT'!AD6=0,10,'[Meeting-TeRapa-5-2-05.xls]IMPORT'!AD6))) |
B.M. (505) | ||
| 326926 | 2005-02-21 00:05:00 | Use paste special, formula from the right click menu. | wotz (335) | ||
| 326927 | 2005-02-21 00:11:00 | But the formula is wholly dependent on the spreadsheet that is linked in the IMPORT! function. So it will embed the whole name, it would appear that it has no choice. What did you expect it to transfer I wonder, as there is a hard link established? |
godfather (25) | ||
| 326928 | 2005-02-21 00:14:00 | Just select the formula from inside the cell and copy it that way. | Steven (7085) | ||
| 326929 | 2005-02-21 00:31:00 | Just to clarify things GF . “Import” is not being used as a function . It is the name of a “worksheet” within a “workbook” . Badly named possibly, but it is really just Sheet1 where one can paste values for the other sheets to do the calculating on . I’ve got a gut feeling I might have to hold down Shift / Ctrl / Alt or something . Can’t find anything in Help either . Don’t seem to be able to Copy and Paste from within a cell either . |
B.M. (505) | ||
| 326930 | 2005-02-21 00:37:00 | To select inside a cell and copy first click the cell then select the information inside the cell by selected it using the formula bar and then select copy. | Steven (7085) | ||
| 326931 | 2005-02-21 00:58:00 | Sorry Steven, I've tried that but it doesn't work . I still get referenced to the workbook I copied from . |
B.M. (505) | ||
| 326932 | 2005-02-21 01:11:00 | Perhaps you could paste a very small sample of what is causing the problem including some sample data. I am unable to replicate your problem using the method I have described. | Steven (7085) | ||
| 1 2 | |||||