Forum Discussion

426_hemi's avatar
426_hemi
Copper Contributor
Feb 26, 2024

Excel column showing with #ADR

Hello,

 

I have an issue on a user's computer where the same Excel file works fine on mine but on the user's side it shows with "ADR! instead of the actual text. The Office version is the same as on my laptop and I can see the text. Tried reinstalling Office, same thing happens if I login Windows with my username on that PC. The Windows OS was alredy reinstalled on it. Any help/ideas would be appreciated. Thanks

excel

6 Replies

Sort By
    • 426_hemi's avatar
      426_hemi
      Copper Contributor
      Feb 26, 2024
      =@IF(@INDIRECT("Characteristics!r"&(ROW(B16)-13)&"C5",FALSE)="","",INDIRECT("Characteristics!r"&(ROW(B16)-13)&"C5",FALSE))
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Feb 26, 2024

        426_hemi I've never seen the #ADR! error code in Excel, and Google doesn't give me any leads either. Perhaps I'm looking in the wrong places. Initially, I get a #REF! error.

         

        Beware that the use of INDIRECT with the FALSE argument in the end creates R1C1-style references. Be sure to change the relevant setting if you want to work with R1C1-style references. When I did that I no longer got the #REF! error.

         

         

         

Resources