It has been fine for several weeks, today we started to have an issue, that is, when we manually open the sheet, it just keeps saying "Trying to reconnect. Turn on Offline setting. This file points to an invalid online Google document: The original file is no longer in Google Drive. Make sure that your permissions on the google sheet are set to exactly "anyone with the link can view". Note that you may also encounter issues if you have multiple "sheets" within a google sheet. Both of those could be reasons why you have problems editing that sheet. Is it okay to send a thank-you-for-teaching to a professor who taught a course a few semesters ago? From various sources, it seems that the old versions cannot be deleted (http://www.sevenminutescientist.com/2016/06/03/no-you-cannot-remove-a-revision-history-from-a-google-doc/). In this case, you may need to ask administrators to enable this or setup the google sheet within a personal google account - in this case, you can always share it with your business account so you can manage it from both. Note: Sometimes, within business google apps accounts, this permission setting is not available. You can only change Google documents when online. Important: Do not post any personal information on the forums, such as email address, phone number, or financial information. It keeps saying Trying to reconnect. To edit offline, turn on offline sync when you reconnect", and "Reconnecting". By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy. We have a large Google Spreadsheet in our project (< 700k cells) and it's well under the 2 million cells size limit as described in here . It keeps saying Trying to reconnect. Moving my website to a new platform, will Storepoint still work there? I suspect that even if you resolve this issue, you will simply hit further problems. I have checked Skype for Business and Outlook already. It´s not hard to imagine sheets struggling to display 700k cells which are being updated in the background. Why does this Excel RIGHT function not work? You can also turn on offline access from Docs, Sheets, or Slides settings. The template is available on the sync setup page as well as by going to Manage Locations > Bulk Upload. Make a copy of the original document online and select it for syncing. Does the European right at large oppose abortion? After you restart your computer, it will take some time for Backup and Sync to complete. Here are some general problems you might see: After you restart Backup and Sync, it will take some time to complete. On a Windows computer, the icon is found in the taskbar at the bottom right of your desktop screen. Select your folder in its new location and click. 1 Recommended Answer. Tip: If you want to use offline access for another Google Account, make sure you're signed in to the right Chrome profile. Can it be due to the many versions saved? You may see the following errors in Google Drive: After you locate your missing folder, it will take some time for Backup and Sync to complete. Are you using a paid or edu domain? your coworkers to find and share information. I've seen today that the status in Teams is stuck in "Offline". (It will be a pain to stop all the scripts / redirect all the scripts to another Spreadsheet). Tuning the lowest bass string a hair flat, Writing letter of recommendation for someone I have never met. Why does a blocking 1/1 creature with double strike kill a 3/2 creature? Using a database is definitely a better idea than a spreadsheet for such a large scale dataset. We can make no changes to the sheets. You can include screenshots, OS versions, or any other data you think may help. If the permission is not exactly this, the sync process will be unable to open the sheet in order to sync, which may result in getting stuck.

We tried to use different browsers (chrome, firefox, edge) and different OS (Windows, Mac), and we still have the same issue. If so, what can be done if we don't want the sheet to change its ID? Reproduce the problem you experienced. rev 2020.11.2.37934, Stack Overflow works best with JavaScript enabled, Where developers & technologists share private knowledge with coworkers, Programming & related technical career opportunities, Recruit tech talent & build your employer brand, Reach developers & technologists worldwide. Choose a new Google Drive folder and sync your files. What should be my position? Google Sheet Stuck and unable to update, too many old versions?

sorry to have to say it, but it may be time to stop using Google Sheets as a database and switch to a database. Repeat that action while logging is active. The file on your computer is missing: Restart Backup and Sync. Make sure that your google sheet has only one "sheet" within it (just one tab at bottom). Or it could be something entirely on Google's end. Thanks for contributing an answer to Stack Overflow! We can also access any other sheets and make changes without any problem. How many people voted early (absentee, by mail) in the 2016 US presidential election? If this doesn't work, restart Google Drive sync. If your Google Sheet Sync is not syncing or appears to be stuck. How to get back a backpack lost on train or airport? How can I get the sheet to load the latest script? After you manually sync files, it will take some time for Backup and Sync to complete. To edit offline, turn on offline sync when you reconnect, and Reconnecting. Stack Overflow for Teams is a private, secure spot for you and For example, you may get an error when you add a file to the Google Drive folder on your computer. I work in a country with weak and unreliable bandwith, so I was really excited when they release offline modes and editing for Google Drive and Chrome. but you havn't provided much detail.

