You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.
Forum Discussion
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 g...
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.
Hi
As of this morning I can't open large google spreadsheets (I've checked 5 large files) on Dropbox either via desktop or online. Small files (single sheets with less than 200 lines) open fine, gdocs and slides also open. Making a copy of the files, clearing cache, logging in+out, incognito, wifi/wired connections, different laptop (mac and windows), and different browsers did not help. I have already contacted support for help (they are working on it), posting here in case someone in the community has another idea.
Many thanks!
Hannah
Dropbox Staff
Dropbox StaffHey KOMA, thanks for reaching out to us about this.
What kind of error message are you getting?
And what is the size of the files you're having this issue with?
If you can also give us the ticket number for your communication with our support team, I would really appreciate it.
Thanks!
Hi Hannah, the message is
Google Sheets
Could not open file. Try refreshing the page.
I'm not sure how to check the file size for these documents as I believe they are effectively just links? On my desktop they say 200 bytes but so do all other files where we use the google interface for files 'created' on dropbox. I call them large files as I know from my own work that they are long documents with a significant amount of descriptive text, we are not using the spreadsheets for calculation, there is generally just one formula to gather the descriptions from multiple cells into a single cell, there is also a good bit of in-cell visual formatting. The files I consider small/ simple are still descriptive but no more than say 2-5 words per cell (eg a name or location), a date, or link.
My ticket number is 21729904
Many Thanks!
-deleted-
I have this same issue, although renaming to .xlsx and back to .gsheet does not fit it for me.
In my case, when I duplicate the file the same error happens on the duplicate, and in my main file, I attempted to restore an earlier version (within Google's Version history not Dropbox's) and it rendered the file unopenable.
