Hi all,
in a table builder report I receivce the following error message: Formula could not be retrieved from range $1:$2183. The amount of rows does not seen too much for me and I only have a total of 12 columns. Could this be a memory problem? I am using Excel2013, 32-bit.
Thanks and kind regards,
Maja
Date
Votes
2 comments
-
Jet Reports Historic Posts It could be a memory issue. Does the error mention anything about memory? The only time I've seen that error, it specifically mentions "Due to Excel memory limitations….".
You could try to limit your results to see if returning smaller amounts of data solves the issue but you're right, 2000 rows doesn't seem like too much data. Does this same error occur on other workstations or just yours? -
Jet Reports Historic Posts No, there is nothing about memory issues in the message. Now I rebuilt the report and the error message does not show up again, maybe something got corrupted in the report, because I changed the resulting pivottable a lot. At last there was an error message about the pivot as well, so this might be the reason.
Thanks for your help,
Maja
Please sign in to leave a comment.