Fix Excel Workbook Size Increasing After Copying Formulas
Question details
Determine why an Excel workbook becomes large and slow after formulas are copied across a worksheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying simple formulas across a worksheet containing a few hundred rows.
- Observed behavior
- The workbook grows unusually large and becomes slow after formulas are copied.
Note the workbook's file size after saving, then copy a similar formula in a new workbook and save it to compare the results. This helps establish whether the issue is limited to one file or also occurs in other workbooks.
Repair the affected Excel workbook
Use this approach when the size or performance problem occurs in only one workbook.
In Excel, select File > Open > Browse and locate the affected workbook.
Select the workbook, click the arrow next to Open, and choose Open and Repair. Select Repair when prompted.
Copy the formulas again, save the workbook, and compare its file size and responsiveness with the earlier results.
Update Excel and test it without add-ins
Try these checks when multiple workbooks show the same behavior.
Work with spreadsheet formulas in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and compatibility with common Excel formats, making it easier to move existing files into a different office suite. It does not repair the Microsoft Excel application.
Frequently Asked Questions
How can I tell whether the problem is specific to one workbook?
Create a new workbook in Excel, copy a similar formula across a comparable range, and save it. Compare its size and responsiveness with the affected workbook.
Where is Open and Repair in Excel?
Select File > Open > Browse, select the workbook, and click the arrow next to Open. Choose Open and Repair, then select Repair.
How do I start Excel in Safe Mode?
On Windows, close Excel, press Windows+R, type excel /safe, and select OK. Safe Mode helps you test Excel without normally loaded add-ins.
What should I do if several workbooks have the same problem?
Update Office through File > Account > Update Options when available. On Windows, test Excel in Safe Mode, check add-ins under File > Options > Add-ins, and repair Office through Settings > Apps if needed.
