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.
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:
Save all or a portion of a workbook in PDF format.
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:
Save all or a portion of a workbook in PDF format.
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
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.
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.
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.
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).
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.
Have you ever wished you could access your important documents anytime, anywhere? With cloud document storage, that wish becomes a reality. In today’s fast-paced world, secure and accessible document management is more essential than...
Are you worried about data you lost during some operation on your Windows 11? Don’t worry; we are here to guide you on how to recover the lost data from your Windows device in...
Lead generation and demand generation are two of the business strategies that help businesses grow. It creates a pipeline of interested customers looking to find out more. Lead generation on the contrary, is able...
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
