Share Workbook and Tracking changes removed from Excel [EN]

That’s not exactly my usual tip article for Office 365, but i thought i should still share this information. In July Office 365 client (MS Office suite) in the Current Channel has been updated. They have added a realtime collaboration feature (as well as AutoSave) to Excel application. This made possible to work with Excel document the same way as it was possible in Word before. Although a number of conditions must apply. First the file should be stored in OneDrive or SharePoint Online. And you also has to access it via a browser and then select to edit it in MS Excel. Opening a file from your OneDrive folder on your PC doesn’t activate those features. That’s all cool and dandy (although while trying it in Word we have found that it often doesn’t work that well). But this also gave the reason for MS to remove older features like Share Workbook and Tracking changes from the Office Ribbon in Excel. These features allowed to get a somewhat similar (although not realtime) results, but when files are stored on a Windows share or sent via email. In our company we are still heavily using Share Workbook feature, so it was an annoying thing to find out. Fortunately MS wasn’t dumb enough to completely remove them. One can still find these buttons in File > Options > Customize Ribbon > All Commands and add them to a custom tools group (you can create that group in the same place these buttons were before). The buttons have “(Legacy)” label attached to them. So this explains MS’s thinking to retire these features in favor of the new ones, which encourage to use their cloud services even more.

Tell me, tell me, MS Office [EN]

excel-2016Newest version of Microsoft Office has been released yesterday – 2016. The look has changed a bit, added a bunch of new features. But! One thing first jumps into your eyes when you launch one of the Office 2016 applications. It’s “Tell me” search field, which sits above the tools ribbon. It seems, such a simple thing, but when you try it, you realize that it’s really useful and was needed for a long time. No matter how hard Microsoft tried to advertise new “ribbon” user interface since the Office 2007 release, people are still having hard time finding in there tools they need. And now you can just enter into the search field what you want to do (e.g. “insert table”) and you will be provided with the corresponding tools and selections. Simple and.. genius? 🙂 Of course, one who have used Office with such help will have a hard time doing anything when he sits in front of an older Office version. Still, just this one new feature is making me consider upgrading to this version in the office. We have a subscription contract for Office allowing us to freely install newest version after all.

Tell me, tell me, MS Office [LT]

excel-2016Vakar buvo išleista naujausia Microsoft Office versija – 2016. Šiek tiek pakeista išvaizda, pridėta kitokių naujovių. Bet! Vienas dalykas pirmiausiai krenta į akis paleidus kurią nors Office 2016 programa. Tai “Tell me” paieškos laukelis, kuris įsikūrė virš įrankių juostos. Atrodo toks paprastas dalykas, bet pabandžius jį supranti, kad tikrai naudingas ir seniai reikalingas. Kad ir kaip Microsoft reklamavo nauja “ribbon” sąsają nuo Office 2007 pasirodymo, žmonės vis tiek sunkiai randa joje reikalingus įrankius. Dabar gi gali įrašyti į paieškos laukelį, ką nori padaryti (pvz. “insert table”) ir tau bus pateikti atitinkami įrankiai ir pasirinkimai. Paprasta ir.. genialu? 🙂 Aišku, žmogus padirbęs su tokia pagalba ir atsisėdęs prie senesnės Office versijos, sunkiai galės ką nors padaryti. Ir vis tiek, vien ši naujovė, verčia pamąstyti apie perėjimą prie šios versijos ofise. Juolab turim prenumeratos sutartį Ofisui ir galim laisvai įsirašyti naujausią versiją.