| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
