#REF! error when the report is open in higher Excel version

[Former Member]

Hello experts,

I am experiences an issue with just one user in the company that uses a newer version of excel. I have created I workbook which is a combination of EPM functionality and also pure Excel references. Once the report was completed every in the finance department was able to open and run the report with no issues except for one user who runs a higher version of Excel (2013). This person is able to get data accordingly from the EPM portion of the Workbook, but all the cells that reference back to the EMP data intersections keep throwing a #REF! error.

Has anyone experience this issue before or is there anything I can do to fix this? Thanks in advance.

[former_member186338]

Sorry, but if you want help you have to do some work yourself!

First please narrow down the issue - create very simple report where you can reproduce the issue.

Then post screenshots with comments.

And also provide EPM SP

[kaus19d]

Hi,

Try with the Macro disabled. Also check the columns.

How to correct a #REF! error - Office Support

https://support.microsoft.com/en-in/kb/925893

So it seems you are stuck regarding to the OS matter only.

Take OS-Support

Thanks,

Kaushik