Copy

Newsletter by jkp-ads.com

View this email in your browser

jkp-ads.com Newsletter for June 2017

Co-authoring in Office 365. A great feature with an unexpected side-effect

If you are on Office 365 and have access to either OneDrive for Business or Sharepoint a new feature will come available soon (and already is available to everyone on Office insider). This feature is called Co-authoring.
The feature enables you to seemlessly work on an Office document (Excel workbook, Word document, Powerpoint presentation) together with a colleague. All parties editing such a document will see the updates made by the others. And it works on many different devices (yes, on Excel desktop too!)

Side-effect?

Yes. Side-effect. Let me limit myself to Excel here.
To enable co-authoring, a new feature has been added to Excel called Autosave (I know, back in the day Excel had an Autosave add-in, but that has been deprecated some versions ago). This autosave is needed to do the synchronisation between the different people authoring the file. To ensure everyone is on the same page so to speak.
So what is that side-effect you are talking about you may ask? It is this little dialog:

That's right.

Why should I care, part 1

Consider this process:
  • You are working on an intricate model
  • You've had an idea to make some changes and open the file
  • You've made plenty of changes, but suddenly change your mind
  • No problem, just close the file and click "Don't save".
Well. Not when that file is on OneDrive or Sharepoint. Autosave is on by default for all files there, to ensure Co-Auth works. And it saves quite regularly. This means that your changes are constantly saved and there is no quick way out.

Why should I care, part 2

Consider another one:
  • You've designed (and published) a nice company dashboard
  • You've shared it across the company
  • Joe changes the filters
  • Autosave kicks in
  • Now the entire company enjoys Joe's view of the dashboard.
So for both of the above, you may want to turn off the new Autosave option. Here is how.

Turning Autosave off

Luckily it is easy to turn off Autosave and it is remembered for the file (after -yes- saving it). Simply pull the switch at the top of the Excel window, on the left-hand side:

Making it look like this:

From now on, your file behaves as it always did and you can edit at hearts content and close without save will leave the file unscathed. But of course, co-authoring no longer works for the file.

Undoing changes

Now what if I forgot to turn autosave off and made some changes I am unable to undo (like deleting a worksheet)? Your way back is the new clock icon on the top-right corner of the Excel window:

Clicking that icon opens the Activity task-pane:

If you recall when you made that last fatal change, click the "Open version" link just prior to that fatal moment. Excel will open the version and display a new bar:

You can now click Restore to go back to the version you just opened. But you'll have to close the opened version (the one that got saved) first, otherwise you'll get all sorts of errors. This gets harder if the file is also opened by a co-worker.
I pressed Restore and Excel presented me with this bar:

Since I want to go back to the original, I chose "Discard changes", which gave me:

I click Yes. Pfew, that is one heck of a lot of confusing and alarming dialogs and bars to go through just to get my original workbook back!
So there you have it. An awesome feature has been added to Excel, but if you have a habit of fiddling with files, expecting to be able to back out without saving changes you are warned: check the Autosave switch in the top-left corner before doing anything!

Auditing of Formulas made easy

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.
 

Mission-critical Excel Model Crashes

Do you have mission-critical Excel files that cause problems? Consider our Excel File Remediation Utility
.
 
Copyright © 2017 JKP Application Development Services, All rights reserved.


unsubscribe from this list    update subscription preferences 

Email Marketing Powered by Mailchimp