Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
atpvbaen link
I feel like I figured this out when I last saw it about 2 years ago, but
can't recall the answer: When I open my workbook today, I get an update links query. When I go to edit links it says the problem is atpvbaen.xla. I seem to recall this is some sort of add in, but it shouldn't appear to be a link, I don't think. What is causing this and how do I remove it? It seems like it's caused by a new worksheet that has eomonth functions which are an add-in. However, I already used this same function in other old sheets and didn't have the problem (at least not in a couple of years of my memory)!! Thanks! Dean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
atpvbaen link
atpvbaen.xla is the VBA version of the analysis toolpak.
There's another addin (Funcres.xla) that will appear when you check the analysis toolpak (not the VBA item) in Tools|Addins. These are guesses, so they might not work. First, open your workbook with the links to the atpvbaen.xla file. Then go into the VBE. Hit F4 to see the project explorer select your project Then click Tools|References and look for a check mark in front of atpvbaen.xla and uncheck it. Then back to excel and save this workbook and close it and reopen to see if that fixed it. Creating a reference (in the VBE) to atpvbaen.xla means that your code can call all the functions that are in that addin--just like they were built into VBA. But if your code doesn't use these, you don't need the reference. But if your code does use any of these, double check that tools|addins Analysis Pak - VBA is checked. Dean wrote: I feel like I figured this out when I last saw it about 2 years ago, but can't recall the answer: When I open my workbook today, I get an update links query. When I go to edit links it says the problem is atpvbaen.xla. I seem to recall this is some sort of add in, but it shouldn't appear to be a link, I don't think. What is causing this and how do I remove it? It seems like it's caused by a new worksheet that has eomonth functions which are an add-in. However, I already used this same function in other old sheets and didn't have the problem (at least not in a couple of years of my memory)!! Thanks! Dean -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
atpvbaen link
"Dave Peterson" wrote in message ... atpvbaen.xla is the VBA version of the analysis toolpak. There's another addin (Funcres.xla) that will appear when you check the analysis toolpak (not the VBA item) in Tools|Addins. These are guesses, so they might not work. First, open your workbook with the links to the atpvbaen.xla file. Then go into the VBE. Hit F4 to see the project explorer select your project Then click Tools|References and look for a check mark in front of atpvbaen.xla and uncheck it. Then back to excel and save this workbook and close it and reopen to see if that fixed it. Creating a reference (in the VBE) to atpvbaen.xla means that your code can call all the functions that are in that addin--just like they were built into VBA. But if your code doesn't use these, you don't need the reference. But if your code does use any of these, double check that tools|addins Analysis Pak - VBA is checked. Dean wrote: I feel like I figured this out when I last saw it about 2 years ago, but can't recall the answer: When I open my workbook today, I get an update links query. When I go to edit links it says the problem is atpvbaen.xla. I seem to recall this is some sort of add in, but it shouldn't appear to be a link, I don't think. What is causing this and how do I remove it? It seems like it's caused by a new worksheet that has eomonth functions which are an add-in. However, I already used this same function in other old sheets and didn't have the problem (at least not in a couple of years of my memory)!! Thanks! Dean -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
atpvbaen link
The box in VBE was unchecked and I do not use it in my one trivial macro, so
I did not bother to check the box. I notice that, after I choose "don't update links", if I go to Tools Add-Ins, it immediately responds that I can't run add-ins, that I need to install it. When I then answer "don't install", then the add ins box pops up anyway, and the ATP box is checked, consistent with the fact that my eomonth functions do work everywhere (unless I update links, in which case the few new ones turn to nonsense). What I did try is to change the source (under edit links) to a garbage file, so I could see what cells got messed up. And, just as I suspected, it was a few eomonth functions that I had added to a new worksheet that someone else stuck in my file and sent back to me. When I first opened their sent-back file, there was no such problem, adding a few new eomonth functions on their new sheet, resaving, and re-opening caused the problems. I think I read something about switching versions of EXCEL can cause this kind of thing? Strangely, though the equations in these cells showed a link to the new garbage file (after I changed the source to a garbage file), when I hit edit links, it was hushed! Nevertheless, I simply retyped the eomonth equations into the few affected cells and all is fine now. Also, I already had tons of these eomonth functions already working in the workbook - it seems that it was confused only by the new references on a new worksheet that was later added in. Though I am fine now, as an intellectual curiosity, and for possible future reference, does any of this make sense? Thanks! Dean "Dave Peterson" wrote in message ... atpvbaen.xla is the VBA version of the analysis toolpak. There's another addin (Funcres.xla) that will appear when you check the analysis toolpak (not the VBA item) in Tools|Addins. These are guesses, so they might not work. First, open your workbook with the links to the atpvbaen.xla file. Then go into the VBE. Hit F4 to see the project explorer select your project Then click Tools|References and look for a check mark in front of atpvbaen.xla and uncheck it. Then back to excel and save this workbook and close it and reopen to see if that fixed it. Creating a reference (in the VBE) to atpvbaen.xla means that your code can call all the functions that are in that addin--just like they were built into VBA. But if your code doesn't use these, you don't need the reference. But if your code does use any of these, double check that tools|addins Analysis Pak - VBA is checked. Dean wrote: I feel like I figured this out when I last saw it about 2 years ago, but can't recall the answer: When I open my workbook today, I get an update links query. When I go to edit links it says the problem is atpvbaen.xla. I seem to recall this is some sort of add in, but it shouldn't appear to be a link, I don't think. What is causing this and how do I remove it? It seems like it's caused by a new worksheet that has eomonth functions which are an add-in. However, I already used this same function in other old sheets and didn't have the problem (at least not in a couple of years of my memory)!! Thanks! Dean -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
atpvbaen link
I've never had any trouble upgrading different versions of excel (97 to 2002 to
2003). But if I recall correctly, I've always loaded those addins before starting excel (and checking that tools|addins option). I don't understand why atpvbaen.xla would be sticking its head in any of this, though. Dean wrote: The box in VBE was unchecked and I do not use it in my one trivial macro, so I did not bother to check the box. I notice that, after I choose "don't update links", if I go to Tools Add-Ins, it immediately responds that I can't run add-ins, that I need to install it. When I then answer "don't install", then the add ins box pops up anyway, and the ATP box is checked, consistent with the fact that my eomonth functions do work everywhere (unless I update links, in which case the few new ones turn to nonsense). What I did try is to change the source (under edit links) to a garbage file, so I could see what cells got messed up. And, just as I suspected, it was a few eomonth functions that I had added to a new worksheet that someone else stuck in my file and sent back to me. When I first opened their sent-back file, there was no such problem, adding a few new eomonth functions on their new sheet, resaving, and re-opening caused the problems. I think I read something about switching versions of EXCEL can cause this kind of thing? Strangely, though the equations in these cells showed a link to the new garbage file (after I changed the source to a garbage file), when I hit edit links, it was hushed! Nevertheless, I simply retyped the eomonth equations into the few affected cells and all is fine now. Also, I already had tons of these eomonth functions already working in the workbook - it seems that it was confused only by the new references on a new worksheet that was later added in. Though I am fine now, as an intellectual curiosity, and for possible future reference, does any of this make sense? Thanks! Dean "Dave Peterson" wrote in message ... atpvbaen.xla is the VBA version of the analysis toolpak. There's another addin (Funcres.xla) that will appear when you check the analysis toolpak (not the VBA item) in Tools|Addins. These are guesses, so they might not work. First, open your workbook with the links to the atpvbaen.xla file. Then go into the VBE. Hit F4 to see the project explorer select your project Then click Tools|References and look for a check mark in front of atpvbaen.xla and uncheck it. Then back to excel and save this workbook and close it and reopen to see if that fixed it. Creating a reference (in the VBE) to atpvbaen.xla means that your code can call all the functions that are in that addin--just like they were built into VBA. But if your code doesn't use these, you don't need the reference. But if your code does use any of these, double check that tools|addins Analysis Pak - VBA is checked. Dean wrote: I feel like I figured this out when I last saw it about 2 years ago, but can't recall the answer: When I open my workbook today, I get an update links query. When I go to edit links it says the problem is atpvbaen.xla. I seem to recall this is some sort of add in, but it shouldn't appear to be a link, I don't think. What is causing this and how do I remove it? It seems like it's caused by a new worksheet that has eomonth functions which are an add-in. However, I already used this same function in other old sheets and didn't have the problem (at least not in a couple of years of my memory)!! Thanks! Dean -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
atpvbaen link
Oh well, just one of those mysteries of life.
"Dave Peterson" wrote in message ... I've never had any trouble upgrading different versions of excel (97 to 2002 to 2003). But if I recall correctly, I've always loaded those addins before starting excel (and checking that tools|addins option). I don't understand why atpvbaen.xla would be sticking its head in any of this, though. Dean wrote: The box in VBE was unchecked and I do not use it in my one trivial macro, so I did not bother to check the box. I notice that, after I choose "don't update links", if I go to Tools Add-Ins, it immediately responds that I can't run add-ins, that I need to install it. When I then answer "don't install", then the add ins box pops up anyway, and the ATP box is checked, consistent with the fact that my eomonth functions do work everywhere (unless I update links, in which case the few new ones turn to nonsense). What I did try is to change the source (under edit links) to a garbage file, so I could see what cells got messed up. And, just as I suspected, it was a few eomonth functions that I had added to a new worksheet that someone else stuck in my file and sent back to me. When I first opened their sent-back file, there was no such problem, adding a few new eomonth functions on their new sheet, resaving, and re-opening caused the problems. I think I read something about switching versions of EXCEL can cause this kind of thing? Strangely, though the equations in these cells showed a link to the new garbage file (after I changed the source to a garbage file), when I hit edit links, it was hushed! Nevertheless, I simply retyped the eomonth equations into the few affected cells and all is fine now. Also, I already had tons of these eomonth functions already working in the workbook - it seems that it was confused only by the new references on a new worksheet that was later added in. Though I am fine now, as an intellectual curiosity, and for possible future reference, does any of this make sense? Thanks! Dean "Dave Peterson" wrote in message ... atpvbaen.xla is the VBA version of the analysis toolpak. There's another addin (Funcres.xla) that will appear when you check the analysis toolpak (not the VBA item) in Tools|Addins. These are guesses, so they might not work. First, open your workbook with the links to the atpvbaen.xla file. Then go into the VBE. Hit F4 to see the project explorer select your project Then click Tools|References and look for a check mark in front of atpvbaen.xla and uncheck it. Then back to excel and save this workbook and close it and reopen to see if that fixed it. Creating a reference (in the VBE) to atpvbaen.xla means that your code can call all the functions that are in that addin--just like they were built into VBA. But if your code doesn't use these, you don't need the reference. But if your code does use any of these, double check that tools|addins Analysis Pak - VBA is checked. Dean wrote: I feel like I figured this out when I last saw it about 2 years ago, but can't recall the answer: When I open my workbook today, I get an update links query. When I go to edit links it says the problem is atpvbaen.xla. I seem to recall this is some sort of add in, but it shouldn't appear to be a link, I don't think. What is causing this and how do I remove it? It seems like it's caused by a new worksheet that has eomonth functions which are an add-in. However, I already used this same function in other old sheets and didn't have the problem (at least not in a couple of years of my memory)!! Thanks! Dean -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Atpvbaen.xls | Excel Worksheet Functions | |||
ATPVBAEN.xls Not Found | Excel Programming | |||
ATPVBAEN.XLA!Random Arguments | Excel Programming | |||
atpvbaen.xls | Excel Programming | |||
ATPVBAEN XLA [Number casual] | Excel Programming |