An obscure tip but one that I found worked this week. A colleague at work was attempting to send a meeting request but repeatedly received errors from our Microsoft Exchange server for one of the recipients. Everything seemed fine and the contacts were correctly populated from the contacts cache. Sending the request met with no …
Tag: Microsoft Office
Oct 13 2013
Excel Spreadsheet Dates Out by Four Years
This might be a bit of an obscure issue but one worth keeping in mind. If you work with Microsoft Excel under both Mac OS X and Windows then you may find an issue with date values changing by themselves when you open them on the other platform (i.e. opening a spreadsheet creating in Mac …
Jun 26 2013
A Smarter Way to Change Ribbon Tabs in Microsoft office
Very quick tip for today. If you’re using a more recent version of Microsoft Office from 2007 and onwards you would have realised that the menus of old have been replaced by the ribbon. Granted, it takes some getting used to but a lot of people would find it hard to go back to the …
May 02 2013
Microsoft Outlook Stuck in Offline Mode
Here’s a quick tip for users of Microsoft Outlook – perhaps the e-mail client of choice in most corporations these days. On rare occasions you might find Outlook stuck in offline mode and you may find that you are unable to get it back online and receiving mail. Even after restarting Outlook and having an …
Apr 30 2013
An OST file is in use and could not be accessed…
If you’re a user of Outlook you may encounter the following error message on the rarest of occasions when attempting to open the application: The file <OST file location> is in use and could not be accessed. Close any application that is using this file, and then try again. This was after I had closed …
Oct 04 2012
It’s Easier to Save Than to Script Again
While this probably applies more to a significant part of my line of work and others that do coding and/or scripting this can be applied generally to any other sort of data, content or programmatic creation. SQL or Server Query Language is what I use to import, manipulate, interpret and extract data from databases almost every day …
Jul 22 2012
AutoRecover – Not a Substitute for Saving
The nose is well and truly back to the grindstone as university kicks off again with what is likely to be my final semester of study for my Masters of Science in Information Technology. Whilst the semester itself doesn’t kick off until tomorrow I am wanting to get a good head start on the assessment …
Feb 13 2012
Converting Text Dates to Proper Dates in Excel the Easy Way
From time to time you might receive an Excel spreadsheet that has been created by an application but it has output the dates in its own text format instead of being stored as an actual date value. I’ve seen instances where the time has been placed before the date which would leave many to think …
Follow Us!