Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
save worksheet as another file, but have all defined names copied
i made this workbook, which has all the data in different worksheets, at the
same time, this is where i made the worksheet for all other works next time, this happened to be somewhat like my template... then what i did was i copied over the template worksheet into another workbook (to make that my main template workbook), but then only the defined names for that certain worksheet was copied over i think, so what i did was that i manually copied all the other defined names into the template worksheet of the template workbook.... but turns out that when the name ranges in the original data workbook has changed, the ones in the template workbook remain the same... how do i make them update or change with the data workbook? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User defined file name on save | Excel Discussion (Misc queries) | |||
can I save a file of multiple names to replace using excell 03 | Excel Discussion (Misc queries) | |||
Duplicate names on copied worksheet | Links and Linking in Excel | |||
I can't save long file names, only short one, how can I do this? | Excel Discussion (Misc queries) | |||
HOW TO SAVE FILE NAMES IN COLOUR OR DIFFERENT FONTS | Excel Worksheet Functions |