I try to compare two Excel files in Excel 2016 by using INQUIRE/Compare files ribbon buttons but can't get further then opening. I get a pretty scary message "Retrieving the COM class factory for component with CLSIF {00024500...} failed due to the following error> 80080005 server execution failed...". I tried to google it and the explanation refers to com libraries which doesn't sound like a problem in the file, but rather in software. If i press OK - then I get asked for a password, but there is no password in this file. I ran the same comparison at the other computer with the same software and files - it worked smoothly. Strangely enough - this comparison works for some files but for other files it asks for the password again.
Has anyone seen this problem and knows how to deal with it? Searched internet but couldn't find a solution.
Thanks.
Has anyone seen this problem and knows how to deal with it? Searched internet but couldn't find a solution.
Thanks.
