Some sheets may not export due to permission issues with the sheet's parent folder on Drive. Owners or other uses with read/write permissions for a folder should be able to export as expected, but others will get stuck at the exporting stage.
Possible scenarios for this include:
The sheet, but not its parent folder is shared with a user
User does not have permission to modify the sheet or its parent folder
Possible solution is to export data to the root folder of the user's "My Drive" folder.
Synthoid
commented
7 years ago
Some sheets may not export due to permission issues with the sheet's parent folder on Drive. Owners or other uses with read/write permissions for a folder should be able to export as expected, but others will get stuck at the exporting stage.
Possible scenarios for this include:
Possible solution is to export data to the root folder of the user's "My Drive" folder.