| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy tabs(sheets) from workbook without link to original source
I want to be able to copy tabs from workbook to workbook. However, when I
right-click..'choose Move or Copy' and copy the tab into a new workbook, the formula now contains the original source file name. For example, a simple calc, contained on Sheet2 of my source (book1.xls): =+Sheet1!A1+Sheet1!A2 becomes =+[book1.xls]Sheet1!A1+[book.xls]Sheet1!A2 when it's pasted into a new workbook. I do not want to original link contained in the new workbook. How can I copy the worksheet without having that orignal source file name in the formula? Thanks, Rich |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| How can I Copy cell names from one workbook to another? | Excel Discussion (Misc queries) | |||
| Link to password protected workbook | Excel Discussion (Misc queries) | |||
| copy a sheet in same workbook temporary block excel | Excel Worksheet Functions | |||
| What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
Threaded Mode
