Printer troubleshooting technician providing live chat help

Joe B.

Expert ★★★★★ 27,853 satisfied customers

Specialities: Excel printing errors, #VALUE! troubleshooting, Page Setup & “Cell errors as”, Windows print spooler reset, driver/queue cleanup

Excel prints #VALUE! / print preview shows errors — Calculation options, Evaluate Formula, “Cell errors as” & spooler cache reset

Technician avatar Technician
Hey! We’ll stop Excel from printing **#VALUE!**. Quick scan first:
• Excel version (Microsoft 365/2021/2019) and OS (Windows/macOS).
• Does **Print Preview** already show #VALUE!, or only the physical printout?
• Are formulas pulling from other sheets/CSV/queries? Any **Manual calculation** mode?
• Printer model/connection (USB/Wi-Fi) — we may reset the **print spooler cache** if needed.
Customer
Windows 11 with Microsoft 365. Preview sometimes shows real numbers, but paper prints **#VALUE!** on a few cells from a SUMIFS sheet. Calc mode might be Manual; workbook is big. Network HP printer.
Technician avatar Technician
Got it. You’re likely seeing a mix of **stale calculations** and **print rendering** settings:
1) **Manual/Delayed calc** leaves some cells unresolved at print time, so Excel renders **#VALUE!**.
2) The **Page Setup → Sheet → Cell errors as** setting can force errors to print (Displayed/Blank/–/#N/A).
3) A stuck **print queue/driver cache** can print an old page image.
We’ll fix by forcing a full recalculation, setting “Cell errors as: **<blank>**” (or dashes), then clearing the **spooler**.
Customer
Where do I check calculation and that “Cell errors as” thing?
Technician avatar Technician
Step 1 — Turn on Automatic & rebuild calc dependency tree
• Go Formulas → Calculation Options → select **Automatic** (not Manual).
• Press **F9** (recalc active sheet). If issues persist, press **Ctrl+Alt+F9** to recalc all sheets; then **Ctrl+Alt+Shift+F9** to rebuild dependencies and recalc everything (deep refresh).
• For cells still showing **#VALUE!**, use Formulas → Evaluate Formula to see where text/space/non-numeric data breaks SUM/SUMIFS/PRODUCT.
• Common fixes: wrap inputs with **VALUE/NUMBERVALUE**, strip non-breaking spaces with **CLEAN**/**SUBSTITUTE**, or guard with **IFERROR**.
Customer
Found text numbers from a CSV. Cleaned them, preview now shows numbers. How do I stop printing any remaining errors?
Technician avatar Technician
Step 2 — Control how errors print
• Open Page Layout → Print Titles (opens Page Setup) → Sheet tab → **Cell errors as:** set to **<blank>** (or **–** / **#N/A** if you prefer).
• This prevents **#VALUE!** from appearing on paper while you finish cleanup.
• Also verify **Print Area** and scaling (Fit to 1 page) so the affected cells aren’t being rasterized oddly.
Customer
Good. Printing is better, but one tab still spits old content as if cached by the printer.
Technician avatar Technician
Step 3 — Reset Windows print cache (spooler)
1) Close Excel and cancel stuck jobs in **Settings → Bluetooth & devices → Printers & scanners → [Your printer] → Open print queue** → Clear all.
2) Press Win+R → type services.msc → find **Print Spooler** → **Stop**.
3) Go to C:\Windows\System32\spool\PRINTERS and delete contents (admin rights).
4) Start **Print Spooler** again → reopen Excel → **Ctrl+Alt+F9** once more → print.
Optional: update the printer driver and ensure **Draft quality** isn’t forced in the driver’s Printing Preferences.
Customer
After the spooler reset, prints are clean. Any best practices so #VALUE! doesn’t return when we refresh data?
Technician avatar Technician
Step 4 — Make your workbook error-tolerant
• Wrap fragile formulas with **IFERROR** (e.g., =IFERROR(SUMIFS(...),0)) to avoid transient **#VALUE!** during refresh.
• Normalize imports: apply **VALUE/NUMBERVALUE**, **DATEVALUE**, and strip spaces with **TRIM/SUBSTITUTE/CLEAN** on staging columns.
• Keep **Calculation Options = Automatic**, and before printing press **Ctrl+Alt+F9** for a full refresh.
• Keep **Page Setup → Cell errors as: <blank>** as a safety net for printouts.
Customer
What if we actually want dashes where errors were, but blanks elsewhere?
Technician avatar Technician
Two layers you can combine:
• **On paper**: Page Setup → **Cell errors as: –** to print dashes for any remaining errors.
• **In cells**: use =IFERROR(your_formula,"-") so the worksheet shows a dash, which also prints consistently.
Tip: For PivotTables, use **For error values show:** in Options to control display separately.
Customer
One last thing: can Preview show values but the printer still output #VALUE!?
Technician avatar Technician
Yes — when the **driver/queue cached** an earlier job or the workbook recalculated between preview & print. That’s why we:
1) Force **Calculate Full/Rebuild** before printing.
2) Clear the **spooler** on stubborn queues.
3) Print to **PDF** once; if PDF looks correct, the issue is downstream (driver/firmware/queue).
Customer
Done — recalculation + “Cell errors as: <blank>” + spooler reset fixed it. Thanks!
Technician avatar Technician
Summary: Set **Automatic** calculation, force **Ctrl+Alt+F9** (and **Ctrl+Alt+Shift+F9** if needed), fix data types, then in **Page Setup → Sheet → Cell errors as** choose **<blank>** or **–**. If paper still shows old content, **clear the print queue/spooler cache** and retry. Need help tuning SUMIFS/IFERROR so reports always print cleanly? Open the chat.

Quick answer: the accepted fix

Accepted fix when Excel prints #VALUE!: switch to **Automatic** calculation and force a full recalculation (**Ctrl+Alt+F9**, deep rebuild with **Ctrl+Alt+Shift+F9**). In Page Setup → Sheet, set **Cell errors as: <blank>** (or **–/#N/A**). If the printer outputs stale pages, **clear the Windows print spooler cache** and reprint.

Why #VALUE! appears on paper (calc mode, data types & print pipeline)

Excel’s **#VALUE! error** often comes from text-numbers, stray spaces, or CSV imports. When **Manual calculation** or pending queries leave cells unresolved at print time, the print renderer can output the error string even if the grid later recalculates. Use **IFERROR**, **VALUE/NUMBERVALUE**, **TRIM/CLEAN/SUBSTITUTE**, and **Evaluate Formula** to normalize inputs; then rebuild calculations before printing.

How to verify clean output (no #VALUE!)

Before final runs: press **Ctrl+Alt+F9**, preview, then print to **PDF** and to paper. In **Page Setup → Sheet**, ensure **Cell errors as** matches your policy (Blank/–/#N/A). If paper differs from PDF, reset the **print queue**, re-select the driver, and try a fresh print. Keep **Print Area** tidy and check scaling to avoid rasterization quirks.

#VALUE! on printouts — quick troubleshooting tips

Most cases are stale calc + Page Setup + queue cache.

Quick path: **Automatic** calc → **Ctrl+Alt+F9** (optionally **Ctrl+Alt+Shift+F9**) → clean text-numbers → **Page Setup: Cell errors as = <blank>** → clear printer **spooler** → test to PDF. This resolves the majority of Excel prints #VALUE! issues on Windows 10/11 and Microsoft 365.

Disclaimer: This information is AI-generated and intended for general guidance only. For advice specific to your environment, please consult a verified expert on Whizz-Tech before making decisions.

Getting Started Is Easy

Ask for help, 24/7

Members enjoy round-the-clock access to 12,000+ verified Experts, including tech support, mechanics, vets, and more.

Expert will respond in minutes

We match you with an Expert who specializes in your situation. Talk, text, or chat — whichever you prefer.

Save time & money

No scheduling hassles or expensive consults. Membership can save you significant time and money each month.

FAQ

Why does Excel print #VALUE! even when the worksheet shows numbers?

Manual/partial calculation and stale dependencies can leave cells unresolved at print time. Force a full rebuild (**Ctrl+Alt+F9**, then **Ctrl+Alt+Shift+F9**), fix text-number inputs, and control **Page Setup → Cell errors as**.

How do I stop #VALUE! appearing on paper, fast?

Set Formulas → Calculation Options to **Automatic**, then in Page Setup → Sheet choose **Cell errors as: <blank>** or **–**. If output is stale, clear the Windows **print spooler** and reprint.

What formula fixes help with #VALUE!?

Use **IFERROR** to mask transient errors, **VALUE/NUMBERVALUE** to coerce text-numbers, and **TRIM/CLEAN/SUBSTITUTE** to remove stray characters. Use **Evaluate Formula** to trace failing parts.

Preview is correct but the printer shows #VALUE!. What now?

Clear the print queue, restart the **Print Spooler** service, and delete cached files in C:\Windows\System32\spool\PRINTERS. Print to PDF to confirm Excel is rendering correctly, then try paper again.

Sources

Matt Verified Icon
Matt ● replies in < 1 min
Technician Expert
⭐⭐⭐⭐⭐ Trusted by 27,000+ customers
Avatar
Alex · Expert's Assistant
5 Tech Support Specialists are online right now.