#Error - Invalid Member Name when refreshing reports

[Former Member]

Hi Experts,

I have an issue with one of my reports ,  i have a formula on 4 of my columns and when i run for different regions the report shows blanks members as shown below.#Error - Invalid Member Name: #Not an EPMOlapMember formula. Am i missing any sheet options or user options.

I tried all the possibilities of excel and nothing seems to be working. Please guide me in fixing this.

Regards,
SSK

[Former Member · Accepted solution]

Thanks Dinesh and Vadim .

I had excel formula's which were causing the extra member appearing at the end of the report.

i have replaced them with Local members and it now looks good.

Thanks,SSK

[Shrikant_Jadhav · Accepted solution]

Already suggested in my first comment

[former_member186338]

Please, show the formula producing error!

Vadim

[dinesh_veluru]

Hi SKS,

Is the report dynamic or static?

formula on J, K columns are written using Local members or just an excel formula dragged till some range.

please provide more details.

Thanks,

Dinesh.V

[Shrikant_Jadhav]

Hi,

For formula use local member.

Also un check "Keep Formulas Static that Reference Report Cells" refresh sheet options.

Shrikant 

[Former Member]

Thanks for your reply .

Keep Formulas Static that Reference Report Cells is already unchecked  on my sheet options.

How to get rid of these errors.