Error in opening Google sheets document
Hi,
I'm encountering a problem while using Google sheets that's integrated with Dropbox. It used to be fine, but when I tried to open it today, the page refused to load and the message that I got is "File could not open. Try refreshing the page". I already tried to refresh the page several times, but it wouldn't work. I even tried to copy the file and open the copy -- but again, to no avail. This happened to my several other Google sheets documents as well.
What do you think is happening and what should I do now? I'm afraid that it will affect my other Google documents since I'm using the Google-Dropbox integration quite often.
I'd appreciate any help, thanks!
Accepted Solutions
Hi @Megan, thanks for replying, I copy the files into the same folder (though error also happens when I copy to elsewhere).
Steps are summarised below so you can see the second error in context. I sent the original issue to support on March 14th, (ticket 21729904) dropbox engineers are working on it but no progress afaik.
Error 1:
- Try to open 'Problem1.gsheet' spreadsheet file
- 'Could not open file, try refreshing the page'
Workaround:
- Rename file to 'Problem1.xlsx', open online, file works
- Close file, rename to .gsheet, open online, file works
Error 2:
- Make a copy of the 'fixed' .gsheet aka 'Problem1-fixed-copy.gsheet'
- 'Could not open file, try refreshing the page'
Essentially the workaround only sorts out individual files, it does not fix the issue with using copies of files. Some people mentioned that the problem applies mostly to copies of 'template' files.
Welcome to our forum, @sendyjasmine!
Have you also tried to access your Google Sheets via another browser? If so, do you still see the same error message?
Also, do you have any Google Docs/Slides saved on your Dropbox account? Do they also give the same error?
Let me know.
Nancy
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, give it a Like below to let us know.
Need help with something else? Ask me a question!
Find Tips & Tricks Discover more ways to use Dropbox here! Interested in Community Groups? Click here to join!
Thanks for updating me!
Are you having any issues at all when previewing these files on the web (right before you open them)?
Also, the files that you’re having this issue with, are they shared with another user or are they all personal files?
Nancy
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, give it a Like below to let us know. Need help with something else? Ask me a question! Find Tips & Tricks Discover more ways to use Dropbox here! Interested in Community Groups? Click here to join!
Hi @sendyjasmine, are these files that have previously worked in the past, or new files that were recently created?
Were they created via the Dropbox site itself, or copied across from Google Sheets?
Jay
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, give it a Like below to let us know. Need help with something else? Ask me a question! Find Tips & Tricks Discover more ways to use Dropbox here! Interested in Community Groups? Click here to join!
Do the other users trying to access the file get the same error?
Jay
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, give it a Like below to let us know. Need help with something else? Ask me a question! Find Tips & Tricks Discover more ways to use Dropbox here! Interested in Community Groups? Click here to join!
How large is the document in general? If you duplicate the file, does the duplicate open?
Jay
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, give it a Like below to let us know. Need help with something else? Ask me a question! Find Tips & Tricks Discover more ways to use Dropbox here! Interested in Community Groups? Click here to join!
Top contributors to this post
-
zry Explorer | Level 4
-
brightday New member | Level 2
-
Megan Dropbox Staff
-
KOMA Helpful | Level 6
