Forum Discussion

Sridhar_M's avatar
Sridhar_M
Contributor
2 years ago

Excel XFGetCell refresh is not working and data cells showing #NAME?

Hi All,  We are using XFGetCell's all the time in excel and one of the user reinstalled MS Office recently and he started facing issues XFGetCell. Please see screenshot below.  XFGetCell function i...
Reports
Sridhar_M's avatar
Sridhar_M
Contributor

Thank you JackLacava. 
I'll open a ticket with support. Installation looks okay but I'll keep this post updated when I find resolution from OneStream.  

JShoemaker's avatar
JShoemaker
New Contributor III
2 years ago

Hi Sridhar, did support get back with you on this? We are getting the same thing at a client. They are on a shared drive so like Jack suggested I believe thats it but curious on if they told you a solution?

  • Sridhar_M's avatar
    Sridhar_M
    Contributor
    2 years ago

    Hi JShoemaker 

    No solution from support, but I figured the user is using some other Add-Ins which I think it is conflicting with OneStream Add-In. So, I tried below steps and it worked. 

    1. I disabled all Add-Ins that user has installed except OneStream
    2. Restarted excel
    3. Opened his XFGetCell excel file, connected to OneStream and refresh worked successfully
    4. Enabled back all the Add-Ins that we disabled in the step 1
    5. Restarted excel
    6. Retried refreshing OneStream files and it was successful and other add-ins also working with out issue. 

    Regards

    Sridhar