Home |
Search |
Today's Posts |
#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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit / Move or copy sheet stopped working in Excel 2003 | Excel Worksheet Functions | |||
copy data in one sheet to multiple sheets in same workbook | Excel Worksheet Functions | |||
How do I break links in a workbook? | Excel Worksheet Functions | |||
Copy sheet to new workbook | Excel Discussion (Misc queries) | |||
How do you copy a sheet (with Formulas) to another Workbook? | Excel Discussion (Misc queries) |