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 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

BI & Data Analysis
excel

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Nov 27, 2021

    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)

    • 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