Excel tab selection to PDF

[meso100]

Hi

I have selected 17 tabs (that contain line graphs) and saved to PDF, clicked options, selected the "selection" option and when it converts to PDF and opens there are 17 blank pages.

If I select "entire workbook" this converts fine, it just doesn't seem to work on a selection.

Is there something I am doing wrong here?

(Excel 2010)

Thanks

 

[Andrew Poulsom]

Welcome to MrExcel.

Did you select the appropriate range on the active worksheet?

 

[meso100]

Thanks Andrew

I selected each tab by pressing ctrl and left clicking the mouse. Then:

Save As
Save As Type = PDF
Optimize For = Standard

Options

Page Range = All
Publish What = Selection
Include Not Printing Information
Document Properties = tick
Document structure tages for accessibility = tick

I have also tried a quick test by selecting the number 2 and 3 tab (instead of the 17 tabs) which I assume would be page 2 and 3. I changed the range to page 2 and 3 and still a blank PDF is generated.

Is there something I am doing obviously wrong here?

 

[Andrew Poulsom]

Selection refers to the selected range not to the selected sheets. So select the range you want to print. If you want to print the used range on the Active sheets check that.