Forum Discussion
URGENT HELP REQUIRED
Hi All,
Need your support for a major review.
Trying to refersh a data set and constantly getting the error as :
Data source errorDataFormat.Error: Invalid cell value '#VALUE!'.. Microsoft.Data.Mashup.ErrorCode = 10400. . The exception was raised by the IDbCommand interface. Table: Summarized Table VC Name.
I have no idea what to do, PLEASE HELP !!!!!!!!!!!!!!!!!!!!!!!!!!!
If anyone can connect, they'll be a life saver.
Shampa The error you are encountering, DataFormat.Error: Invalid cell value '#VALUE!', typically occurs when there is an invalid or unexpected value in your dataset that the data processing tool cannot handle.
Check data source is it excel there is one cell with #VALUE when formula fail
Bhanu you are a rockstar !!!
Fixed it, Thanksssssssssssssssssssssss 😁
Shampa , You are welcome can you accept my reply as solution , currently you have selected you reply as solution by mistake, as it will help others
4 Replies
- bhanu_gautam
Super User
Shampa The error you are encountering, DataFormat.Error: Invalid cell value '#VALUE!', typically occurs when there is an invalid or unexpected value in your dataset that the data processing tool cannot handle.
Check data source is it excel there is one cell with #VALUE when formula fail
Bhanu you are a rockstar !!!
Fixed it, Thanksssssssssssssssssssssss 😁
- bhanu_gautam
Shampa , You are welcome can you accept my reply as solution , currently you have selected you reply as solution by mistake, as it will help others
Hi,
Accepted your reply as solution. Is it okay ?