Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object Library invalid or contains references to object defintions
Hi Guys,
"Object Library invalid or contains references to object defintions that could not be found" A little background. This is a file i distribute to many people. Most are not having any problems, so far only two users. I've checked Tools References and all are ticked as should be (Or at least the same as i have). No reference are "MISSING" I read somewhere that it could be something to do with missing Add-ins but C:\ are locked down here so i cant check. Its not the file but Excel (Or at least i've deduced that from the fact that 30 + users have no problem) Running XL2002 SR3. I'm stumped completely on this one. Any thoughts/suggestions would be welcomed. Thanks John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object Library invalid or contains references to object defintions
Two things to check
1) On the worksheet the Addins are the same on all PC's and are properly checked. 2) The reference may be shown on the VBA Reference menu but the library may not be selected. Even though it may look correct, For some reason when the libraries are modified the reference doesn't get updated. This often happens with the refedit library. Whon office gets updated the folder where the refedit is located gets moved from office 10 or office 11 to office 11 or oficew 12. Refedit stops working and you have to browse for the library. You may have similar problems. "John" wrote: Hi Guys, "Object Library invalid or contains references to object defintions that could not be found" A little background. This is a file i distribute to many people. Most are not having any problems, so far only two users. I've checked Tools References and all are ticked as should be (Or at least the same as i have). No reference are "MISSING" I read somewhere that it could be something to do with missing Add-ins but C:\ are locked down here so i cant check. Its not the file but Excel (Or at least i've deduced that from the fact that 30 + users have no problem) Running XL2002 SR3. I'm stumped completely on this one. Any thoughts/suggestions would be welcomed. Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please Help on Object Library Invalid or contains.... | Excel Programming | |||
object library or invalid reference | Excel Programming | |||
Object library Invalid | Excel Programming | |||
Object library Invalid | Excel Programming | |||
object library invalid | Excel Programming |