Google Sheets Troubleshooting: Errors, Editing and Unexpected Results

Start by separating a file or browser failure from a cell calculation problem. If one formula fails but you can edit the rest of the spreadsheet, browser cleanup is unlikely to explain that formula. If the file will not open, rewriting formulas is not yet a useful step.

Scope: native Google Sheets files in a desktop browser; official help checked October 21, 2026. Excel-file editing, mobile apps and account-specific feature availability may differ. This is documentation-based guidance with independently checked expected arithmetic, not an executed Sheets test. No sign-in, application session or native screenshot was used.

Before attempting a repair

Record the exact error, spreadsheet tab and cell, browser, date, and whether the issue began after an import, permission change or formula edit. Preserve the original. Use a permitted copy for experiments, but do not treat it as a full backup of collaboration history: Google warns that copies and downloaded files lose features such as version history. Google’s editing-error recovery guidance.

Do not close a tab containing unsynced work or clear browser storage as your first step. Follow offline reconciliation when changes have not reached the service.

The file will not open or reports a server error

For the specific reload/server-error messages in Google’s guidance, wait five minutes and retry. Check whether another permitted file opens in the same browser; this distinguishes a file-specific symptom from a wider failure without changing the damaged file.

If the problem persists, Google’s documented options include another supported browser and checking extension interference. Do not disable organization-required security controls. Preserve unsynced content before a reload, browser restart or storage cleanup. Record what changes the outcome instead of performing several changes at once. See Google’s troubleshooting sequence.

Copying data to a new spreadsheet can aid recovery, but it does not prove that formulas, permissions or history were preserved. In particular, Google says its suggested IMPORTRANGE recovery route does not import the original formulas. Keep the original for comparison.

You can view the sheet but cannot edit

Check file-level access before changing cell rules. A viewer or commenter does not gain edit access by changing a formula. If only selected cells are blocked, ask the owner to inspect the intended protected range.

Google distinguishes a warning from an actual restriction: a warning permits the user to proceed, whereas restricted editing limits who may change the range. Protection is not encryption. The protection menu can also be absent when editing an Office file; Google’s instructions require conversion to native Sheets for that feature. Convert only an authorized practice copy and check the result. Google’s protection documentation and the worked protection guide cover the relevant controls.

A formula or imported result fails

Use the error’s detailed message and the formula’s purpose to choose a specific investigation:

• FILTER reports mismatched range sizes: compare the data and condition dimensions using the range-size repair.
• IMPORTRANGE asks for access again: check the exact source and account relationship with the permission diagnosis. Do not publish the source to avoid an access problem.
• An imported named function fails: inspect name collisions and dependencies with the named-function guide.
• A QUERY result misses timestamps or repeats headings: use date boundaries or combining tabs with one header, respectively.
• Product IDs lost their leading zeros: start again from the unchanged source and follow the CSV identifier guide. A display format cannot recover missing source information.

Do not replace every error with a blank. That hides the distinction between absent data, inaccessible data and an invalid calculation.

A result does not update or a date looks wrong

Inspect File → Settings before editing many cells. Locale and time zone are spreadsheet-wide, not personal fixes; Google says changes affect everyone working on the file. Its current desktop documentation also distinguishes automatic and manual calculation modes and states that manual calculation is unavailable in the mobile app. Check the controls actually present in your environment rather than assuming every stale result has the same cause. Google’s settings reference.

For a small diagnostic, enter 15 in A2, 9 in B2 and =A2+B2 in C2 in an editable practice sheet. Expected result: 24. Change B2 to 12; the recomputed result is 27. These answers were independently calculated, not observed in Sheets. If C2 stays at 24, record the calculation mode and try the documented calculation control if applicable. This local test does not validate external-data refresh timing.

For a wrong-looking date, inspect both the input and locale/time-zone settings before converting text across the entire file. For a past edit, inspect version history and coordinate before restoring shared work.

A useful support report contains a sanitized minimal formula, expected and actual results, error text and browser details. Never include access tokens or private source data merely to demonstrate the error.

Calculation error reference

For worked examples of specific formula errors, browse the calculation error reference. Use the relevant guide on a disposable example or a copy of your workbook.