Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Expression Error column of the table was not found

Status
Not open for further replies.

Cpreston

MIS
Mar 4, 2015
972
GB
Hi

I have a spreadsheet that drawa data from another spreadsheet. Everything was working fine until all of sudden I am now getting this error message

expression error the column column 23 of the table wasn't found excel

I have checked the data and it is all clean, I have looked into the advanced query but cannot see anything incorrect or changed. Also googled it but could nothing to resolve it.

Any ideas please. Thanks in advance
 
If it is multiple steps query, check data preview for each step. Note tat M is case sensitive language.
If this does not help, post a workbook with dummy data.

combo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top