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

%3CLINGO-SUB%20id%3D%22lingo-sub-3010481%22%20slang%3D%22pt-BR%22%3EError%20formatting%20date%20in%20dynamic%20worksheet%20printing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010481%22%20slang%3D%22pt-BR%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EAttachments%3A%201)%20Spreadsheet%2C%202)%20PDF%20Printing%2C%203)%20Image%20error%20(JP%7C%20G)%2C%204)%20Video%20selec%3C%2FP%3E%3CP%3EProcedure%3A%20Select%20area%20to%20print%20as%20a%20video%20and%20PDF%20%26gt%3B%20Print%20%26gt%3B%20In%20Settings%20set%20Print%20Selection%20%26gt%3B%20In%20Settings%20Adjust%20All%20Columns%20on%20A%20Page%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EError%3A%20In%20Printing%20Date%20Delivery%20Field%20on%20the%20Second%20Page%20Does%20Not%20Repeat%20Date%20Formatting%20%26lt%3B%20Vide%26nbsp%3BSolicita%C3%A7%C3%A3o%20de%20Compra%20Komitto%20(temp).jpg%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3010481%22%20slang%3D%22pt-BR%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3011365%22%20slang%3D%22en-US%22%3ERe%3A%20Erro%20formata%C3%A7%C3%A3o%20data%20na%20impress%C3%A3o%20da%20planilha%20din%C3%A2mica%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011365%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1161259%22%20target%3D%22_blank%22%3E%40aldyoda%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EI%20converted%20the%20Excel%20file%20into%20a%20pdf%20file%20with%20the%20command%20Export%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Eand%20executed%20with%20the%20command%20Print%20(printer%20selection%3A%20Microsoft%20Print%20to%20PDF).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EOpened%20with%20Adobe%20Acrobat%20Reader%20DC%20(the%20latest%20version)%20without%20any%20problems.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThe%20problem%20doesn't%20repeat%20itself%20for%20me.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EEither%20I%20do%20and%20get%20something%20wrong.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EYou%20should%20perform%20an%20update%20beforehand.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ESave%20as%20video%20and%20PDF%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EWhich%20Excel%20version%20and%20operating%20system%20are%20you%20using%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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