[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

excel convert to pdf problem

when a new work sheet is added to a multi worksheet document and you then ask it to print to pdf or xps it will stop at that sheet and then you have to convert the new sheet and then carry on to do the rest.
If you copy a sheet and then delete its contents it will convert the whole file with no problems
any idea why you cant just add a new sheet and convert to pdf
  • 2
1 Solution
You can verify in the Layout tab that the new sheet has the same properties like size, margin...
If something is different, it can cause this problem.
Eric ZwiekhorstCommented:
Hi Roger,

I tried this with a 11 sheets workbook, I added a new one, changed the tab name an printed all at once on the PDFcreator printer.
Out came a pdf including the new tab?

Can't reproduce, can you tell me wich PDF convertor you are using?


roger190667Author Commented:
Hi Zwiekhorst

I am using acrobat adobe writer 9 but also happens if i use mirosoft xps document writer


roger190667Author Commented:
This turned out to be in the page layout and the dpi settings.
on further investigations it seems that when excel finds a sheet with different  dpi settings it sees it as a seperate print job

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now