Limitation to length of Add-In description causes add-in manager to report the add-in file missing.

[gthacker]

Hello,

I encountered the same issue that Simon describes below and could not
find a solution posted anywhere. Here is how I resolved the issue:

Shorten the length of the add-in description. (set in the document's
"comment" property)

It appears that excel (possibly just the add-in manager) does not
support add-in descriptions beyond a certain length (I'm guessing 255
characters - I haven't verified this.) I encountered the issue
described when my description text was 368 characters long.

Reducing the length of the description eliminated this behavior.

Or possibly it was something altogether unrelated, at least the
problem went away

Greg

---------- Forwarded message ----------
From: Simon <[email protected]>
Date: Sep 28 2006, 6:26 pm
Subject: cannot find excel add-in
To: microsoft.public.excel.misc


We have an Excel-add that has been added via Tools|Add-ins and works.

However, when you go back to Tools|Add-ins you get the message

"Cannot findaddin c:\xxxxx.Delete from list?"

If we answer No, add-in continues and we can verify that theXLAdoes
exist.

If we exit Excel and re-start, Excel does not complain about
theXLAbeing
missing, i.e. the registry OPENn is set correctly.

Any ideas why Excel is displaying this message even though the Add-in
filename and path is valid...

 

[gthacker]

A quick Follow-up: It appears that the limitation is the add-in
manager display. It the text cannot be displayed in the space
provided then the described problem occurs. The exact length
supported depends on how the words are broken accross the lines. If a
5th line is required then the inaccurate error is presented to the
user.

Greg