I'm working with the Intelligence add-in in Sage 100 2015. Excel 2013.
Working from one computer designing the financial template.
However, when I switch over to the computer that will be the final user and run the template, I get some weird effects.
Most of the cells suddenly become date formatted. I discovered that the NORMAL format template has the default cell format set to date. I can switch it back and that resolves that problem? I'm not sure if that is going to stick yet.
Oddly enough, if I create a new excel spreadsheet from scratch the NORMAL format looks ok.
However, every formula field is returning "Invalid data - out of present range. (Exception from HRESULT: 0x8002000A (DISP_E_OVERFLOW))"
I have verified that all the add-ins are present in excel.
The only possibility I can come up with at the moment is that the computer being used to design the template is using Excel 2010. The end user is using Excel 2013.
Just tried an experiment creating a new template from scratch on the end user's computer and seems to be working ok.
Suggestions?