Category : Microsoft Office

Updated Microsoft Office Apple Compatibility – New Microsoft Office Software Review | BVA IT Consulting Blog

Microsoft is showing off its new updated Office software and its surprising capabilities of working well with Apple. The Office team at Microsoft have updated its features for Word, Excel, Powerpoint, OneNote, Outlook, and Translator for you to benefit from Apple products. This is great news for Apple lovers as now you can take advantage of these refined Microsoft applications on the iPad Pro, iOS 9, and WatchOS 2.

split viewFeatures include multi-tasking functions such as the Slide Over and Split View in iOS9, which will easily allow you to toggle between Office apps on your iPad. You can work on a PowerPoint presentation as well as check your email without leaving an application by simply sliding over. As for split view, you can have two apps open at the same time. This will give you the ability to copy numbers down from an Excel Spreadsheet, for example, to a Word document.  Another helpful feature is Microsoft’s intelligent search, which will now include OneNote notes and Outlook messages in iPhone and iPad searches.

For Apple Watch users, you can literally get your incoming email directly on the watch face as well as check upcoming appointments. The newly introduced Translator service allows recent translations to be played back through the watch Office-updates-watchOS2speakers, so travelers can take advantage of the devices ability to articulate common phrases in a local language.

All the updated Office apps will be accessible along with the arrival of the new iPad Pro, iOS9, and WatchOS 2.

DirSync on a Domain Controller – Now you Can…

Screen Shot 2014-11-09 at 11.48.07 PM

The Active Directory Sync tool [DirSync] can now be installed on an Active Directory Domain Controller (DC).  You must fist have to install version 6553.0002 or newer. The process of installing DirSync on a DC is mostly the same as for deploying it normally. Keep in mind that the administrator installing the tool will need to log-off and log-on again after the Installation Wizard is complete and before the Configuration Wizard is run. This additional step of logging off and logging back in is necessary to ensure that the Directory Sync tool is installed using the least privileges possible on the DC.

If you forget to follow the above process, the Configuration Wizard will return an “Constraint Violation Error” error. If you face this error, simply log off and log in again and you will be able to proceed. Note that the recommendation is still to deploy DirSync on a member server rather than a DC as it will install FIM 2010 R2 SP1 and SQL Server 2012 Express SP1 by default, which can add overhead to your DC.

Troubleshooting Lync for Mac Sign-in Fails with Apple OSX Yosemite | BVA INC. emPowering Your IT –

Screen Shot 2014-10-20 at 9.22.50 AM

There is a known issue with Lync clients with new Apple OS called Yosemite.  The Lync for Microsoft Office 2011 (with Office 365 or Lync on premise) no longer will sign in, the potential fix is listed below.

Primary Symptom: when you attempt to log into Lync, it appears to sign you in just fine, but after briefly displaying your Lync contacts, it immediately signs you out and gives you a generic error message that either the server is unavailable or some unknown error has occured.

Recommended Resolution:

  • Make sure you have all Mac for Office updates and are running the very latest updates
  • Go into Settings, Language & Region
  • Change the language from “English-Primary” (or whatever the language is set to) to “English-US”
  • Reboot
  • Go back into Settings, Language & Region
  • Change the language back to “English-Primary”
  • Reboot
  • Open Lync and you should be able to log in just fine this time

Chrome Extension Opens Microsoft Office Docs In the browser window

For those of you users out there who are running Google Chrome beta, there is a beta extension in existence called Chrome Office Viewer that will actually let you open Microsoft Office documents in Chrome. Currently this is a read only extension but hopefully soon it will be a full blown read/write add-in. It has the potential to be a big plug-in. It is also important to note that when opening documents in chrome, it opens it up in a sandbox mode. Essentially separating it from everything else to prevent infections if the file is malicious. Pretty cool if you ask me.

Excel 2013 Features

Excel 2013 features
What’s new in Excel 2013? Below is a quick assessment of some of the new features you will find in Excel 2013.
1 – Complete Smooth – Move between any ranges of cells
2 – Flash Fill Feature – Excel will look for patterns and quickly learn what you are looking for
3 – Timeline Slicers – Allows you to filter pivot tables.
4 – Interactive charts
5 – Create Analytic Pivot Tables much easier
6 – Quick Analysis – Excel will automatically suggest to you what the possible “Data Analysis” is as soon as you select a region of data.
7 – Power View allows you to make quick reports. Basically select your data and choose Insert, Power View.
8 – One of the most robust features of Excel 2013 and Office 2013 in general is the ability to share files and work with other people.

