Erro formatação data na impressão da planilha dinâmica

Copper Contributor

Olá!

Anexos: 1) Planilha, 2) Impressão em PDF, 3) Imagem erro (JP|G), 4) Vídeo seleç

Procedimento: Selecionar área a imprimir conforme vídeo e PDF > Imprimir > Em Configurações definir Imprimir Seleção > Em Configurações Ajustar Todas as Colunas em Uma Página 

 

Erro: Na impressão Campo Data Entrega na segunda página não repete a formatação de Data < Vide Solicitação de Compra Komitto (temp).jpg

3 Replies

@aldyoda 

I converted the Excel file into a pdf file with the command Export

and executed with the command Print (printer selection: Microsoft Print to PDF).

Opened with Adobe Acrobat Reader DC (the latest version) without any problems.

The problem doesn't repeat itself for me.

Either I do and get something wrong.

You should perform an update beforehand. Save as video and PDF?

Which Excel version and operating system are you using?

 

Thank you for your understanding

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE 

Hi there. Thanks for your reply.

My Excel version is 

Microsoft® Excel® para Microsoft 365 MSO (Versão 2110 Build 16.0.14527.20234) 32 bits

OS Windows 10

So, it seems that the problem persists even using the same process as instructed > Pivot table [Resumo (Fornecedor)]

However, strange is that I've created another pivot table [Resumo] and the problem did not occur.

Attached Excel file and video step by step.

 

Thanks

 

@aldyoda 

Thank you in advance for the video.

I let the workbook run again with me and it works without any problems.

Also attached is the pdf file. Unfortunately I have to say that I tried it on my Excel 2016 Pro.

Do not have the opportunity to try it on 365.
I also tried to research this error on the Internet, but without success.

Unfortunately, I cannot help you any further.
As a final thought, maybe set the print area in advance in each Excel sheet and then export it.

Not sure if this will help, but as a last resort I can give it to you on the way ... maybe it will.

 

Thank you for your patience and understanding

 

NikolinoDE