Excel column showing with #ADR

[426_hemi]

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

[#2]

@426_hemi What formula is in those cells?

[#3]

=@IF(@INDIRECT("Characteristics!r"&(ROW(B16)-13)&"C5",FALSE)="","",INDIRECT("Characteristics!r"&(ROW(B16)-13)&"C5",FALSE))

[#4]

@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.

[#5]

Thanks for the suggestion, I appreciate it. I tried on the user's end with the R1C1 ticked and it's still not working.

[#6]

@426_hemi Well, without a file to play with I cannot help you. Share a link to it via Onedrive, Dropbox or similar.

[#7]

@Riny_van_Eekelen I appreciate your interest, unfortunately since it's company data, I cannot share it. What I did, was to send the issue to the owner of the file and let's see maybe he has some ideas.

Thank you