Báo lỗi we didnt find anything to print năm 2024

Today, a tired coworker called me in to help her solve a printing problem. There was an instance of Microsoft Excel 2016 [perpetually licensed on Windows 7] with a worksheet on the screen. The print preview showed an accurate representation of what we wanted to print.

Screenshot: Microsoft Excel 2016 print preview mode [Image from TechAdvisor.co.uk because it didn’t occur to me take screenshots of the problem]

However, while the desired output had made it to the preview screen, it would not make it to the paper. Instead, Microsoft Excel displayed an error message:

We didn’t find anything to print.

Screenshot: Microsoft Excel 2016 error message [Image from Superuser.com]

Unable to make head or tail from the error message, I searched the Internet for it, but the only thing this search yielded was the images you see in this article.

After trying various things, such as setting, clearing, enabling, and disabling the print area, testing other printers [all of which were virtual, like Adobe PDF], I decided to close Excel.

Upon re-opening the document, Excel generated another error message that my co-worker had fail to mention:

The file format and extension of ‘1.xls’ don’t match. The file could be corrupted or unsafe. Unless you trust its source, don’t open it. Do you want to open it anyway?

I order Windows 7 to display the filename extensions and renamed the file to “1.xlsx”. [Notice the “x” at the end.]

On the first tab titled "LobbyTimeDetail", I am not able to print any pages past page 46. This first tab is a pivot table. I have checked the print range but pages 47-83 are in the print range. These pages also do not show up under print preview. I can print when I highlight a single page and "print selection" but I am not able to print the specific page using print range from the print prompt without getting the error. Has anyone encountered this issue? Any ideas on how to fix?

-Matt

Last edited by mattgentz; 08-08-2013 at 03:58 PM.Reason: Issue Resolved

• 08-08-2013, 01:35 PM

  Re: "Microsoft Office Excel did not find anything to print" - printing error

  Welcome to the Forum mattgentz!

I downloaded your file and was able to see all 83 pages on Print Preview, and was able to print all 83 pages without changing any settings [to a PDF file].

I do not know what could cause your problem, other than something about your printer setup. What type of printer are you trying to print to? Do you have any other printers/devices you can try? Last edited by 6StringJazzer; 08-08-2013 at 01:37 PM.Reason: clarified reference to "preview" Jeff

�

�

�

�

:

�

�

Read the rules

Use code tags to [code]enclose your code![/code]

-

• 08-08-2013, 02:17 PM
  Registered User
  -

  Re: "Microsoft Office Excel did not find anything to print" - printing error

  This error does not occur on Excel 2010. It only occurs on Excel 2007. Can somebody using 2007 give this a try?

  -
• 08-08-2013, 02:23 PM

  Re: "Microsoft Office Excel did not find anything to print" - printing error

  i confirm i see all 83 in the workbook but print preview only shows 46 in 2007

  - 08-08-2013, 02:55 PM

  Re: "Microsoft Office Excel did not find anything to print" - printing error

  but if i change from letter to 55% size i see all of them in print preview

  08-08-2013, 03:57 PM
  Registered User
  -

  Re: "Microsoft Office Excel did not find anything to print" - printing error

  Awesome. That does solve my issue. Thanks a ton for your help.

  - 01-10-2014, 05:13 AM
  Registered User
  -

  Re: "Microsoft Office Excel did not find anything to print" - printing error

  I have the same message and find a solution:

Just right-click on the worksheet tab. Then click "Move or Copy..." On the next window click "Cancel" That's all ! When go to "Print preview" you can see worksheet data and print normally.

- 02-17-2014, 09:14 PM

Registered User

-

Re: "Microsoft Office Excel did not find anything to print" - printing error

I couldn't make the % change work, but greenn's trick solved the puzzle with two easy clicks. Thanks!

- 05-11-2020, 10:19 AM

Registered User

-

Re: "Microsoft Office Excel did not find anything to print" - printing error

Error Message: Microsoft didn�t find anything to print.

When you click on �Print� in Excel you will get the print dialog window. Make sure that the page selection [i.e., 2-2 or 3-5] numbers are cleared. If it is not cleared and you want to print a highlighted selection at the same time that you have page numbers in place you will get the error message shown above. The printer does not know what you want; specific page numbers or the selection.

You can�t have it both ways. It is one or the other, printing specific page[s]; or printing a selection.

Microsoft should have detected this conflict and made the error message more meaningful.

- 05-11-2020, 11:05 AM

Re: "Microsoft Office Excel did not find anything to print" - printing error

Originally Posted by MaskedLoneRanger02 Error Message: Microsoft didn�t find anything to print. When you click on �Print� in Excel you will get the print dialog window. Make sure that the page selection [i.e., 2-2 or 3-5] numbers are cleared. If it is not cleared and you want to print a highlighted selection at the same time that you have page numbers in place you will get the error message shown above. The printer does not know what you want; specific page numbers or the selection. You can�t have it both ways. It is one or the other, printing specific page[s]; or printing a selection. Microsoft should have detected this conflict and made the error message more meaningful. You have responded to a question that is 7 years old and has been solved. Please have a look at some of our new posts to see where folks need help. Given that we have had three members post their first [and so far, only] posts here after the thread was marked SOLVED, I am going to close this.