Missing pages when PDF entire workbook

[tomlondon]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi Guys

I have an Excel query that is baffling me. I have a workbook with 46 sheets. When I go to PDF them, I choose "Entire Workbook", preview shows 46 pages so I select my folder and let it do the work.

No matter what happens it will only do 38 individual PDF's, and every time.

I have tried selecting a different printer, deleting a sheet that wont PDF and recreating it, renaming a sheet that wont PDF, PDF a selection and nothing seems to work.... other than PDF'ing the missing sheets manually. But that is not a solution

I am using the latest version 12.2.3 and everything else I do works fine, never any crashes or glitches.

Any help would be greatly appreciated

Thanks
Tom

 

[CyberTaz]

I don't recall ever having heard of anything like this, but outputting the
content of 48 worksheets is rather unusual You do mean 'sheets' and not
'pages', right?

Is it always the same sheets that aren't included or does it vary each time
you try? Are they the last 8 that are missing? The first 8? Every other
sheet omitted?

Have you tried using File>Save As - PDF (form the Format: dropdown)?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[tomlondon]

Apologies, yes sheets.

It was always the same 8 and they were randomly placed. However the File - Save As method worked perfectly, thank you so much.

Still, quite strange why the print pdf method fails but Im happy it is resolved

 

[CyberTaz]

The 2 methods employ different generator engines - the one is supplied by
Apple, the other is supplied by Microsoft. Even though they are both
licensed from Adobe the are somewhat different.

--
Regards |:>)
Bob Jones
[MVP] Office:Mac

Apologies, yes sheets.

It was always the same 8 and they were randomly placed. However the File -
Save As method worked perfectly, thank you so much.

Still, quite strange why the print pdf method fails but Im happy it is
resolved