Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
75
Invalid cell reference in cell value on a cell with linked reference to another workbook
posted

I am getting an invalid reference when getting cell value on a cell with a linked reference to another workbook.   At runtime we will not know if the user has a spreadsheet with linked cells.  Is there any way around this?  Are linked cells supported? 

This is the value of the cell when it is a linked cell.   {#REF!}

  • 12773
    posted

    Hello David,

    I checked for referencing cells behavior , and it seems we are not supporting loading and retrieving values at this time form other excel file.
    Anyway you should be able to get the content of the cell, and not the {#REF!} as a value.  We are working to solve the issue with {#REF!} , but you need to retrieve the value of the self by yourself.  

    I hope this is helpful.
     
    Sincerely,
    Dimi
    Developer Support Engineer
    Infragistics, Inc.