PROBLEM :( Stack overflow error

michaellaudrup10

New member
Joined
May 8, 2020
Messages
8
Reaction score
0
Points
0
Location
London,UK
Excel Version(s)
Excel 365 (latest)
Hi guys,
Recently when I have attempted to paste new data to my source and refreshed my query I get the following message

"Evaluation resulted in a stack overflow and cannot continue"

Anyone know why this is? how to rectify it. I have to update the source data every month (and then refresh the query) and I fear getting this message will disrupt me completing my task, so would like to find a solution to this problem.

Any help would be appreciated. Many thanks.
 

Attachments

  • power query.docx
    269.3 KB · Views: 36
Last edited:
Sorry, haven't seen that one before. My only suggestion, which you may have already tried, is to be sure that both Excel and Windows are up to date.
 
Can you post a screenshot of the queries from the query editor? Try isolating it step-by-step. I have got it before and I managed to rectify it. Is there a datatype mismatch ?
 
Back
Top