Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Names and Links question
I am having a series of recurring problems, so I think I need to read
something and I hope someone can point me to a good resource. I have made a macro that copies various "template" sheets from one workbook to another. I have a bunch of "presentation" sheets that are nicely formatted and "data" sheets that have all of the calculations. The "presentation" sheets refer to cells and names in the data sheets. And the data sheets refer to a named range that exists in the new workbook. All of the copying works just fine, but I am having problems with both links and names. Sometimes, but I can't figure out when, the copied presentation sheet refers not to the copied data sheet, but to the old data sheet in the presentation workbook. And sometimes, but I don't see the pattern, the data sheets do not refer to the named range in the new workbook, but refer to some (non-existent) named range on the sheet itself. When I hand delete that name, the sheet works, but when I programmatically delete it the whole process gets messed up. I am asking for a solution to this problem (which is probably not well enough described, but I did the best I can), what I would like is something that gives me a solid understanding of how Excel handles these things, when links and names update, when they don't, how it works, etc. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A VERY General question | Excel Worksheet Functions | |||
General Question | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
General purpose "open links" macro | Links and Linking in Excel | |||
General question | Excel Programming |