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

Accidentally deleting a sheet/tab from Wdesk Spreadsheet and solution

回答済み
デモをリクエスト
A member of my team recently accidentally deleted a sheet from our Wdesk Spreadsheet. This sheet had the ledger pull information for reporting segments and contributed to about 10% of our 10-Q. All sections of our 10-Q and 8-K where the segment information was disclosed turn into excel error symbols. My team freaked out, but I had confidence in Wdesk and believed there should be a way to resolve the issue. Even though the Wdesk Spreadsheet needs a lot of enhancements such as Discard button and excel shortcuts, it is by far, the most intelligent spreadsheet out there. I told my team to create a sheet with a name exactly as the one deleted. After the sheet was created, we synced the ledger pull again. After syncing the data, I asked my team to go to the tab that summarizes all the segment information, which still had the error symbols, and to select the entire data for deletion. After that, we hit the Redo button and the summary sheet intelligently reconnected to the segment ledger pull sheet. All errors disappeared. Thanks Workiva, keep developing the Wdesk Spreadsheet. 
0

コメント

7件のコメント

日付 投票
  • Mike
    Wow Frank, you've got mad skills!

    I have shared with the team that works on Spreadsheets and they were equally impressed and flattered. The team also said they are working on the ability to undo a sheet removal, so keep your eyes peeled there. Thanks again for sharing, and for the kind words. Stay awesome!
    0
  • Carmelli Marifosque

    Hi Mike! Do we have this capability to undo sheet removal already? 

    1
  • Anthony Miller

    Would be interested in this feature as well! Would also be great if in the history panel, you could see specific changes that were made and undo those specific changes. Also, sometimes when I enter a spreadsheet without making an edit just to view it creates new update in the history panel as if I made an edit. Do you know why this behavior occurs and if there's a way to prevent this?

    0
  • Mike

    Hi Carmelli Marifosque!

    Currently you are still unable to undo a sheet removal in a Spreadsheet. I'll be sure to add you to the ongoing request for this feature. As a side note, when you go to remove a sheet, you do receive a pop-up that it cannot be undone:

    Regarding you additional questions Anthony Miller, one possible solution to undoing a change would be to enable Track Changes, which would allow you to accept or reject changes to your document. Outside of that, I'm not aware of any work being dong on a feature such as you describe, but I have shared your feedback with our Product Team to further review.

    I'm asking around with our Spreadsheets experts about the history panel updates question to see what's expected there or not and I'll get back to you there. In the meantime, let me know what questions you have or if you need anything else.

    Chat soon!

    0
  • Mike

    Anthony Miller quick follow-up here on the revisions you are seeing in your Spreadsheet history. This should not happen unless you are performing some sort of action. For example, a revision would not occur by just opening the properties panel, but it would if you changed the properties of some cell or something like that. Also, are you adding comments? If so, adding a comment also prompts a new revision.

    Let me know if you have any questions on the above or need anything else. Thanks, and happy Friday!

     
    0
  • Anthony Miller
    • 編集済み

    Thanks for the response Mike! I am still noticing this behavior occurring when the only action I take upon entering a spreadsheet are opening a filter view. Is even this small action enough to trigger a revision history? Oftentimes the  "last modified" date on the spreadsheet will not update until a while later though (not immediately after I exit the spreadsheet). I am more confused by the behavior than anything and would like to understand exactly how revision history works. Otherwise, this isn't a big deal either way, just something interesting I noticed.

    0
  • Mike

    Got a little follow-up here.

    When you open a filter view, the system will refresh what data is filtered, which technically modifies what is stored, hence a new revision. I'm awaiting some more info on what is actually presented to an end user, but can at least confirm that opening and/or creating a filtered view would result in a revision.
     
    0

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