Fix Missing MySQL Rows When Refreshing Excel 2019 for Mac
Question details
The user needs an Excel 2019 for Mac query to show all current rows from a MySQL database.

- Product
- Microsoft Excel 2019 for Mac and MySQL
- Device & OS
- Mac, macOS version not provided
- Scenario
- A workbook uses a MySQL query to retrieve records from a database that receives regular updates.
- Observed behavior
- The query displays only a few rows, and refreshing it may not show newly added records.
Confirm which database, table, and query the workbook uses, and check that you can view the source records in a MySQL client. Note your macOS and Excel version numbers in case you need to report the issue.
Test the MySQL connection with a new sample database
Use a small test database to determine whether the missing rows can be reproduced outside the original data source.
In your MySQL client, create a test database and table with more than three rows. Use non-sensitive sample data.
Run a SELECT statement against the test table in your MySQL client and confirm that it returns every sample row.
Use the same connection method to query the test table in Excel, then use the available Refresh command on the result and compare the displayed rows with the MySQL results.
If the test also misses rows, open About This Mac from the Apple menu and About Excel from the Excel menu. Include those version details and the test results when requesting support.

Check the query and refresh the workbook
Use these checks to rule out a row limit, filter, or incomplete refresh before investigating the connection further.
Review MySQL Export Data in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for reviewing spreadsheet data. Open a MySQL export in WPS Spreadsheets or move compatible workbooks from Excel; WPS does not repair Excel's MySQL refresh connection.

Frequently Asked Questions
Why does my MySQL query show fewer rows in Excel?
A SQL LIMIT or WHERE condition, an Excel result filter, or a connection issue may be involved. Run the same SQL in a MySQL client and compare the results with Excel.
How can I tell whether the database is causing the problem?
Create a test database with more than three sample rows, verify them with a SELECT statement in a MySQL client, and query it through the same Excel connection method. Compare the results to see whether the issue also occurs with the test data.
Where can I find my macOS and Excel versions?
Choose About This Mac from the Apple menu for the macOS version, and choose About Excel from the Excel menu for the Office version.
Can WPS Office fix Excel's MySQL refresh connection?
No. WPS Office is an alternative for working with spreadsheet files, not a repair for Excel's connection. You can export MySQL data to CSV and open it in WPS Spreadsheets for review.




