Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Dates Spreadsheet is breaking on export

Answered
Request Demo

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

Comments

2 comments

Date Votes
  • 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

Please sign in to leave a comment.