![]() With AutoSave, that option is no longer possible. Without Undo available, closing the file without saving isn’t an option. And if you regularly run macros, you’ll find that Undo is not available to reverse any changes caused by the macro. Rather than trying to step back through Undo using Ctrl+Z or Alt+Backspace, it’s easier to simply close the file without saving. Or I delete a worksheet and then discover a horde of #REF! errors appear. Other times, I might inadvertently wipe out formulas by copying instead of cutting before a paste. I might open a file and change a few numbers to see the results-knowing that I plan to click “Don’t Save” when Excel asks if I want to save changes (see Figure 1). I regularly open Excel files with no intention of ever saving them. This feature is going to cause far more headaches. In order to introduce Co-Authoring, Microsoft also had to add a feature called AutoSave. For those cases where multiple people have to access the same workbook at the same time, Co-Authoring is a welcome addition. Their solution, which they call Co-Authoring, is now rolling out to Office 365 Subscribers. The Excel team has been working on a better solution. If turned on file sharing, you were prevented a number of key actions, including inserting rows or pivot tables. The former solution, Shared Workbooks, wasn’t practical. ![]() Then everyone else was locked out of the file needlessly. This often worked, until one coworker forgot to close the file and left for a long lunch break. One person would open the workbook for editing, and everyone else was forced into read-only mode. Accounting departments would handle this by taking turns. Until now, only one person could edit a workbook at a time. You’ve probably encountered certain workbooks where multiple people need to access the same workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |