Why is Excel print preview slow?

Published by Charlie Davidson on

Why is Excel print preview slow?

One of the reasons print preview, and also changing page setup properties, can get painfully slow is (and most users don’t know this) that Excel checks the print driver to see if the printer supports all your pagesetup properties.

Why is Excel taking so long to print?

For some reason Excel files which have been under 1MB are spooling 14MB to over 100MB in size which is why they are taking so long to print.

How do I fix print preview in Excel?

Preview worksheet pages before you print

  1. Select the worksheet(s) you want to preview.
  2. Click File, and then click Print to display the Preview window and printing options. Keyboard shortcut You can also press Ctrl+F2.

Why is Excel print preview different?

When you print or switch to Print Preview, fields are updated. It appears that there are some fields in your document that are causing the layout to change. When you print or switch to Print Preview, fields are updated. It appears that there are some fields in your document that are causing the layout to change.

How do I speed up print preview?

How To Increase Print Speed

  1. Check the Connection. Printing wirelessly is incredibly efficient, helping a larger number of users benefit from the technology.
  2. Reduce Print Quality.
  3. Increase the RAM.
  4. Reduce the Number of Pages.
  5. Bypass the Spooler.
  6. Clear Legacy Print Jobs.
  7. Update and Upgrade.

Why is my Excel file not printing correctly?

If your Excel spreadsheet isn’t printing properly, clearing or setting a print area can often help. Sometimes the wrong print area has already been set, in which case you want to clear it. To do this from the Page Layout Ribbon, click the Print Area icon and select Clear Print Area.

Why does Excel print blank pages?

The answer is that Excel merely prints out the cells shown in print preview mode, and if you’re printing blank pages, you’ve selected too many cells, or kept them too wide and forced Excel to print the range specified.

What is a print preview?

Print Preview is a functionality that lets users see the pages that are about to print, allowing the users to see exactly how the pages will look when they are printed.

How do I fix loading preview?

Disable Google Chrome print preview on Window

  1. Step 1: Open regedit.
  2. Step 2: Go to Computer\HKEY_CURRENT_USER\SOFTWARE\Policies\Google\Chrome or Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Google\Chrome.
  3. Step 3: Add DisablePrintPreview REG_DWORD with value 1.
  4. Step 4: Restart Google Chrome.

Why is Excel 2016 so slow to print?

We set the same printer that we were trying to print to before as the default. Afterward, Excel 2016 loaded the print window with a “print preview” button rather then rendering the print preview on the page.

Why is print preview so slow on my computer?

If the network is slow the wait time can be very long. One way to get around this is therefore to switch to a local printer (one connected directly to a printer port). If you are already on a local printer, it may be a problem related to your printer interface or the printer itself.

Why does excel take so long to print?

If we pressed that button, Excel would pause for about 45-60 seconds to render the print preview but if we did press that button, printing would happen right away. I’m not really sure that I can call that good troubleshooting, but it did resolve the issue for the end user.

Categories: Contributing