Forum Discussion
Combine Files no longer working
UPDATE: Thanks all for your helpful replies on this, and your most recent post, El_Conquistador
It was solved in the end: I realised if I had one of the spreadsheets I wanted to combine actually open when I had the Power Query window open, the combine function would fail as per above. But once I closed the spreadsheet, it worked!
Only discovered this fortuitously . I often had one of the spreadsheets I was trying to combine open so I could see better the columns I was working with. Hope that helps others with this same issue.
UPDATE: Thanks all for your helpful replies on this, and your most recent post, El_Conquistador
It was solved in the end: I realised if I had one of the spreadsheets I wanted to combine actually open when I had the Power Query window open, the combine function would fail as per above. But once I closed the spreadsheet, it worked!
Only discovered this fortuitously . I often had one of the spreadsheets I was trying to combine open so I could see better the columns I was working with. Hope that helps others with this same issue.