Forum Discussion
Error while accessing table ... because it contains overflow errors
You may try to play with Diagnostics as here twinfield - Stack overflow error importing data to Microsoft Power BI: 'Evaluation resulted in a stack overflow and cannot continue.' - Super User (that's for Power BI Desktop, but in Excel that's practically the same).
Since you work with Excel table, you may query it by portions and narrow the range with error. Check dates fields, overflow error appears if in it number more than 31 Dec 9999 in equivalent.
You may try to play with Diagnostics as here twinfield - Stack overflow error importing data to Microsoft Power BI: 'Evaluation resulted in a stack overflow and cannot continue.' - Super User (that's for Power BI Desktop, but in Excel that's practically the same).
Since you work with Excel table, you may query it by portions and narrow the range with error. Check dates fields, overflow error appears if in it number more than 31 Dec 9999 in equivalent.
SergeiBaklan Great, thanks!
I caught the error, meanwhile, with a more "brute" approach by deleting half of the columns, checking if the error persisted, if yes than delete the next half, if not check the other half, etc. I narrowed it down to 4 rows in 1 column that way. (Maybe useful for future reference if someone has the same problem).
But your link may prove useful in the future, thanks.
Thank you for the update. And what the reason of the error, if that's not a secret?
SergeiBaklan As you said, dates > 31/12/9999.