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
|
|||
|
|||
How do I copy a worksheet without the link to the original workboo
I need to copy a worksheet that links to cells in another worksheet in the
workbook. This worksheet will be copied to 300 different excel files which all have the same format but different data in the cells. Therefore, the worksheet that is copied to the a specific workbook must link to the workbook it is copied to and not the workbook it is copied from. How can this be done with the least amount of effort? (Excel 2000) |
#2
|
|||
|
|||
I'd convert the formulas to text, copy|paste and convert the text back to
formulas. In the original worksheet select the range to copy (the whole worksheet) edit|replace what: = (equal sign) with: $$$$$= replace all Copy the worksheet to the new workbook Then change them back: Select the pasted range edit|replace what: $$$$$= with: = replace all Alternatively, you could just copy the worksheet and let the formulas link back to the original workbook--then use Edit|links|change source. Reliabengr wrote: I need to copy a worksheet that links to cells in another worksheet in the workbook. This worksheet will be copied to 300 different excel files which all have the same format but different data in the cells. Therefore, the worksheet that is copied to the a specific workbook must link to the workbook it is copied to and not the workbook it is copied from. How can this be done with the least amount of effort? (Excel 2000) -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy tabs(sheets) from workbook without link to original source | Rich Ulichny | Links and Linking | 2 | August 9th, 2005 03:26 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Copy cells to another worksheet | Denise | General Discussion | 3 | April 22nd, 2005 08:06 PM |
Copy from worksheet to another x times | Union70 | General Discussion | 0 | March 7th, 2005 09:03 PM |
How do I copy a cell (content AND format) from one worksheet to a. | Excel Format Copy | Worksheet Functions | 1 | February 9th, 2005 10:34 PM |