In Sage 2017 & 2020 the FR View Fails but gives no error.

Below is the update I uninstalled.  It breaks the variance report on newer Windows versions, but not on older versions.

Security Update for Microsoft Excel 2016 (KB4484338) 32-Bit Edition       

https://support.microsoft.com/kb/4484338

This fixed it for us.