customized menu items of my excel Add-In application
my Excel Add-In application was developed by .net 4.7. I add some menu items into right click menu in order to i can execute that function eg(Refresh Sheet) with VBA code, this works well for past years.
but recently, there is a client report a issue that he can't see those customized menu items of my excel Add-In application,
so when he execute those functions with VBA code, it report error "Invalid procedure call or argument".
it's weird that the related code hasn't change for years and I can't also reproduce this issue.
can someone help check what reason will cause those customized menu items of my excel Add-In application to be disappeared?
Is it an Excel VSTO addin project? If it is, vsto development is currently not supported in the Q&A forums, please ask your question in Visual Studio Tools for Office (VSTO). If I misunderstand your questin,please point out.
our add-In project is not VSTO. our project is a desktop excel Add-In, and it will use ExcelDna.xll. I am not sure if our client issue related to ExcelDna.xll, if it is because he update his excel to the latest version and not compatible with the ExcelDna version we use. since he haven't faced this issue before.
@Julie Shen According to my understanding, you installed
ExcelDna.AddInin your Class Library project's NuGet Package Manager, and there was a error after Nuget package was upgraded without any changes to the project,right?
we haven't upgrade our ExcelDna in our Add-in project for many years, and we can't reproduce this issue.
this issue can only be reproduced by one of our client. I am not sure if this because he upgrade his excel and the latest excel version has some conflict with the old ExcelDna in our project.
Sign in to comment