INDIRECT function excle online not updated

Question

Hi,

I have a problem with the INDIRECT funtion in combination with excel online (in web browser). With the desktop version, everything works fine.

I use the following code to access some data from a specific line of a differen excel sheet "otherSheet.xlsx" where i specify the linenumber in the first column of the corresponding row (here A1)

so in A1 i the linenumber which i want to query of otherSheet.xlsx

=INDIREKT(TEXTVERKETTEN("";WAHR;"'[otherSheet.xlsx]Tablename'!$J$"; WERTZUTEXT(A1)))

as said, this is working fine for the desktop app, but not for the online version. but for the online version, the result is "0".

if i query the field directly e.g. with (A1 would be 20 in that case) "='[otherSheet.xlsx]Tablename'!$J$20",

the field is set correctly for both version (online and desktop)

if i cange then back to my original code, the field is also set corretly (most likely because the value is already cached somewhere). So i think there is a probem with quering indirect links for the online version.

Is there a trick i can do?

thanks for helping.

Flo

Answer 1

Sorry I am actually incorrect here, it is not INDIRECT as such which is causing he issue, but that you are referring a linked sheet using the function which is causing issues on the web version.

Kind Regards,

Elise

Answer 2

Hi,

thanks for the reply.

Are you sure, that the indirect command in not working. Is there any documentation, which commands are compatible with the online version?

Is there any other way to realize this, without the indrect command? (short summary: i just want to specify a number in document A which queries the line of the given number from document B)

Thanks

Flo.

Answer 3

Please let me know if you need any further assistance.

Kind Regards,

Elise

Answer 4

Hi, I'm Elise, and I'd be happy to help with your issue.

Not all functions are compatible with the online version, which I suspect is why you are having issues with the forumula.

Unfortunately there isn’t really a work around for this.

Please let me know if you need any further assistance.

Kind Regards,

Elise