View original (French)

Timeline bar disappears

Solved
SDINELLE Posted messages 33 Status Membre -  
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur 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 réponses

Réponse 1 / 5
DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   716
 
Hello everyone,

Which version of Excel was your file created with?

Regards
0
SDINELLE Posted messages 33 Status Membre
 
O365
0
Réponse 2 / 5
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
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
SDINELLE Posted messages 33 Status Membre
 
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
Réponse 3 / 5
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
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
Réponse 4 / 5
SDINELLE Posted messages 33 Status Membre
 
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
Réponse 5 / 5
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
... 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