Select Disable Updates and none of your Office applications will be updated; you won’t need to do this in each application. Somewhere in the world a puppy will start crying however, because you are defying Microsoft.
This action shouldn’t be taken lightly though; you will also not receive security patches so your products may become vulnerable. And at some point, your installation of Office will become unsupported.
Option 3 is performed by running OfficeC2RClient.exe from an administrative command-prompt and using the updatetoversionswitch with the specific version you want to deploy which can be newer or older than the current version (or you may not have one installed at all). If you don’t specify a version, it defaults to the latest one. The versions only go back so far but theoretically you could deploy an older release going back a couple of years.
How will rollbacks work when Office 2016 applications are brought into mainstream Office 365?
We’ll post an update to this blog when we try it.
The last point may seem obvious and irrelevant but we have to mention it for completeness. You can of course still use Office 2011 for Mac on the device whilst connecting to the Office 365 cloud services. But this is not going to help if you’ve subscribed to an Office 365 plan which includes Office applications; who wants to pay twice for the same thing?
Sometimes Microsoft Excel is just too helpful. Like American shop assistants to an English shopper (I’m not being xenophobic, I’m just not used to lots of people asking if I want help finding things (try shopping in Reading on a Saturday afternoon).
Anyone who has tried to paste data in a filtered Excel spreadsheet knows this. Excel will also paste the data into the hidden (filtered out) cells. It obviously thinks it’s being helpful but it’s really not.
There are two solutions that we use. If you’re running Excel 2013 or above, you can utilise Flashfill. For earlier versions, you might be able to use the Fill function..
Let’s look at Fill first. Here is our example sheet:
A nice simple table with numbers in column B, whether they are odd or even in column A and the square of the number in column C. What I would like to do is filter on odd numbers (because I am a little odd), copy the square and paste those into the new column D.
Let’s try to do that in the most obvious way and see what happens.
Filter the table to show only odd numbers. Select all the squares in column C and copy.
Click in cell D2, right-click and select Paste Values. But wait! Only half of the values are shown. That’s because Excel is being over-helpful and pasting into the hidden, filtered-out rows as well as the visible rows. It would be lovely if there was a ‘Paste Values into Visible Cells’ option but you’ve already spent an hour searching the internet to discover there just isn’t.
If we clear the filter, we can see exactly that behaviour. Our five selected cells have been pasted into the interim rows.
Now go up to the ribbon (Home tab) and click Fill and Fill Right. Obviously if your destination column is to the left then feel free to hit Fill Left instead.
And voila, unlike the previous attempt, we are seeing all five desired values.
And just to be sure, let’s clear the filter condition to make sure nothing has been copied into the hidden rows.
Bingo. We have our desired outcome. Obviously this only works in the same sheet and if your columns are adjacent left or right to the cells you wish to copy. If there are columns in between, you can hide those columns and this method will still work; Excel doesn’t paste into hidden columns in the same way it pastes into hidden rows. In the screenshot below, I moved column A between the source column and the destination. I filtered on Odd numbers in the same way, then hid column C. Select Columns B and D and use the Fill Right method and as the screenshot works, once I unhide column C and clear the filter, everything still works out ok.
Flashfill Will Only Update Visible Cells
In Excel 2013, we have the lovely Flashfill feature which we blogged about previously. Flashfill will also help but it’s not relevant for Excel versions earlier than 2013 (or Office 365 ProPlus if you ‘re in the cloud).
You can filter on odd numbers, type 1 in the first cell of the destination column, type 9 in the next cell down, hit Enter and then CTRL + E to force Flashfill to take over. All the desired cells will be copied and if you clear the filter condition, you’ll see that the hidden rows haven’t been touched. This is why we love Flashfill!
I’ve just been sent an email with a PowerPoint template attached. All would be fine except this is the fourth version of the template file. I’m lucky that I don’t need to worry about storage limits in my inbox but I still don’t like multiple versions flying about and duplicated search results.
We all know we should put the file in a shared location and send a link to so we don’t need to worry about different people having different versions. But it’s never been easy.
Modern Attachments with Outlook Web App
If the file is on OneDrive for Business (we’re assuming you don’t put business files in OneDrive), I can easily attach them to an email and the sharing is done for me. I don’t need to go into the ODfB folder and share.
Below I have a document stored on my ODfB but shared with no-one.
In Outlook Web App (OWA), I compose my email in the normal way and insert attachment.
OneDrive for Business shows me recent files. This is a fairly new enhancement along with the ‘shared with me’ view. I select the file I want to attach.
The all-important question; do I want to attach this file and endure the pain of resending it every time something changes. Or do I want the simplicity of sharing the file via OneDrive?
Within the email, I can use the dropdown on each attachment to change the permissions from the default of edit.
And once I send the email, I can see that the share and permissions have been set for me automatically back in ODfB. Nice.
An upcoming feature of ODfB is expirations on shared links. That means I could share a file or folder for a week and the permissions will automatically revoke after that time. How this will surface in the attachment process, I don’t know.
Currently, this feature is only available via OWA but it will be included in the rich Outlook client sometime in 2015 (no timeline) and in the mobile Outlook apps for iOS and Android before July 2015.
Microsoft wants customers to be confident about the importance of ODfB and the effort they’re putting into getting it right. We all swear (a lot) at ODfB synchronisation right now and sometimes it’s embarrassing to discuss this with customers but the roadmap is exciting and the future looks bright.
If you’d like to learn about SharePoint and ODfB in more technical depth, have a look at our courses. We use the best trainers so not only do you learn the course material but we can provide the most up-to-date information about the technologies.
Spare a thought for all those workers out there who still have storage limits. A 200MB inbox for example. For a while now, Office 365 customers have been able to enjoy unlimited Exchange Online Archiving and 1TB of OneDrive for Business storage. But Microsoft likes to set limits that customer’s aren’t going to hit. Starting in 2015, all Office 365 customers will enjoy unlimited OneDrive storage at no additional cost. No specific timescales but every customer will be notified of their service changes.
The Office blog highlighted the change in October last year but we’re starting to see Office 365 consumer and commercial customers receive this upgrade.
One step at a time however, as the current limit on items within a OneDrive for Business library is 20,000, including files and folders.
The issue of data sovereignty arises a lot with cloud computing so it’s good to stay up-to-date with plans for local datacentres. Offering Office 365 services from local datacenters helps customers feel more confident about complying with regulations that require data to be kept in their own region. Microsoft has a regionalised data centre strategy with Office 365 and the billing address of the customer, which the customer’s administrator inputs during the initial setup of the services, typically dictates the Office 365 region and the primary storage location for that customer’s data. You can view these regions on the Microsoft Office 365 Data Maps page. For example, customer’s in Asia Pacific will have their Office 365 hosted in datacentres in Hong Kong and Singapore, however some data may reside elsewhere such as Active Directory and Global Address Book data.
Microsoft announced they’ll be launching Office 365 services from datacenters in Japan (December 2014), Australia (March 2015) and India (late 2015) and these regions will replicate data across datacenters in a single country only.
Customers should be able to create new tenants inside these additional regions as soon as they’re online (for example Japan is available now). Existing customers in the affected regions will have their data moved to the new Office 365 datacenters from September 2015 and will be given six weeks advance notice of their move date.
Perhaps you’re looking for a new job and you want to refresh your certification. Perhaps you’re hiring new staff and want to skill them up quickly or meet targets to earn a Microsoft Partner Competency. What’s the easiest way to earn a Microsoft Certified Solutions Associate (MCSA) accreditation?
Easy is the wrong word here. None of these exams are easy; they exist to test and prove your experience and knowledge in a topic. MCSA is also the prerequisite to earn the Microsoft Certified Solutions Expert accreditations which really are the pinnacle of Microsoft certifications.
However the fastest route to earn an MCSA, assuming you’re not upgrading an earlier qualification, is to work towards either Windows 7 or Windows 8.1 MCSA or towards the Office 365 MCSA. Each of these routes only require you to take two exams from scratch.
Your choice should clearly depend on your IT career path and the skills you’re going to need. If you are open to all areas though, of those three MCSA options, we’d advise the Office 365 MCSA. Firstly there is only one 5-day course whereas Windows MCSA involves two 5-day courses and thus more time out of the office and more cost. Attending a course is not required to take an exam but it’s a great way to maximise your chances. Secondly, the Office 365 MCSA can be used as the foundation to gain the MCSE qualification in Desktop Infrastructure, Server Infrastructure, Private Cloud, Messaging, Communications or SharePoint. The Windows MCSA does not have an MCSE route.
Of course, we’d love to help you gain nay Microsoft qualification so please get in touch and see how we can help.
A play on the film title from “Dude, where’s my car?” in which, well actually, we can’t remember the plot but we do remember the title and something about a scene with tattoos.
Putting movies to one side, customers often want to know where their mailboxes reside in Office 365 and Exchange Online. If my billing address is in Europe I can assume my data centres are located in Dublin and Amsterdam but can I verify that? Also, the mailboxes for individual users and resources might be in either of those locations. Here’s where a little PowerShell comes in handy.
Windows 8.1 includes PowerShell by default so on the Start screen, type PowerShell, right-click Windows PowerShell in the search results and select Run as Administrator. I’ll explain why you need to run it as admin in a moment.
1 – Set the PowerShell execution policy. The default setting for execution policy is restricted which would not allow PowerShell to run scripts at all; secure but not very useful. RemoteSigned tells PowerShell it can run scripts on the local machine but any scripts downloaded from the Internet must be signed by a trusted publisher. This is also why you need to run PowerShell as administrator; in order to change this setting.
2 – Set your Office 365 admin credentials. A popup window will appear where you type in your Office 365 admin user and password. This will also tell the PowerShell cmdlets which Office 365 tenant you want to connect to.
$cred = Get-Credential
3 – In order to perform administrative tasks on Office 365 you can connect to the online service using the credentials you supplied.
Connect-MsolService -cred $cred
4 – You can list all the Office 365 admin commands. Note that Exchange, SharePoint and the other cloud services have their own set of commands.
Get-Command –Module msonline
5 – To connect to Exchange Online, type the following commands. You don’t need to change anything here; again, the tenant to connect to is specified by the login ID in the credentials.
There are a number of possible Lync clients including the Lync Windows Store App (Modern UI), Lync Web App and mobile Lync clients for Windows Phone, iPhone, iPad and Android devices. The most likely alternative for users will be Lync Basic which is a no-cost application to connect to Lync Online or Lync Server. For users already on Office 365 Small Business Premium or Midsize Business plans who are upgrading to the new Business plans, the update process will uninstall the Access & Lync applications and users will be able to download Lync Basic from their software portal in Office 365.
Although the functionality of Lync Basic was recently updated to more closely match that of the full Office Lync client, there are some quite significant differences including the lack of spellchecker for instant messages (after a long time of asking Microsoft to add a spell checker to Lync, losing it now is disappointing), using OneNote for Lync meeting notes and the ability to record meetings. Some features are not so relevant for SMB customers and there are also features which require on-premises Lync Server or SharePoint Server such as Skill Search and Persistent Chat; those features would not be available to Office 365 users even with the full Lync client.
Microsoft have to please over a billion users of Office so there will always be some elements that people aren’t so keen on. You can tell we’re being diplomatic here can’t you? I must admit I stayed with the Windows Classic start menu when I used Windows Vista back in the day.
I had a question from a user at Land Securities during an Office demonstration session. The person was working on a small device and the Word print preview in Office 2010 and 2013 only shows the document in half the window. He missed the old print preview dialogue box where he could view the document as full screen.
When features of Office are deprecated, some of them remain in the product but are moved into the background. This is one of those features. To access the old-style Print Preview window you need to customise the Ribbon or Quick Access Toolbar. Let’s use the Quick Access Toolbar for our example. To add commands to the toolbar, click the arrow to the far right. As the command in question is not in the common commands list, select More Commands….
This will show the Customise Quick Access Toolbar page in the options window. Click on the dropbox and select All Commands to display an alphabetical list of all the Word commands; a surprising number of them.
Scroll down in the list until you see Print Preview Edit Mode. Double-click the command to add it to your Quick Access Toolbar.
And now you have the Office 2007 style Print Preview window at the touch of a button.
Whether it will still be there in the next version of Office is anyone’s guess of course, so caveat emptor or another suitable Latin phrase for be careful when using old Office commands.