Forum Discussion
Excel couldn't refresh table from connection
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?