We have an issue trying to open files with Analytics for Office functions in the last version of Excel. When the people with that version open the file then it shows #NAME in all the cells related with the Add-in (obviously they have everything installed and working). In fact it works only when they refresh it using the button.
Users with older versions don't have the problem.
NOTE: Everybody is using Analytics for Office 2.6