Your workflow is unique 👨💻 - tell us how you use Dropbox here.
Forum Discussion
Solved
Error that the file couldn't be opened when accessing Google sheets document online.
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!
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.
46 Replies
Replies have been turned off for this discussion
- Nancy
Dropbox Community Moderator
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.
Yes, I already tried it in different browser but still to no avail. I tried opening other Google sheets documents and some of them could be opened while others couldn't. It seems pretty random at the moment.
- Nancy
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?
I'm having this problem right when I click the document -- it can't be loaded. And yes, they are shared with other members. I have several other documents as well that are shared but have no problems. Only some that has .gsheets extenstion.
- Jay
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?
the file was last edited 2 months ago and it was created via Dropbox
- Jay
Do the other users trying to access the file get the same error?
yes
- Jay
How large is the document in general? If you duplicate the file, does the duplicate open?
not large at all, yes, it can't still be opened
