Tag: Microsoft Office

Meeting Request Error 0x80070057-00000000-00000000 In Microsoft Outlook

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

KB2768349 Breaks Connectivity Between Office 2013 and SharePoint Hosted on Office 365

Update 19/03/2013: Microsoft are currently working to resolve this issue. Just sharing this as an observation noted on the Office 365 forums. I installed a raft of updates on my Surface RT recently after the March 2013 patches came through and over the last couple of days I have been unsuccessful in connecting to my …

Continue reading

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 …

Continue reading

Office 2013 – First Impressions

Last night I decided to try out Office 2013 – perhaps not the smartest thing to do just as the university semester is getting underway but I couldn’t help myself. Anyway, I just wanted to share my first impressions of it with you starting with the installation. First of all, the time between kicking off …

Continue reading

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 …

Continue reading

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 …

Continue reading