We have an Excel addin and are starting to see this exception in Excel 2013 when calculating.

Sadly, I don't understand what the error message is trying to tell us:

System.Runtime.InteropServices.COMException (0x800401A8): There is no active Protected View window. at Microsoft.Office.Interop.Excel._Worksheet.Calculate()

We have a mechanism for detecting "Protected View" but note that this is Excel throwing the error - that it can't find such a window.

And in any case, the sheet being calculated is not in Protected View mode.

Sometimes, we get the same error but without the text "There is no active Protected View window".

Admittedly, it seems to be the case that the file being calculated is either downloaded from Sharepoint or a network path - or when downloaded from IE (because it doesn't save the file to disk as other browsers do - another topic perhaps).

Nevertheless, I suspect it's an internal error (ie bug) that doesn't really mean anything because it suddenly appeared and is becoming more and more common, for us, after making its debut around May 2015.

Any ideas?

Kim Lien Travel - Hng du lch gi r vi cc tour trong nc v tour nc ngoi.

http://kimlientravel.com.vn/

http://kimlientravel.com.vn/tour-00/tour-trong-nuoc-56.html

http://kimlientravel.com.vn/tour-00/tour-nuoc-ngoai-55.html

Hi,

Did you develop/code the add-in by yourself? If yes, please post the question to VSTO forum:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=vsto

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Yes it's our own add-in.

I'll post in VSTO, thanks for the suggestion.