|
| 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
October 11th, 2004, 12:19 AM
|
|||
|
|||
Links to workbooks
Several cells within different sheets of a workbook are
linked to cells in other workbooks. How can one readily break these links, but keep the value shown without also eliminating the links and/or formulas that exist among worksheet cells within the same workbook? 
|
|
#2
October 11th, 2004, 01:59 PM
|
|||
|
|||
|
If your data is organized such that entire rows/columns reference the
external data, you can select the row/column, copy/paste special-"Values". wrote: Several cells within different sheets of a workbook are linked to cells in other workbooks. How can one readily break these links, but keep the value shown without also eliminating the links and/or formulas that exist among worksheet cells within the same workbook?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to check why links between two workbooks not working? | rinakwek | General Discussion | 2 | October 2nd, 2004 01:59 AM |
| Opening Workbooks which contain links | ElsiePOA | General Discussion | 7 | June 22nd, 2004 01:57 PM |
| Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Linear Mode