Take postcodes and get the Lat long information from them. How to create filters by location type, products, categories and more... Search function not working or shows an error, Locator not showing up or only shows up after refresh on Squarespace. For "Question," type "Drive Sync Client Log.". In the top right, next to Search, click or tap the power icon. On a Mac, the icon is found in the menu bar at the top right of your desktop screen. Can it be due to the many versions saved? For example, saying "sync will start within 5 minutes" or similar for a long time, there is most likely an issue with at least one of two setup items: Once these issues are solved, ping us at hello@storepoint.co with your account e-mail and we'll check it out + get it unblocked for you. What prevents dragons from destroying or ruling Middle-earth? I can't switch it back to "Available, neither through the comman line (/available) not with the button (here i'm not even getting the drop-down menu). bash + match regexes for both diffrent hostnames. Google Drive/Docs Stuck in Offline Mode! Use a Google Forms to update existing Google Sheets, Google Scripts onEdit not recognising data being edited on a sheet during a sync from a mobile device, i need to calculate a time difference in google sheets, Google Script and Anonymous user in Google Sheet, Updating old formatted spreadsheets using a reformatted spreadsheet that takes the old values and duplicates them, Google Sheet data not saved before script copy. After you reinstall Backup and Sync, it will take some time to complete. The Overflow #45: What we call CI/CD is actually only CI. Download the most recent version of Backup and Sync. You will be asked to choose a new location for the Google Drive folder. When I look into the version history, it shows the following: "Google Docs encountered an error. Our Google Spreadsheet is broken and cannot be edited / saved. We have been programmatically updating this sheet by creating CSVs in the google drive with python, then using Google App Script to update the sheet with contents from the CSVs. To get the latest tips, tricks, and how-to's, subscribe to our YouTube Channel. What is this symbol that looks like a shrimp tempura on a Philips HD9928 air fryer? The only difference between the actual sheet and the copied sheets is probably that the actual sheet has a lot of old versions (it has been updated every 3 minutes for weeks). We tried to make a copy of the sheet, and we are able to make changes to the copy. Google Spreadsheet DB Import Error: Couldn't save document with id [--ID--]: Document is too large, Google Apps: Duplicate template sheet and delete old sheet. I am unable to access any of the old versions. To solve, set the permission to "anyone with the link can view". Just like the PC case, I am unable to make any changes when I use mobile version on Android. A good way to transition different character perspectives. See newRevision. Another possibility is that many other scripts read this sheet. For example, saying "sync will start within 5 minutes" or similar for a long time, there is most likely an issue with at least one of two setup items: Make sure that your permissions on the google sheet … //www.google.com/tools/feedback/metric/report, Step 2: Post the Report ID to the Google Drive Help forum, Files not syncing between your computer and, Backup and Sync stuck on "Preparing for Sync.". To work offline, in your Chrome browser, open Google Docs, Sheets, or Slides. I'm sure their dev team would be interested to hear from you, they've been very helpful to me. Below "Question," type your Report ID and a description of your issue.

If you are unable to solve your problem, you can send an error report to Google. Make sure that your google sheet column names match our template. If so, what can be done if we don't want the sheet to change its ID? To edit offline, turn on offline sync when you reconnect, and Reconnecting.

What tool do I need for this bolt that holds the crank arm on this stationary bike?

I would say it is on Googles end, reads would be very unlikely to affect the sheet but writes every 3 minutes for weeks could be causing an issue (I think you meant > 700k cells?) An ".edu" domain was used. Making statements based on opinion; back them up with references or personal experience.

By using our site, you acknowledge that you have read and understand our Cookie Policy, Privacy Policy, and our Terms of Service. It will take some time for your files to sync. Google Sheets script executes outdated version. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. If some or all your files are not syncing between your computer and My Drive, you can try to fix the problem. Where to repeat in this Jingle Bells score? Asking for help, clarification, or responding to other answers. So I don't think it's anything related to firewall / browser configuration.

Can this be why? When the report is sent, you’ll get a Report ID. However, now it seems that my Google Drive and all my google docs are stuck in offline … To give us insight into what is wrong, click. Can that be a reason of failure to edit? http://www.sevenminutescientist.com/2016/06/03/no-you-cannot-remove-a-revision-history-from-a-google-doc/. My boss makes me using cracked software.