View original (French)

Timeline bar disappears

Solved
SDINELLE Posted messages 33 Status Member -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -
Hello,

I added a timeline to my pivot table. Strangely, when I save and close my spreadsheet and then reopen it, my timeline disappears. However, I have other worksheets in my spreadsheet that use different timelines and I don't have any issues.

Do you have any idea why I am losing the timeline?

Thank you in advance for your time.

Best regards,

Stephan

5 answers

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Hello everyone,

    Which version of Excel was your file created with?

    Regards
    0
    1. SDINELLE Posted messages 33 Status Member
       
      O365
      0
  2. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Hello Stephan.

    I can't get used to Quebec vocabulary...
    • A "chiffrier" is indeed a binder, right?
    • A "feuille électronique" is just a sheet of binder paper, right?
    • But what is a "barre chronologique"?

    --
    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)
    0
    1. SDINELLE Posted messages 33 Status Member
       
      Hello Raymond :-)

      Yes, it is indeed a workbook and yes, it's just a worksheet. The timeline is an option available under "Pivot Table Analysis" with the O365 version of Excel. This option is called "Insert Timeline."

      /S
      0
  3. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Oh yes!
    I don't have Excel 365; but I do have the "Timeline" tool (which I had never had the chance to use) ...
    And when I save my file and open it again, the bar is still there.
    So I don't see a plausible explanation for what you're observing.
    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
  4. SDINELLE Posted messages 33 Status Member
     
    Thank you, Raymond, for your time :-)

    I simply redid my pivot table. Everything seems to be back to normal now! Strange... It's probably the fault of COVID-19 ;-)
    0
  6. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    ... so that's great: I was annoyed that I couldn't help you out!

    --
    Retirement is nice! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0