Excel 2010 saving as PDF problem

Asked By 0 points N/A Posted on -
qa-featured

Hi guys!

Here is my situation, I have Windows 7 Professional 64-bit setup on three computers with Office 2010 64-bit.

I downloaded and installed Adobe Reader X on those computers. When I make a new Excel 2010 worksheet, I don't have any problem saving as a PDF, as well as other "simple" worksheets. In an Excel 2010 worksheet with multiple tabs, I need to save one tab to PDF file. 

But then, I get this error message: Microsoft Excel–Document not saved. The document may be open, or an error may have occurred when saving. Then after trying to save a few times, it appeared to work.

However, when I tried to open the saved PDF file, I receive this error: Adobe Reader -There was an error opening this document. This file cannot be opened because it has no pages. I have uninstalled/reinstalled Adobe Reader X. No change. Any help please.

SHARE
Answered By 0 points N/A #144490

Excel 2010 saving as PDF problem

qa-featured

Dear Madam,

I have some solutions for your problem.

The solutions are as follows:-

Solution: 1

In this solution we will look at using the Save and Send option located under the File tab of the ribbon.

The Save and Send option gives you two choices for creating a PDF document:

  1. Save all or a portion of a workbook in PDF format.
  2. Email a copy of the entire workbook without saving it first.

Save Excel Files to PDF Format:

For help with these steps, see the image to the above.

  • Open an Excel file that you want to convert to PDF format.
  • Click on the File tab of the ribbon to view the available options.
  • Click on Save and Send in the menu to view the options available.
  • Click on Create PDF / XPS Document under the File Types options.
  • Click on the Create a PDF / XPS button on the right hand side of the window to open the Publish as PDF or XPS dialog box.
  • Even though Microsoft call this publishing the document in PDF format, you are in fact just saving the file.
  • As with any other file being saved, you can specify a file name and a location before publishing the file.
  • If you publish the file as is, only the current worksheet will be published.
  • To publish multiple sheets in the worksheet, highlight the tabs of the worksheets to publish before creating the PDF file.

Solution: 2

Convert Excel Files to PDF Using the Save and Send Option.

There are several methods for converting Excel files to PDF format in Excel 2010. In this tutorial we will look at using the Save and Send option located under the File tab of the ribbon.

The Save and Send option gives you two choices for creating a PDF document:

  1. Save all or a portion of a workbook in PDF format.
  2. Email a copy of the entire workbook without saving it first.

Email Excel Files in PDF Format:

Note: You must have an email program, such as Microsoft Outlook, installed on your computer for this option to work.

  • Open an Excel file that you want to send via email in PDF format.
  • Click on the File tab of the ribbon to view the available menu options.
  • Click on Save and Send in the File menu to view the options available.
  • Click on Send Using E-mail under the Save and Send options.
  • Click on the Send as PDF button on the right hand side of the window.
  • Excel will open a new email message window. A copy of your workbook will be attached to the message in PDF format.
  • All pages of the workbook will be added to the PDF file. If you wish to exclude one or more worksheets of the workbook before converting it to PDF format, hide the worksheets you don't want to send before following steps 2 to 6 above.
  • Complete the To line in the email message.
  • Send the message.

Solution: 3

Email Excel Files in PDF Format:
1. Click the File tab and choose Save As.
 
The Save As dialog box appears.
 
2. In the Navigation pane, select the folder in which you want to save the file.
 
(Optional) If you want to save the workbook file inside a new subfolder within the folder currently open in the Save As dialog box, you can click the New Folder button on the toolbar and then type the name of the folder and press Enter.
 
3. Type a descriptive name for the file in the File Name box.
 
You can use the original name if you want so that your original Excel file will appear right next to the PDF or XPS file in an alphabetical list.
Type a descriptive name for the file in the File Name box.
4. Click the Save as Type arrow and select either PDF or XPS Document.
 
Excel displays additional options that apply to PDF and XPS files near the bottom of the Save As dialog box.
Click the Save as Type arrow and select either PDF or XPS Document.
5. Beside the Optimize For heading, select Standard or Minimum Size.
 
If you want to make the PDF or XPS file as small as possible (because your worksheet is large), select the Minimum Size (Publishing Online) option button.
Beside the Optimize For heading, select Standard or Minimum Size.
6. (Optional) If you want to change which parts of the workbook are saved in the PDF or XPS file, click the Options button; then make the appropriate selections and click OK.
 
From the Options dialog box, you can change how much of the worksheet to convert as well as including the document properties in the output.
 
7. Click the Save button.
 
Excel saves the workbook in the PDF or XPS file format that you selected in Step 4, and automatically opens the file in Adobe Reader or XPS Reader (unless you deselected the Open File After Publishing check box in the Save As dialog box).
Answered By 590495 points N/A #306627

Excel 2010 saving as PDF problem

qa-featured

If that’s how you save your Microsoft Office Excel file into PDF, that will cause the application to save all the tabs not just one into PDF format. If you have a Microsoft Office Excel worksheet that contains multiple tabs and you need to save only one tab into PDF, here’s one way. Start Microsoft Office Excel then load your Office Excel worksheet.

Next, select the tab you wish to save into PDF format. Once the tab is selected or activated, click on the Office button then move the mouse over “Save As” and then select “PDF or XPS.”

Save sheet into PDF

On the “Publish” screen, click “Options.” On the “Options” dialog, under “Publish what,” make sure “Active sheet(s)” is selected then click “OK” and then “Publish”.

Select active sheet

This should save the current Office Excel tab into PDF format.

Related Questions