If Microsoft Forms is not showing in Excel, the fix depends on what failed: a missing response usually points to a broken workbook link, stale data often means the live connection stopped refreshing, and a missing column usually means the form questions changed. If you pick the wrong fix, you can overwrite the wrong sheet, lose response history, or keep working from old data. This guide shows which part broke and which repair is least destructive.
What the error means
The fastest first check is the Forms Responses tab, because it tells you whether the response exists in Forms before you touch the workbook. If the response is in Forms but not in Excel, the fault is usually in the workbook, the question mapping, or the live connection.
Separate the symptom before you fix anything
A missing single answer is not the same as missing every new response. A missing column usually points to a question mapping problem. A workbook that stopped growing usually points to a lost live connection or a one-time export.
Suppose a form has about 12 questions and the workbook still shows about 12 columns, but one column stopped changing after a question was renamed. That points to the column mapping, not the entire sync path. By contrast, if every new response after Tuesday is missing, the workbook link is the first thing to inspect.
📊 The repair feature is limited to Office 365 Education and Microsoft 365 Apps for business users. Source: Microsoft.
Likely causes
Most often, the workbook lost its live data connection after a move, copy, or edit to the response table. Less often, the file is only a one-time export, or the form was created in a context that does not support live workbook sync.
- Live connection broke after the workbook was moved, copied, or edited.
- Question mapping changed because a response-table column was renamed or shifted.
- One-time export from Open in Excel with no live connection.
- Form context does not support live sync in the way you expect, so the workbook never updates.
Why is my Microsoft Forms not showing in excel?
First confirm that the response exists in Forms, then open the workbook from the Responses tab instead of relying on an older copy. If the workbook is stored in OneDrive for work or school or SharePoint Online, it can have a live data connection; if it is an old download, it may not update at all.
- Open the form in Microsoft Forms and go to Responses.
- Check whether the missing submission appears in the response list.
- Select More options on the Responses tab, then open the workbook from there (per Microsoft support).
- Confirm the file is stored in OneDrive for work or school or SharePoint Online.
- Sign in with the work or school account that owns the form and workbook.
A common first-timer mistake is opening a downloaded spreadsheet from Downloads or Desktop and expecting it to refresh. If the file was created as a one-time export, it can look correct on day one and stay frozen after that.
Missing one question column
If only one column stopped updating, the problem is usually the question-to-column mapping, not the whole workbook. Do not rename, delete, or move response-table columns while you troubleshoot. That can make the mapping harder to recover.
- Open the workbook from Forms > Responses, not from an older copy.
- Find the column that no longer matches the question order or label.
- Check whether the form question was renamed, removed, or reordered.
- Restore the original column structure if it was edited; do not insert replacement columns into the response table.
- If the workbook is still linked, send one new test response and see whether that column updates again.
If a single question was renamed from “Order ID” to “Ticket ID,” the workbook may still update, but the old column title can look wrong or appear detached from the current form layout. The safer fix is to preserve the response table and let Forms continue writing into the same mapped column.
Why are all new responses missing?
If old responses are present but every new one is missing, the live connection likely stopped refreshing. The least destructive next step is to test the connection with a fresh response before rebuilding anything. If the workbook connection is gone, Microsoft’s repair path is Sync all responses to a new workbook on the Responses tab (per Microsoft support).
- Open the form and go to Responses.
- Send a new test response from a separate browser or account if possible.
- Refresh the workbook and see whether the new row appears.
- If nothing updates, select More options on the Responses tab.
- Choose Sync all responses to a new workbook to retrieve the most recent response data.
This repair action opens the new workbook in Excel with the most up-to-date responses, and the new workbook is stored next to the original workbook. The feature is only available for Office 365 Education and Microsoft 365 Apps for business users.
No Open in Excel option
If you do not see Open in Excel, the form may be a personal form, a work form with different sharing settings, or a form created in a surface that does not offer the same workbook path. In that case, you may only get a download-a-copy behavior, and there may be no live connection to repair.
- Check whether the form was created in Microsoft Forms, Teams, SharePoint, the Forms web part, or another Microsoft 365 surface.
- If the form was created in Microsoft Forms and you chose Open in Excel, treat the file as a workbook without live connection.
- Look for the response workbook location in OneDrive for work or school or SharePoint Online.
- If live sync is not offered, use the available export or copy path rather than editing the response table.
- If you need a live workbook later, recreate the form in a supported work or school context.
Teams and the Forms web part can create forms with live workbook connection, so responses should reflect in the linked workbook when the connection is intact. Personal standalone forms are more limited, and a missing button there does not mean Excel is broken.
Forms response matrix
Use the symptom first, then pick the least destructive fix. The question is not “how do you force Excel to update?” The question is which part broke: the workbook, the mapping, or the connection.
| Failure mode | Symptoms | Likely cause | Safest fix | Old responses recoverable? |
|---|---|---|---|---|
| Missing one question column | One response field stopped updating; the rest still flow | Column mapping changed or the response-table header was edited | Restore the original table structure; do not move or rename columns | Usually yes, if the table was not damaged |
| All new responses missing | Older rows remain, but new submissions never appear | Live connection broke | Use Sync all responses to a new workbook from the Responses tab (per Microsoft support) | Usually yes in the new workbook, if the repair succeeds |
| No Open in Excel option | You only see a download or copy path | Form was created in a context without live workbook sync | Use the available export, or recreate the form in a supported work or school context | Sometimes no; a copied form may not carry old responses into Excel |
Still not working?
If the workbook is corrupted or the live connection will not recover, the next step is to create a fresh workbook from the current form or copy the form and rebuild the response path. That is more invasive, but it is safer than continuing to edit a broken response table. If the file lives in SharePoint Online or OneDrive for work or school, involve your tenant admin or Microsoft support.
- Try Sync all responses to a new workbook again from the form’s Responses tab.
- If the workbook still fails, copy the form and compare whether the new copy accepts fresh responses.
- Keep the original workbook untouched so old data is not lost during testing.
- If the file is in SharePoint Online or OneDrive for work or school, ask the tenant admin to check permissions and file history.
- Escalate to Microsoft support if the response workbook cannot be repaired.
Prevention is simple: open the response workbook from the form, not from a local copy, and avoid manual edits to the response table. That is the easiest way to keep the mapping intact.
Frequently asked questions
Why is my microsoft forms not working?
When the issue is Excel not updating, start in the form’s Responses tab and verify the submission exists there. If it does, open the workbook from the form and check whether the file is stored in OneDrive for work or school or SharePoint Online. That narrows the fault to the workbook path.
Why are my Microsoft Forms responses not showing in Excel?
The workbook usually lost its live connection or you are viewing an old export. Open the form, go to Responses, then choose More options and Sync all responses to a new workbook if available. If the form was opened in Excel, there is no live connection to restore.
Why is Microsoft Forms data not showing in Excel?
Check whether the missing data is all new rows or one field. A single field points to column mapping; every new row points to the live connection. If the workbook is in SharePoint Online or OneDrive for work or school, the repair path is the Responses tab option.
Why is Microsoft Forms not showing all responses in Excel?
If some responses are there and later ones are missing, the workbook likely stopped syncing. Send one fresh test response and refresh the workbook. If nothing changes, use Sync all responses to a new workbook from the form’s Responses tab to pull the latest data into a new file.
Why is microsoft forms excel not updating?
The most direct cause is a broken live data connection. Confirm the workbook was created in a supported work or school context, then re-open it from the form instead of from a local copy. If the connection is gone, the repaired workbook opens with the newest response data.
How do I get a new workbook with up-to-date data in Microsoft Forms?
Open the form, select Responses, then choose More options and Sync all responses to a new workbook (per Microsoft support). The new workbook opens in Excel with the most up-to-date responses, and Microsoft stores it next to the original workbook.