[Solved] Maximum table size for DGET?

[SCFrolich]

Is there an upper limit to the size of a table that you can use dget on before it breaks?

I have a fairly large table (B3 to AX 39) filled with information. Another cell on another page is used to make the selection from the first column of the table. To extract all the data on the same row I use dget to reproduce the entire selection underneath the table so that I can then proceed with all further interactions.

It works, but once I get to the AC column, dgets stops working and all I get is #VALUE error.

Nothing in my formula has changed from one column to the next aside from the needed coordinates.

Thoughts?

[karolus]

Maybe have a look into your similar topic 2 years ago

[SCFrolich]

Oops. Been a while since I had the issue, totally forgot.

Sorry. I suck.