Dates Spreadsheet is breaking on export
답변함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
-
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
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댓글을 남기려면 로그인하세요.
댓글
댓글 2개