If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
#2
|
|||
|
|||
If you want the formula to refer to the new workbook's Sheet1 then use
Edit / Links / Change Source after copying the sheet in. If you want to move Sheet1 and Sheet2 together to the new book, select both sheets (Ctrl+Click the sheet tab of the second one) before using Edit / Move or Copy sheet. If you just want the values of the formula in the new workbook and not the formula then, having copied the sheet use Select the cells concerned, Edit / Copy; Edit / Paste Special / Values Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Thanks for the suggestions. Option 1 below was exactly what I needed. It
allowed me to change the source to the new workbook that I copied the sheet into. I didn't realize you could change the source to itself and that would remove the references to the original workbook. "Bill Manville" wrote in message ... If you want the formula to refer to the new workbook's Sheet1 then use Edit / Links / Change Source after copying the sheet in. If you want to move Sheet1 and Sheet2 together to the new book, select both sheets (Ctrl+Click the sheet tab of the second one) before using Edit / Move or Copy sheet. If you just want the values of the formula in the new workbook and not the formula then, having copied the sheet use Select the cells concerned, Edit / Copy; Edit / Paste Special / Values Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy data from one workbook to another? | Lovelock, David | General Discussion | 1 | June 3rd, 2005 08:25 PM |
Copy data from one workbook to another workbook | Dizzy Des | New Users | 1 | May 26th, 2005 09:35 PM |
Cell range copy to second workbook | GerryK | Worksheet Functions | 2 | March 25th, 2004 05:23 PM |
Workbook becomes hidden after link to webpage | Simon Hobbs | Links and Linking | 9 | January 23rd, 2004 02:21 AM |
Cannot link workbooks by selecting 2nd workbook cell | pkley | Worksheet Functions | 1 | December 28th, 2003 05:04 AM |