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 sheet - Break Links to Old Workbook - Retain Formula.
Hi,
I have two identical spreadsheets, except one has an additional sheet, with links to cells and ranges within the sheets in that workbook. I've populated the sheets within the workbook without the additional sheet (don't ask why!), now find I need that sheet. However, when I copy it across, it retains its links to the referenced sheets within its own workbook. How can I copy this sheet across to the other workbook, have it retain its references (formulas), but within the new workbook? I.E. I want it pointing to the same cells/ranges, but from the new workbook, not the one from which it has just been copied. Hope this make sense? All help appreciated. Thanks. |
#2
|
|||
|
|||
Copy sheet - Break Links to Old Workbook - Retain Formula.
I change my formulas to text, copy the sheet, then change my text formulas back
to formulas. Select all the cells on the sheet edit|replace what: = (equal sign) with: $$$$$= replace all now do the copy then change them back Select all the cells on the sheet edit|replace what: $$$$$= with: = (equal sign) replace all Don't forget to fix the original worksheet, too. Mr Anonymouse wrote: Hi, I have two identical spreadsheets, except one has an additional sheet, with links to cells and ranges within the sheets in that workbook. I've populated the sheets within the workbook without the additional sheet (don't ask why!), now find I need that sheet. However, when I copy it across, it retains its links to the referenced sheets within its own workbook. How can I copy this sheet across to the other workbook, have it retain its references (formulas), but within the new workbook? I.E. I want it pointing to the same cells/ranges, but from the new workbook, not the one from which it has just been copied. Hope this make sense? All help appreciated. Thanks. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to reference external refereces from a list | FalconArt | Worksheet Functions | 7 | August 22nd, 2005 05:17 PM |
Does excel recognise names rather than cells? | Sue | Worksheet Functions | 9 | May 22nd, 2005 04:51 AM |
Excel won't copy outside sheet | Jack Sons | General Discussion | 6 | May 17th, 2005 10:05 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Sheet Names | Joseph M. Yonek | Worksheet Functions | 6 | January 3rd, 2004 02:15 AM |