Restore spreadsheet
Con rispostaAfter uploading a worksheet from Excel, the Workiva spreadsheet read some cells that did not have values and then overlayed some formulas I had that were only in the Workiva spreadsheet (the excel file is used only as a data input and formulated values are in Workiva). I do not want to recreate all the formulas again. Is there a way to restore the spreadsheet prior to the upload?
0
-
Hey Isabella!
I'm not sure I am fully understanding your question, but let me give it a shot. Unfortunately, you cannot just revert to a previous revision. What you can do is copy/paste from your history.
It sounds like you imported an excel sheet with values, and the import wrote over some of the values; have you tried locking cells to prevent the over-write? I think your best bet is going to be copy your files from a previous revision and paste into the current revision, or perhaps run another import.
Did that assist at all?0
Thanks Jenna. If I lock the cells in Workiva, will that prevent values from being over-written when I import the data? For example, cell A1 has the number 1, cell A2 has the number 2, and cell A3 has a formula A1 + A2. My excel file only has data in cell A1 and A2. For some reason, Workiva thinks that A3 which is blank has the value 0 in it. When imported into Workiva, cell A3 which should remain a formula, is overwritten with the number 0. If I locked cell A3 in Workiva, would that prevent the cell A3 from being overwritten in the future? 0
Isabella,
I went ahead and tested this out quick on my end! What I found was that when I locked cells that had numbers in them (I did 1, 2, and then the sum of 1+2), locked them, and then I was on Cell A1 when I imported and said replace values-- it dropped the info into the next column!
Hope this sheds more light for you :)0Accedi per aggiungere un commento.
Commenti
3 commenti