excel 2016 add ins not loading on startup

Preview the repaired files and click Save File to save the files at desired location.

Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.

Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.

This can be beneficial to other community members reading this thread. Please remember to click 'Mark as Answer' the responses that resolved your issue, and to click 'Unmark as Answer' if not. If you do fail to find any clue, I would suggest you simple your project as far as possible and then share the project so we could use it to try to reproduce your issue. Its function part by part to check if specific function cause the issue. I would suggest you create a new add-in to rebuild the add-in part by part or back up the add-in and removed I think the issue should be related to your design in the current add-in. Second, since you could not replicate the scenario using a simple add-in. You could try to repair your office or try to test the add-in on other PC with Excel 2013/2016. I would suggest you continue to some work to narrow down your issue.įirst of all, I would suggest check if it is related to Excel corrupt. I think it is still hard to troubleshot your issue based on current information. Is there any alternative solution to achieve the same thing without having to display the custom message box? What could be the possible reason that the 'MessageBox.Show()' statement is pushing the thread to move forward and show the password pop-ups as expected?ģ.

(As per your suggestion, we did try commenting out entire code in the add-in Startup event but it did not work!)Ģ. What could be the possible reason that the thread is not able to show the Password prompt, which is obviously expected for a password protected excel. What this indicates is, MessageBox.Show() helped the current thread to continue to pump messages and do the required synchronization.ġ. Though this has solved our problem, this is not acceptable solution as it involves an extra pop-up. Show('Demo Excel Add-in loaded successfully'). Its just that now we have two pop-up windows, 1 custom pop-up and other one password prompt. The issue here is : the password prompt window is not getting visible and the splash screen goes on forever.Īs of now, strangely, I have found out a workaround where just inserting a MessageBox.Show() statement, helps to make both the message box and the password window pop up.īelow is the simple one line which I added at the end of ThisAddIn_Startup() and it worked as expected. You are correct, even I was not able to replicate the scenario with simple VSTO template of Excel Add-Ins 20.

Excel 2016 add ins not loading on startup