Forum Discussion

aldyoda's avatar
aldyoda
Copper Contributor
Nov 27, 2021

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

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 Sel...
BI & Data Analysis
excel
aldyoda's avatar
aldyoda
Copper Contributor
Dec 01, 2021

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

 

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Dec 01, 2021

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