Sep 29 2021 09:11 AM
Hi guys
I have one excel file, then transform into Power Query then move to power pivot to make measures in this before creating pivot table.
The file only use table in current file, not including any external source, I just use excel.currentworkbook to refresh the file
When I move file to another person, she caught an error saying like this
"Excel couldn't refresh table from connection "Query-TongHop1".
Here is the message from external data source.
The operation failed because the source database does not exist, the source table does not exist or because you don't have access to the data source.
More details:
- OLE DB or ODBC error: [Data.Format.Error]. Invalid cell value "#VALUE"
- An error occur when processing table "TongHop"
-The current operation was cancelled because another operation in the transaction failed.
I have check but no #VALUE errors.
Could you please tell me how to fix this error?
Oct 08 2021 05:53 PM
check your data set for data type errors or mis-matches like text that look like dates, or formulas that have a #Value, #ISNA, etc. also go to the:
turn off the Type Detection
check if that helps