roger190667
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Zwiekhorst
I am using acrobat adobe writer 9 but also happens if i use mirosoft xps document writer
Regards
Roger
I am using acrobat adobe writer 9 but also happens if i use mirosoft xps document writer
Regards
Roger
ASKER
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
on further investigations it seems that when excel finds a sheet with different dpi settings it sees it as a seperate print job
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?
KR
Eric