Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a link in a workbook cell to edit??
I have a cell or cells that have a link to an external file/workbook on my
drive. I have changed the path that it was kept in and I know I have the option to update the data when opening the file but I also want to be able to select a specific cell and adjust VIA a window / wizard rather than trying to type in the new link. Can this be done?? Mike |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a link in a workbook cell to edit??
Hi Mike,
Maybe not exactly what you want, but you can choose Edit, Links and pick the Change Source options. You can also press Ctrl+H and replace the references cell by cell enter the path you are searching for and the new path you want to replace it with and then click Find Next until you have a cell that you want to change and then press Alt+P to replace and continue. You can do them all at one time with Replace all. Cheers, Shane Devenshire Microsoft Excel MVP "MikeR-Oz" wrote in message ... I have a cell or cells that have a link to an external file/workbook on my drive. I have changed the path that it was kept in and I know I have the option to update the data when opening the file but I also want to be able to select a specific cell and adjust VIA a window / wizard rather than trying to type in the new link. Can this be done?? Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I highlight a cell and link it to another workbook? | New Users to Excel | |||
how do i edit link source in whole workbook? | Excel Discussion (Misc queries) | |||
Link to cell in another workbook | Excel Discussion (Misc queries) | |||
Active Cell when opening workbook | Excel Worksheet Functions | |||
Link A Cell In O ne Workbook To A Formula In Another Workbook | Excel Worksheet Functions |