How do I fix #VALUE! errors

When you open an application, you may find your self stuck with #VALUE! errors

This is due to Excel opening any files in protected view and preventing formulas to work correctly.

You can fix this by simply clicking on the  button.