| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rename linked Tab
I don't think my last post went through, sorry if it did and this is duplicate.
I created a workbook with 5 tabs to track employee vacation. My first tab is named 'Vacation 2007' and is all employees. The 2nd -5th tabs are the same employees but by shift named.... A Shift, B Shift and so on. I just copied info from 'Vacation 2007' and pasted the links in the appropriate shift tab. Now that 2007 is over I need a new one for 2008. Well I already revamped my 2007 version however it will not let me rename the 'Vacation 2007' tab. I assume it's because it is linked but I just figured when I made it that if I changed the names the links would update to whatever I named the tab. Is there a way to rename my master tab without having to completely redo my workbook??? I'd rather leave it named 2007 than make it over again. Thanks for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rename linked Tab
I need clairification. "Tab"? Excel has workbooks. Workbooks have
worksheets. Worksheets have tabs. That is to say a single worksheet has a tab. Are you referring to worksheets as tabs? Tyro "Pixie78" wrote in message ... I don't think my last post went through, sorry if it did and this is duplicate. I created a workbook with 5 tabs to track employee vacation. My first tab is named 'Vacation 2007' and is all employees. The 2nd -5th tabs are the same employees but by shift named.... A Shift, B Shift and so on. I just copied info from 'Vacation 2007' and pasted the links in the appropriate shift tab. Now that 2007 is over I need a new one for 2008. Well I already revamped my 2007 version however it will not let me rename the 'Vacation 2007' tab. I assume it's because it is linked but I just figured when I made it that if I changed the names the links would update to whatever I named the tab. Is there a way to rename my master tab without having to completely redo my workbook??? I'd rather leave it named 2007 than make it over again. Thanks for any help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rename linked Tab
I think you answered your own question.
"Tyro" wrote: I need clairification. "Tab"? Excel has workbooks. Workbooks have worksheets. Worksheets have tabs. That is to say a single worksheet has a tab. Are you referring to worksheets as tabs? Tyro "Pixie78" wrote in message ... I don't think my last post went through, sorry if it did and this is duplicate. I created a workbook with 5 tabs to track employee vacation. My first tab is named 'Vacation 2007' and is all employees. The 2nd -5th tabs are the same employees but by shift named.... A Shift, B Shift and so on. I just copied info from 'Vacation 2007' and pasted the links in the appropriate shift tab. Now that 2007 is over I need a new one for 2008. Well I already revamped my 2007 version however it will not let me rename the 'Vacation 2007' tab. I assume it's because it is linked but I just figured when I made it that if I changed the names the links would update to whatever I named the tab. Is there a way to rename my master tab without having to completely redo my workbook??? I'd rather leave it named 2007 than make it over again. Thanks for any help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rename linked Tab
Your assumption about linked cells preventing a sheet name change is incorrect.
You say "will not let me rename" What is the error message you receive when you try to rename the Vacation 2007 sheet? Is the workbook protected under ToolsProtectionProtect Workbook? If so, that would prevent a name change. Gord Dibben MS Excel MVP On Tue, 8 Jan 2008 13:35:01 -0800, Pixie78 wrote: I don't think my last post went through, sorry if it did and this is duplicate. I created a workbook with 5 tabs to track employee vacation. My first tab is named 'Vacation 2007' and is all employees. The 2nd -5th tabs are the same employees but by shift named.... A Shift, B Shift and so on. I just copied info from 'Vacation 2007' and pasted the links in the appropriate shift tab. Now that 2007 is over I need a new one for 2008. Well I already revamped my 2007 version however it will not let me rename the 'Vacation 2007' tab. I assume it's because it is linked but I just figured when I made it that if I changed the names the links would update to whatever I named the tab. Is there a way to rename my master tab without having to completely redo my workbook??? I'd rather leave it named 2007 than make it over again. Thanks for any help. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rename linked Tab
Nevermind I fixed it.
"Pixie78" wrote: I don't think my last post went through, sorry if it did and this is duplicate. I created a workbook with 5 tabs to track employee vacation. My first tab is named 'Vacation 2007' and is all employees. The 2nd -5th tabs are the same employees but by shift named.... A Shift, B Shift and so on. I just copied info from 'Vacation 2007' and pasted the links in the appropriate shift tab. Now that 2007 is over I need a new one for 2008. Well I already revamped my 2007 version however it will not let me rename the 'Vacation 2007' tab. I assume it's because it is linked but I just figured when I made it that if I changed the names the links would update to whatever I named the tab. Is there a way to rename my master tab without having to completely redo my workbook??? I'd rather leave it named 2007 than make it over again. Thanks for any help. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rename linked Tab
Would you please let us know how you fixed it?
Gord On Tue, 8 Jan 2008 15:08:03 -0800, Pixie78 wrote: Nevermind I fixed it. "Pixie78" wrote: I don't think my last post went through, sorry if it did and this is duplicate. I created a workbook with 5 tabs to track employee vacation. My first tab is named 'Vacation 2007' and is all employees. The 2nd -5th tabs are the same employees but by shift named.... A Shift, B Shift and so on. I just copied info from 'Vacation 2007' and pasted the links in the appropriate shift tab. Now that 2007 is over I need a new one for 2008. Well I already revamped my 2007 version however it will not let me rename the 'Vacation 2007' tab. I assume it's because it is linked but I just figured when I made it that if I changed the names the links would update to whatever I named the tab. Is there a way to rename my master tab without having to completely redo my workbook??? I'd rather leave it named 2007 than make it over again. Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to transpose linked data and keep it linked? | Excel Worksheet Functions | |||
| HOW DO I COPY AND RENAME A WORKBOOK LINKED TO OTHER WORKBOOKS | Excel Discussion (Misc queries) | |||
| Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
| How do you copy and rename linked worksheets? | Excel Discussion (Misc queries) | |||
| In a linked calculation how do I lose the '0' in the linked file? | Excel Worksheet Functions | |||
Linear Mode
