The REFRESH RECOMMENDED error in Excel gives us the option to discard or save changes, but if the issue persists, you can follow these solutions.

Excel displays the error message "Cannot extend list or database" if your new data record has to delete existing data. Data forms add records into a row directly after your last record.