Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
re named worksheets which were linked to other sheets
Hi
how can I re-name a workbook/sheet that has already been named and linked to another workbook, what happens now is that the main data workbook cant find the link (coz I re-named it) Can the re-naming be updated automatically in the main data sheet after the sourse workbook/sheet has been renamed ? thanks Johnnyboy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
re named worksheets which were linked to other sheets
If sheets within a single workbook are linked and renamed, the linking
formulas update to the new sheet name automatically. If you have links between two workbooks, re-naming the source workbook will cause loss of reference to that workbook. In that case open the destination workbook and EditLinks and change source to re-named source workbook. If only a sheet name has been changed in source workbook the sheet name will be referenced properly in destination workbook so no need to edit links. Gord Dibben MS Excel MVP On Sun, 10 Jan 2010 10:39:28 -0800 (PST), Johnnyboy5 wrote: Hi how can I re-name a workbook/sheet that has already been named and linked to another workbook, what happens now is that the main data workbook cant find the link (coz I re-named it) Can the re-naming be updated automatically in the main data sheet after the sourse workbook/sheet has been renamed ? thanks Johnnyboy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
re named worksheets which were linked to other sheets
On 10 Jan, 19:51, Gord Dibben <gorddibbATshawDOTca wrote:
If sheets within a single workbook are linked and renamed, the linking formulas update to the new sheet name automatically. If you have links between two workbooks, re-naming the source workbook will cause loss of reference to that workbook. In that case open the destination workbook and EditLinks and change source to re-named source workbook. If only a sheet name has been changed in source workbook the sheet name will be referenced properly in destination workbook so no need to edit links. Gord Dibben *MS Excel MVP On Sun, 10 Jan 2010 10:39:28 -0800 (PST), Johnnyboy5 wrote: Hi how can I re-name a workbook/sheet that has already been named and linked to another workbook, what happens now is that the main data workbook cant find the link (coz I re-named it) Can the re-naming be updated automatically in the main data sheet after the sourse workbook/sheet has been renamed ? thanks Johnnyboy thanks will check it out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combo box linked to named range | Excel Programming | |||
Named Box linked to a Name | Excel Discussion (Misc queries) | |||
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible? | Excel Programming | |||
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
How do you point to a named range in linked workbooks? | Excel Discussion (Misc queries) |