JWalker Menu FaceID xla

[Skippy]

I re-organized my files and moved JWalker's faceids.xla to a different location. When I opened Excel, I got a message that the xla could not be found. No problem. I went into the add-ins menu item and re-specified it's location. It loads as a submenu item under Tools. When I leave Excel and open it again, I get the message that the xla can't be found. I checked under Tools and the FaceID submenu has disappeared. Any reason why Excel "loses" the location of the xla?

 

[Zack Barresse]

I wouldn't think so. When you first open Excel, clear out the error message. Go to Tools | Addins, uncheck J-Walk's addin, click Ok. Close Excel, reopen, Tools | Addins, reinstall J-Walk's addin. Close Excel, reopen. Same problem?

 

[Skippy]

That's what I originally tried so decided to post here in case someone could help. Perplexing indeed.

 

[Skippy]

I just noticed something. Even though I had gone through the steps as described by firefytr, when I reopen Excel, the error message is pointing to the old location of the xla (even though I had specified a new location). As a short-term fix, I'll put it back in the old location. But would very interested if someone could explain what is happening.

 

[Zack Barresse]

When you clear out the addin with the bad path, does it give you the prompt that it can no longer be found, asking if you want to clear the addin from the list? This is what you need to see.

 

[Skippy]

When you clear out the addin with the bad path, does it give you the prompt that it can no longer be found, asking if you want to clear the addin from the list? This is what you need to see.

Yes it does and confirms that it can't find the file. Note my last post about the short-term fix.

 

[Zack Barresse]

Try disabling all addins, closing excel, opening excel, enabling only J-Walk's addin. Still get the error after that?

 

[Skippy]

Try disabling all addins, closing excel, opening excel, enabling only J-Walk's addin. Still get the error after that?

That worked! What happened?

 

[Zack Barresse]

Sometimes Excel gets a screw loose and it helps to reset everything. Can't really give any specifics as I'm not too sure myself. Computers do funny things sometimes.

Glad to help!

 

[Skippy]

Computers do funny things sometimes.

Ain't that the truth. Many thanks...