|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

Dates Spreadsheet is breaking on export

Udzielono odpowiedzi
Zamów wersję demonstracyjną

Hi - A few days ago I exported a spreadsheet to excel and there is a Master Dates tab where we input the current year ("2024" in this case) and the formulas create period header formats for use throughout the rest of the workbook.  Earlier this week the excel export was fine and everything flowed through properly but for whatever reason today all the formulas that are based on the "2024" input in Workiva are showing as "#VALUE" and breaking all the date values throughout the workbook downstream. I tried changing the format in Workiva to number (it was on Period before) and it still exports as broken. 

I am working around this for now by copying over the dates page with the file that I exported earlier this week but it would be nice to not have this break when I export a spreadsheet. Please let me know if there is anything I should do on my end to prevent this breaking.  

Thanks, 

--Jhoanne

0

Komentarze

Komentarze: 2

Data Głosy
  • jho

    Ok sorry - spoke too soon. Must have been a Microsoft issue because I reopened the same file that was broken before and it seems to be working now for some reason. Feel free to please close this if it created a support ticket on the back-end. Thank you!

    0
  • Mike Davis

    Thanks for sharing this, Jho, and for the follow-up. Glad to hear this is working. All is good on our end but give us a holler if this issue arises again or you need anything.

    0

Zaloguj się, aby dodać komentarz.