Sometimes pop-ups can be blocked by Google Chrome when using Google Sheets.
To allow pop-ups in Google Sheets, please following the following steps:
- Go to Settings of Chrome.
2. Search for pop-ups in the search bar. Click Site settings at the bottom.
3. Scroll down to find the “Pop-ups and redirects” and click it.
4. Click the “Add” button next to “Allowed to send pop=ups and use redirects.
5. Finally, copy and paste “https://docs.google.com” and click add.
6. Done! Now pop-ups are allowed in Google Sheets.