| 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 |
| 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
