Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change linked source Worksheet
Hi all, I am using excel 2007 and I have Sheet1 in Workbook "A" in
which all the cells are linked to another Sheet1 which is in Workbook "B". I want to change the source link of all the cells of Sheet1 Workbook "A" from Sheet1 Workbook "B" to Sheet2 Workbook "A" (which is actually the sheet in same workbook). What is the easiest way to do this task. I tried by going in edit link but there is no option to change source worksheet as it only shows to change source workbook. Please can any friend can help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change linked source Worksheet
Could you select the range you want to change and use
ctrl-h (Home tab|Editing group|Find & Select icon|Replace) And change the stuff you need? K wrote: Hi all, I am using excel 2007 and I have Sheet1 in Workbook "A" in which all the cells are linked to another Sheet1 which is in Workbook "B". I want to change the source link of all the cells of Sheet1 Workbook "A" from Sheet1 Workbook "B" to Sheet2 Workbook "A" (which is actually the sheet in same workbook). What is the easiest way to do this task. I tried by going in edit link but there is no option to change source worksheet as it only shows to change source workbook. Please can any friend can help -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change linked source Worksheet
On Apr 30, 3:33*pm, Dave Peterson wrote:
Could you select the range you want to change and use ctrl-h (Home tab|Editing group|Find & Select icon|Replace) And change the stuff you need? K wrote: Hi all, *I am using excel 2007 and I have Sheet1 in Workbook "A" in which all the cells are linked to another Sheet1 which is in Workbook "B". *I want to change the source link of all the cells of Sheet1 Workbook "A" from Sheet1 Workbook "B" to Sheet2 Workbook "A" (which is actually the sheet in same workbook). *What is the easiest way to do this task. *I tried by going in edit link but there is no option to change source worksheet as it only shows to change source workbook. Please can any friend can help -- Dave Peterson Thanks Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change source of linked database query | Excel Discussion (Misc queries) | |||
How do I change the source worksheet for 100 charts automatically. | Charts and Charting in Excel | |||
Worksheet change event with cell linked to combo box result | Excel Programming | |||
change source worksheet | Excel Discussion (Misc queries) | |||
How to change (Excel) source of all linked objects in a word docu. | Excel Discussion (Misc queries) |