Try the following steps. It might work.
-
Duplicate your Google Spreadsheet first.
-
Open your app, go to settings, go to data sources, and replace your current spreadsheet with newly duplicated spreadsheet.
-
Once the spreadsheet has been changed, try duplicating the app again.
This works for me most of the times.