0

Excel Office 365 shows #Name in columns

Robert Pürzer

October 19, 2018 07:36

Answered

Follow

Hello,

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.    

 

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis October 19, 2018 14:05

  Hello Robert -

  It sounds as though your CEO does not have Jet Reports installed (thus, when he opens the file and Excel attempts to recalculate the sheets, Excel cannot find the Jet functions, and any formulas or functions that rely on those Jet functions are not able to be calculated).

  You can set up your reports so that they can be viewed by non-Jet users.

  In a nutshell:  be sure to set cell A1 to Auto+Hide+Values, run the report, save it while it is in Report mode, and then make it available to others.

• 0
  
  Robert Pürzer October 22, 2018 13:18

  Hello Harry,

  thank you very much. This is the clue. 

  I missed to add the "+Values" in the Cell A1.