Data validation issue

Occasional Visitor

Hi! Is anyone else having this issue, or maybe experienced it in the past...

When I open my excel files which are downloaded via drop box, it comes up with an error message ' We found a problem some content' It asks if I would like to recover as much as possible. If I hit yes, it removes my data validation options from my spreadsheet and I have to reinstall them every time I open the workbook.

Any ideas please? This was working perfectly fine for 2 years, and now all of a sudden isn't!

I have tried copying all the info into a new work book, it still happens. 

I have tried moving the list onto the same worksheet, still happens.

Thank you 

1 Reply

I'd start with Protected View settings. Try toggling off protected view for internet files.
More details: https://support.microsoft.com/en-us/topic/what-is-protected-view-d6f09ac7-e6b9-4495-8e43-2bbcdbcb665...

 

If the error persists beyond adjusted protected view settings, there's a possibility it's a registry error. I've seen plenty of these errors and will go for the reg key when the simple troubleshooting steps don't resolve the issue.