Skip to main content

Why was my Google Sheet archived or not updated?

Written by ProBackup

This article explains why a synced Google Sheet may be moved to the Archive folder, stop receiving new records, or not be updated, and what you can do about it.

How Google Sheets sync works

After each backup cycle, ProBackup updates the same Google Sheet for every dataset (for example, all tasks in one project). New records are added as new rows and changed records are updated in place. In a few situations the existing sheet is archived and a new one is created in its place. Archived sheets get the [ARCHIVED] prefix in their name and are moved to the Archive folder next to the new sheet.

Reasons a Google Sheet is archived

  • The columns changed – for example, a custom field was added to or removed from your project or board. ProBackup then creates a new sheet with the new columns and fills it with all records.

  • The dataset grew above 50,000 records – the sheet is archived and replaced by a sheet marked (not synced), which explains that the dataset is too large for Google Sheets. All records stay available in your ProBackup dashboard.

  • You downgraded to the Plus plan – the sheets stop syncing and show "This sheet is no longer synced due to downgrade to Plus".

  • The backup was cancelled – the sheets stop syncing and show "This sheet is no longer synced because the backup is inactive".

"This sheet is full"

A Google Sheet holds up to 50,000 rows or 1,500,000 cells per dataset (whichever comes first). When a sheet reaches that limit:

  • Records that are already in the sheet keep updating.

  • New records are no longer added to the sheet.

  • Cell A1 turns red and shows "⚠️ This sheet is full…" with the date of the last sync.

Your ProBackup vault still holds every record. To view or export the complete dataset, open it in your ProBackup dashboard.

Reasons a Google Sheet is not updated

  • Your Google connection was lost – for example, because access was removed in your Google account. We email you when this happens. Go to Settings > Google Drive and click Reconnect.

  • Your Google Drive is full – ProBackup can't create new sheets or files. We email you when this happens. See Troubleshooting Google Drive sync.

  • Your user was removed from the workspace – if your account no longer has access to the workspace in the connected app, the backup and the sync stop. Ask a team member to re-add your account.

Note: If cell A1 offers [click to resync], use it to request another sync. This can take up to an hour, and you can use it once every 15 minutes. Resyncing does not bypass the limits above. A full sheet shows Learn more instead; use ProBackup to view or export the complete dataset.

Can I edit the Google Sheets?

The Backup tab is locked to keep the sync reliable. Don't add, change or remove cells, rows or columns in it: ProBackup doesn't detect your edits, so they can be overwritten or end up misaligned at the next sync.

To build reports or analyse your data, use the Pivot table and Charts tabs in each Google Sheet. These tabs are yours to edit.

Note: Because structural changes in your app create a new sheet, we don't recommend using Google Sheets sync as a primary reporting tool. Any connected reports would need to be re-linked to the new sheet.

Did this answer your question?