I'm looking for some help on, what to me is a strange error. I have created this workbook utilizing a sumproduct array on the Summary page. The formula works perfectly on my workbook but if I send it to a coworker all of the formulas on the Summary page come back with a value error. I have created the workbook in 2013 version and my coworker is opening it in 2016. There are no external data references, all of the data is contained within this workbook on different tabs. I'm in North America and my coworker is in Europe, I doubt this makes any difference though.
Here's where is gets weird. If my coworker sends me back the copy that they saved, the error is present. If I double click on any of the errors on the Summary page and then simply press enter the error goes away. If I go to column F on the Update Engagement tab and either double click on any date, or just click on the filter for column F and then Okay, the error goes away. One thing I do notice is that if I double click on the date in column F it eliminates the leading zero. If my coworker tries any of these steps the error does not resolve.
I'm sure it's probably something simple but it has me stumped. Thank you in advance for taking the time to look at this.