Excel Office 365 shows #Name in columns


our Company changes from Office 2010 to Office 365. Due to that fact some People have a Office 365, some Office 2010. My PC runs a Office 2010. Now I have to update some reports for our CEO. The CEO already runs a Office 365. 

In Office 2010 some columns of the reports show the right results, when you click into the cell. These columns just have "sum"-functions (so for example there a numbers like 0, 100, etc.).  

Other columns of the reports show  the formula, for example countunique, Count, "".

When my CEO opens the worksheets he'll get #Name in the columns with the formulas.

How can I manage that?

Thanks for your help.    



Please sign in to leave a comment.