Office Performance Issues

Fix Excel Workbook Opening Delays at 40% and Accessing Printer

Huda QurayshiHuda Qurayshi Nov 18, 2026 868 views

Question details

Find the cause of a delay when opening a macro-enabled Excel workbook.

Fix Excel Workbook Opening Delays at 40%
Product
Microsoft Excel
Device & OS
not provided
Scenario
A macro-enabled workbook pauses during opening after workbook changes.
Observed behavior
Excel pauses near 40% and displays an "Accessing printer" message.
Before you start

Note which sheets, rows, or columns were changed before the delay began, and check whether the affected areas are hidden or visible. Have access to the printer used by the workbook or another available printer for testing.

Solution 1Recommended

Check the visibility and formulas in affected cells

Use this approach if the delay began after changing the visibility of a large range of cells.

In the reported case, unhiding a large number of cells, including cells with formulas, caused the pause; hiding them again restored faster opening. This may not be the cause in every workbook.

1
Identify the changed range

Open the workbook and review the sheets where rows or columns were recently unhidden or changed. Look for large visible ranges containing formulas or unnecessary data.

2
Hide the affected rows or columns

Select the affected row or column headers, right-click, and choose Hide. Avoid unhiding every row or column at once while testing.

3
Save and reopen the workbook

Choose File > Save, close the workbook, and reopen it from File > Open. Check whether it passes 40% more quickly.

4
Review the range if needed

If hiding the range helps, inspect smaller sections using Home > Format > Hide & Unhide. Review their formulas and data before making further changes.

Check the visibility and formulas in affected cells
Keep testing targeted: Hiding cells can improve opening time in this scenario, but it does not remove formulas or prove that cell visibility is the only cause.
Free Microsoft Office alternative

Try WPS Office for everyday spreadsheet work

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format support can help you move existing files into WPS, although it does not repair Excel's printer settings or guarantee identical macro behavior.

Open and edit spreadsheets in a familiar interfaceSupports Microsoft Excel formats such as XLSX and XLSMReview worksheet data, formulas, and print settingsMove everyday spreadsheet work from Microsoft Office with less disruption
microsoft office alternative - wps office

Frequently Asked Questions

Can hidden cells cause an Excel workbook to open slowly?

Cell visibility can affect performance, but the result depends on the workbook. In this case, unhiding a large formula-containing range caused the delay, while hiding it again improved opening time.

Why does Excel show "Accessing printer" while opening a workbook?

Excel may be processing the default printer, driver, or workbook print settings. Test another default printer in your device's printer settings and review Page Layout > Print Area and Page Setup.

How can I find macros that run when the workbook opens?

Open Developer > Visual Basic, select ThisWorkbook, and look for a Workbook_Open procedure. Review any code that accesses printers, print settings, or external files.

Where can I check links to other workbooks?

In Excel, open Data > Edit Links or Data > Workbook Links, depending on your version. Check whether the linked files are available before updating or removing a link.

Will an XLSM workbook behave the same way in WPS Office?

WPS Office supports the XLSM format, but macro support and behavior can differ from Excel. Test any important macros and print workflows before relying on the workbook in WPS.