クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

Restore spreadsheet

回答済み
0

コメント

3件のコメント

  • Jenna Pettyjohn
    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
  • Isabella Ho
    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
  • Jenna Pettyjohn
    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 :)
    0

サインインしてコメントを残してください。