This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Warning Table ‘Sheet1’ has an implicit (RowNumber) key

Posted on 09-24-2019 05:23 AM
Corbett_Destina
New Member
Reply posted on --/--/---- --:-- AM

I want to remove this warning Table ‘Sheet1’ has an implicit (RowNumber) key – if multiple users insert or delete entries concurrently, data loss can occur. Updates may apply to the wrong record or could fail entirely on some data sources. Have tried several suggestion & articles but still not working?

0 3 1,689
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM


0 Likes

Posted on --/--/---- --:-- AM
Corbett_Destina
New Member
In response to Steve
Reply posted on --/--/---- --:-- AM

Thanks for commenting. but I am not able to make my new key column auto updated even after I put UNIQUEIN() in “initial value” option. the error is showing in the app that “rowkey is required” which app should auto generate for new entries.

0 Likes

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to Corbett_Destina
Reply posted on --/--/---- --:-- AM

Please provide a screenshot that shows your key column.

0 Likes
Top Labels in this Space