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.
Hannah
Dropbox Staff
Dropbox StaffHey Cory M, pollenstudio, and anyone else experiencing this issue, thanks for the info.
Can we send you an email, so we can look into this a bit more closely?
Hi Hannah, that would be great thank you 🙂
Jay and sendyjasmine found a temporary workaround so we at least don't lose our files.
- open your dropbox account in your browser
- rename the file extension to .xlsx via the online dropbox website
- open + close the file (in the online excel editor)
- rename the file to .gsheet (optional if you want it to open in gsheets going forward),
- file should now be working.
- Hannah
Not a problem, I just sent you an email, so we can continue there! 🙂
This worked for my issue. Unfortunately, not until after we completely recreated a document unaware it was a larger issue. Unfortunately, this workaround also means all the formatting is completely gone. This has happened to 3 documents now. There needs to be a better more universal fix for this! It's bad enough that there is limited functionality of Google Sheets when using/creating through Dropbox (e.g. limited formulas and cell looks ups -- you can't have it reference a cell in another spreadsheet, and others) and now this issue. This specific issue has only started happening in the last couple months and needs sorted out quickly.
This is also problematic because it in essence creates an entirely new document. Which means that any revision history is gone and you can't restore or revert back to a previous version. ARG! Someone at Dropbox please figure out what is going on and fix this.
