'%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)
Fix Excel 2019 Crashing When Copying PivotTable Data to Google Sheets
Question details
The user needs to stop Excel from crashing when attempting to copy values from a PivotTable and paste them into a Google Sheets document.
- Product
- Microsoft Excel 2019 (Professional Plus)
- Device & OS
- Windows
- Scenario
- Copying complex PivotTable data from a local Excel workbook to a web-based Google Sheets document.
- Observed behavior
- Excel abruptly crashes during the copy/paste operation. The Windows Event Viewer records an Application Error involving EXCEL.EXE and the mso20win32client.dll module.
Save all open workbooks and close any unnecessary background applications to prevent data loss while performing these troubleshooting steps.
Test Excel in Safe Mode and Disable Add-ins
Running Excel in Safe Mode bypasses add-ins, which are a common cause of clipboard conflicts and memory crashes when copying complex data like PivotTables.
Third-party add-ins often monitor clipboard activity or try to format data being copied, which can trigger an mso20win32client.dll failure in Excel 2019.
Press the Windows Key + R to open the Run dialog box. Type 'excel /safe' and press Enter to launch Microsoft Excel in Safe Mode.
Open your workbook containing the PivotTable. Attempt to copy the data and paste it into Google Sheets. If Excel does not crash, an add-in is likely the culprit.
Navigate to File > Options > Add-ins. At the bottom of the window, change the Manage drop-down to 'COM Add-ins' and click Go.
Uncheck all add-ins in the list and click OK. Restart Excel normally and re-enable them one by one to identify the specific add-in causing the crash.
Perform an Online Repair of Microsoft Office
If the mso20win32client.dll file is corrupted, repairing the Microsoft Office installation will replace the damaged files and resolve the application crashes.
Install Latest Office and Windows Updates
Outdated software can contain unresolved bugs with clipboard operations. Updating ensures you have the latest stability patches from Microsoft.
Try WPS Office for Seamless Spreadsheet Management
If Microsoft Excel continues to experience .dll errors and crashes during complex tasks like copying PivotTables, consider switching to WPS Office. It provides a highly compatible spreadsheet environment that easily handles complex data operations without unexpected application failures.
- 1. Download the Installer: Visit the official WPS Office website and download the free software package.
- 2. Install WPS Office: Run the downloaded installer and follow the quick setup wizard to install the suite on your PC.
- 3. Open Your Workbook: Open WPS Spreadsheet and load your existing Excel file. You can now securely copy your PivotTable data without encountering crashes.
Frequently Asked Questions
Why does copying PivotTable data cause Excel to crash?
Copying a PivotTable places highly formatted data and background cache structures into the system clipboard. If local add-ins, outdated graphics drivers, or core DLLs (like mso20win32client.dll) conflict with how Windows handles this clipboard data, it can cause the Excel application to crash.
What does the mso20win32client.dll error mean in the Event Viewer?
The mso20win32client.dll is a shared Microsoft Office module responsible for UI rendering and client-side operations. Seeing an exception code associated with this file usually indicates local file corruption, a bug in that specific Office build, or interference from third-party software interacting with the Office interface.
Is there a workaround to paste PivotTable data into Google Sheets without Excel crashing?
Yes. Try copying a smaller selection of the data first. Alternatively, once copied, use 'Paste special > Values only' (Ctrl+Shift+V) in Google Sheets instead of a standard paste. If Excel crashes immediately upon hitting 'Copy', try saving the Excel file as a CSV first, or uploading the entire Excel file directly into Google Drive.