Office 2013 Features

Office 2013 is full of a variety of new features, some of you are probably wondering why there are so many changes and what can I do with this software? Microsoft added some cool new tricks that I wanted share.

1 – Outlook Charms: You will find these along the margin of Outlook 2013, icons such as email, calendar, contacts and task. If you however any of these you get a peak as what the icons do.

2 – App Home Pages: When you open one of the Office programs you’ll get a screen filled with thumb nails that will represent recent documents and templates you can choose from.

3 – Flash Fill in Excel: Flash fill anticipates your formatting and data requirements and accommodates them on the fly. Basically it learns your patterns.

4 – PDF Reflow in Word: A common tool is formatting documents into PDF’s. In the past you had to have another application do this, Word now does this on the fly for you.


Ever have problems with items within an outlook calendar becoming corrupt, or it is just acting quite strange? Well Microsoft has released a utility that is  called CalCheck that allows you to check your outlook calendars for corruption and other issues. CalCheck is a command line program and we here at bva find it to be useful.

Essentially the tool opens an outlook profile in order to gain access to your outlook Calendar. It checks for multiple things such as free/busy publishing, permissions, delegate configuration and automatic booking. It will then check each calendar item for known problems, generates a report for you.

All in all, this is a time saver for any IT technician as it gets right the the heart of outlook calendar issues. If you want to read the rest of the article on the CalCheck utility, access the link below.

Download it here.


Microsoft Office 2013 SkyDrive

BVA emplyees see the perks of Microsoft Office 2013 but one awesome new feature we noticed was SkyDrive. With this you can share documents from anywhere with the cloud storage and even allows them to edit at the same time you are accessing the file. If you’re more of a visualy person and want to see what this feature is all about, check out this article. It gives you step-by-step idea as to what it all offers.

Office 365 Will Include 2013 Product Versions- Exchange, SharePoint, Lync, and Office

The Office 365 update that includes the 2013 product versions of Exchange, SharePoint, Lync, and Office will be available February 27th.  This is a fundamental shift in our business that began several years ago and continues today with the release of Office 365 Home Premium. This is a brand new Office never experienced before.  For the first time, consumers can subscribe to Office as a service instead of purchasing Office as a piece of software to install. The new Office subscription is an entirely new way to think about the productivity experience with entirely new benefits.

Office 365 Home Premium subscribers receive all the full-featured Office applications they know and love, together with impressive new cloud and social benefits built in. One subscription can run the service on up to five devices, all for just $99.99 a year. People will love instant access to all their documents and settings across their devices and how Office takes full advantage of the new Windows 8 touch interface. They’ll love staying connected to the people and information they care about. And they’ll love having the latest version of Office at all times because it simply updates without the hassle of purchasing and upgrading to a new version.   Smaller businesses are also choosing Office 365 at a rapid pace, with a 150 percent increase in the number of small and medium-sized businesses using the service over the past 12 months. These businesses will get to enjoy the new Office 365 service for businesses beginning Feb. 27.

Office 2013 Release- End of Month

Rumors are the Microsoft will be launching Office 2013 to customers at the end of this month.  It has been available to business customers since November 2012 and had a preview earlier than that. Now they are ready for everyone else to buy it and use it. Microsoft 2013 has many of the options we have loved for awhile along with some more options to personalize your Windows experience.  Office 2013 will have the standard Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access. Like normal it can be placed on up to 5 Macs, PC’s, or mobile devices as well. The nice thing about this version is it have been tested on Surface RT tablets too. One thing that I like about the newer Office products is it has adapted to the ever evolving cloud computing world. Customers are able to save work in SkyDrive or SharePoint where it is easy to do what you please with it. Social Networking is no stranger to Microsoft Office either, you can view Facebook updates and LinkedIn feeds using Outlook with ease.   There are many variations of Office 365 including Home Premium, Small Business, ProPlus, and Enterprise to customize what suites you best.  To get a better idea of what is the best for you follow this link from Microsoft: