The CDS entity 'open in excel' feature is limited to 5000 rows in excel. Hence, the rows beyond first 5000 cannot be updated and published back to the CDS entity from excel. Is there a workaround for this 5000 rows limit? Please help.
If you want to get more details about the limitation in the number of uploaded data (uploaded via "Open in Excel" feature), please consider take a try to submit an assisted support ticket through the following link: