Jossaesippan7

 I don't think the problem is as simple as you stated It's probably something that occurred during the table expansion For example, on an Excel table, if you have values that are #NA, these values show up as errors when the table is imported into PQ In PQ, you can set a value as NumberNaN(), and the value would show up in Excel as #NA I imported a table into a Microsoft Excel sheet, when I apply the changes to the query, I get this error DataFormatError Invalid cell value "#NAME?" " The table contains a "Notes" text field, it may occasionally start with a "=" sign and this can determine the error Hi, I imported a table into a Microsoft Excel sheet, when I apply the changes to the query, I get this error DataFormatError Invalid cell value Formulas A1 A And A1 Z Give Invalid Name Error In Excel Super User Invalid name error excel vlookup