| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace all formulas in one worksheet to link to different worksh
I want all formulas (in sheet 1 of Workbook 2006) that link to workbook #1 to
now link to same cells in workbook #2. Any suggestions on how to make that happen without individually changing each cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace all formulas in one worksheet to link to different worksh
From the menu go to Edit --- Links...
In the Edit Links pop up box, click Change Source... button and select another file. -Simon "Relacing all formulas" wrote: I want all formulas (in sheet 1 of Workbook 2006) that link to workbook #1 to now link to same cells in workbook #2. Any suggestions on how to make that happen without individually changing each cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace all formulas in one worksheet to link to different worksh
Edit|replace|replace all?
Relacing all formulas wrote: I want all formulas (in sheet 1 of Workbook 2006) that link to workbook #1 to now link to same cells in workbook #2. Any suggestions on how to make that happen without individually changing each cell? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| how to reference external refereces from a list | Excel Worksheet Functions | |||
| How can I link a cell in one worksheet to a cell in another works. | Excel Worksheet Functions | |||
| copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
Linear Mode
