'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Microsoft Forms Ranking Results Summary Showing Incorrect Counts
Question details
The user's Microsoft Form fails to correctly tabulate ranking results, displaying inaccurate item counts in the Results Summary.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Reviewing response summaries for a survey that includes a ranking question with multiple items.
- Observed behavior
- An option frequently selected as number one appears with an abnormally low count in the Results Summary. Exported Excel data exhibits anomalies such as missing rankings, blank responses, or identical sequences for empty submissions.
Before escalating the issue to Microsoft Support, export your current form responses to an Excel file to secure your existing data, and try accessing the form link in a private browsing window to rule out any browser-level caching problems.
Export and Analyze Forms Data Manually
Exporting the raw data to Excel helps you determine if the issue is a temporary display glitch in the Results Summary or a deeper data tabulation error.
In some cases, the visual Results Summary fails to sync properly with the database. Checking the raw exported data allows you to see the exact inputs submitted by respondents.
Open your Microsoft Form and click on the 'Responses' tab located at the top of the design page.
Click the 'Open in Excel' button to download the raw response data to your local machine.
Open the downloaded Excel file, locate the columns corresponding to your ranking question, and manually review the data for anomalies such as blank responses or missing rankings.
Submit a Support Ticket to Microsoft 365 Admin Center
If the exported data is missing or corrupted, the issue requires a backend log investigation by Microsoft Support.
Try WPS Office for Reliable Document and Data Management
Since backend server issues with online form tools can delay your data analysis, consider equipping yourself with WPS Office for your everyday data processing and productivity needs. WPS Office is a free, lightweight, and robust suite that seamlessly opens exported survey data and offers high compatibility with standard Office formats.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the Software: Run the installer and follow the simple on-screen instructions to set up WPS Office on your device.
- 3. Analyze Your Data: Launch WPS Spreadsheets to open your exported Excel data and seamlessly tabulate your survey results without relying on cloud summaries.
Frequently Asked Questions
Why are my Microsoft Forms ranking results not displaying the correct counts?
This is typically caused by a backend tabulation error or a synchronization delay within Microsoft Forms, which causes top-ranked items to display significantly lower or incorrect counts in the visual Results Summary.
Can I recover missing ranking data from my Microsoft Form?
You can attempt to view the actual data by clicking 'Open in Excel' in the Responses tab. If the raw exported data is still missing or blank, Microsoft Support will need to investigate the background server logs to attempt recovery.
What information should I provide to Microsoft Support when reporting a Forms tabulation issue?
To expedite the investigation, you should provide the form's creation date (age), dates of recent submissions, results from testing the form in a private/incognito window, and screenshots comparing the incorrect summary with the raw Excel data.
Do exported Excel files always match the Forms Results Summary?
Not always. In cases of tabulation glitches, the visual Results Summary may show incorrect aggregated counts, while the exported Excel file might contain the actual raw respondent selections, or it might reveal blank and corrupted ranking sequences.
