Hi, I have recently converted a large excel file with a lot of macros to work in excel 2016. I have many worksheets, all of which are protected and the VB Project is also Protected. The main problem, when trying to make the conversion, was that excel 2016 (and 2010) did not recognise the MS Calendar reference and I could not enable the macros. So, I removed the Calendar ref in a e pc with excel version 2003 and then copied by usb to the other laptop that has excel 2016.
In the new laptop with excel 2016 the file opens, but it only opens in protective view. Searching through the net I found that: "File validation failure - When you see a message in Protected View that says "Office has detected a problem with this file. Editing it may harm your computer. Click for more details.", the file didn’t pass file validation. File validation scans file for security problems that can result from changes in the file structure."
The problem is that I need to send the file to various users who will open it in excel 2016, so they should not open it in protective view and then have to press the button so as to open anyway.
Why is my file opening in protected view? What could be wrong and causes this to happen?
Also, some older version of the file have been red flagged by defender, and I get the message: threat detected Trojan:O97m/Foretype.A!ml .But it is the same file, only with half finished code. I don't know why the defender identifies it as having a trojan.
Maybe this is the reason that the finished file opens in protective view?
Have you ever encountered this? Is there a way to fix it?
Your thoughts and ideas would be most apprecieted!!!
In the new laptop with excel 2016 the file opens, but it only opens in protective view. Searching through the net I found that: "File validation failure - When you see a message in Protected View that says "Office has detected a problem with this file. Editing it may harm your computer. Click for more details.", the file didn’t pass file validation. File validation scans file for security problems that can result from changes in the file structure."
The problem is that I need to send the file to various users who will open it in excel 2016, so they should not open it in protective view and then have to press the button so as to open anyway.
Why is my file opening in protected view? What could be wrong and causes this to happen?
Also, some older version of the file have been red flagged by defender, and I get the message: threat detected Trojan:O97m/Foretype.A!ml .But it is the same file, only with half finished code. I don't know why the defender identifies it as having a trojan.
Maybe this is the reason that the finished file opens in protective view?
Have you ever encountered this? Is there a way to fix it?
Your thoughts and ideas would be most apprecieted!!!
