MS Office

Convert plain numbers to MAC addresses with Excel

We use the following formula if you need a – between the octets:

=MID(c2,1,2)&"-"&MID(c2,3,2)&"-"&MID(c2,5,2)&"-"&
MID(c2,7,2)&"-"&MID(c2,9,2)&"-"&MID(c2,11,2)

We use the following formula if you need a : between the octets:

=MID(c2,1,2)&":"&MID(c2,3,2)&":"&MID(c2,5,2)&":"&
MID(c2,7,2)&":"&MID(c2,9,2)&":"&MID(c2,11,2)

Of course, you need to change the cell references in each (i.e. the c2) to match which cell you need to convert.

read more
DamianConvert plain numbers to MAC addresses with Excel
end-of-life.jpg

Countdown to End-of-Support for Windows XP

Support for Windows XP ends

On April 8th 2014, Microsoft will end support for its decade-old Windows XP. This means, you will no longer receive security updates, fixes or online technical support for PCs still running Windows XP SP3 and Office 2003. The security and privacy implications of this event could have significant impacts on your business, so if you’re running either of these products you should plan to take action soon.

As a precaution, we would recommend all our clients to consider upgrading to the latest supported operating systems such as Windows 7 or Windows 8.1. Customers migrating to these platforms will benefit from enhanced security, broad device choice for a mobile workforce and higher user productivity.

Why upgrade now?

  1. No support: Microsoft support, including online and phone-based technical support, will end. As a result both Jaytag and any other IT support company will not be able to properly support Windows XP.
  2. Security Risks: Critical security updates will stop, making machines much more vulnerable to viruses. Hackers are waiting to take advantage of this insecurity. If your computer gets a virus your machine will not only not perform properly – it may shut down entirely. Moreover, you are at risk for losing files and having your personal and business information stolen. Anti-virus software will also not be able to fully protect you once Windows XP itself is unsupported.
  3. Compliance: Businesses that are governed by regulatory obligations may find that they are no longer able to satisfy compliance requirements e.g. PCI compliance.
  4. Hardware Manufacturer support: PC hardware manufacturers will stop supporting the above mentioned operating system. This will also mean that drivers required won’t be available anymore. E.g. a new HP printer won’t have drivers for the above operating system.
  5. Old technology: Windows XP was released 12 years ago, and was replaced by Windows 7 in 2009. It does not support HTML5 or the newest version of Internet Explorer nor does it support many modern hardware devices such as USB 3.0.

If you have any concerns regarding your systems, please do contact us to discuss the options that are available to you.

read more
DamianCountdown to End-of-Support for Windows XP

How Cloud Storage Could Help Your Small Business

Cloud Storage is the term used to describe using an online facility to store your information. These are usually operated by a third party company using data centres and there are a number of different operators providing it such as Dropbox, Skydrive, My Secure Backup, and Google Drive.

Cloud storage is an increasingly popular concept, and many small businesses are embracing it to help them. But how can cloud storage help a small business?

One popular use of cloud storage is to store your important documents such as databases, spread sheets or client projects. By doing this, it doesn’t matter if your computer breaks down, is stolen, or the file is otherwise lost; you will be able to successfully retrieve it from your cloud. You can usually set up an automatic synchronisation, so that when you save a document to a certain folder in your PC, the cloud storage facility you use will pick it up and automatically save it there too. Alternatively if you log onto your cloud storage remotely from a remote device or there web site you can upload/maintain documents and these will automatically synchronise/update on your home computer.

It is also a secure way of storing your information. You can change privacy settings of the documents so that it can only be accessed by yourself, people listed, or people who you pass the link to. This allows you to share it with people if you need it, or stash it away in a private folder if it isn’t something you want to share.

The cost of cloud storage can be considerably lower than other solutions, with many companies offering you a small amount of start-up storage for free, with higher amounts becoming available to you for a small fee, often on a monthly subscription basis.

So lets take a look at the four services I previously mentioned and see what they have to offer:

DropboxDropbox

Dropbox is a cloud storage facility which comes with an initial 2GB, which can be expanded to fit your requirements. A client application runs on your PC continuously monitoring and synchronising a specific folder so it can be set up to back up whatever you want, and all your documents are accessible from wherever you go through any PC or mobile device. It can be upgraded to Pro (designed for personal use) or Teams, which allocates space between your team. It also has management facilities so you can track the account usage of your team members and seamlessly shares documents across all devices.

Sky DriveSkydrive

This is Microsoft’s answer to cloud storage and allows users to upload their documents, again accessing them from a computer or device. New users get 7GB of free storage which can be upgraded for a small subscription fee. Because it is a Microsoft product, it has been upgraded to include Office Web Apps, which allows documents to be created, edited and shared online.

JunglediskMy Secure Backup

This is our own secure storage solution for businesses which allows secure access of all your data between teams of 2-100. All files are kept safe in Amazon’s S3 file servers in the US or EU, or RackSpace.com file servers – two very popular file hosting soultions. You can limit files that are stored locally, which unlike Dropbox or Microsoft SkyDrive’s “LiveDrive” in the event of a theft or unauthorised access you’ll benefit from the added security. You’ll also benefit from multi-way sync between machines which means that your files will never be out of date if multiple team members are working on them. My Secure Backup also offers the ability to backup multiple computers (even the main file server) on a daily basis in a single account. Remote monitoring is also a fantastic feature with configuration and ongoing support is provided by our very own Jaytag Computer, not a large faceless corporation. We also offer UK based technical support.

My Secure Backup is £10 per month for the first installation in a business which includes 50GB of storage and then £5 for each addon user per month – all users can share the same 50GB ‘pool’ of storage.

Google DriveGoogle Drive

This is Google’s own storage service which allows users to store and share documents seamlessly between anyone. Google Drive also has Google Docs built in which gives users the ability to not only create documents, spreadsheets, presentations, and drawings by themselves, but invite collaborators to help with editing

Recently Google announced that they’re merging the storage space between Google Drive, Google+, and Gmail into one giving users 15GB free to use between the three Google services.

Cloud storage is becoming an increasingly popular way for businesses to share files as well as keep them safe, secure, and always available. DropBox, SkyDrive, and Google Drive are all fantastic cloud storage services, but they’re mostly aimed at individual users. My Secure Backup is made for business and offers more storage space as well as shared storage between employees and team members.

read more
Aaron RichardsonHow Cloud Storage Could Help Your Small Business

Office 365 – Set the default domain

When you first setup Office365, Microsoft provides you with a default domain – usually companyname.onmicrosoft.com – for example, the Jaytag domain is jaytag.onmicrosoft.com.

This can cause a small headache – as it’s not obvious when you have added your companies domain where to set this as default – so when you add new users, the primary email address will be emailaddress@companyname.onmicrosoft.com.

To set the default domain to the domain you have added, login to Office365 and click into the adminin

Click on your company name in the top-left corner of the administration interface.

Then click on Edit in the top-left corner of the company window.

You will see a drop down list of the domains in your Office365 account – select the domain you wish to make primary, and then click the the OK button in the bottom-right of the screen.

The primary domain is now set – and new users added will have their primary email address domain set to this domain, not @companyname.onmicrosoft.com.

read more
DamianOffice 365 – Set the default domain

Updating Office 2000

If like us, you still encounter Office 2000 out in the field, you may find it needs updating from time to time. Sadly, the necessary updates are not all available from Microsoft.

You can download these updates here:
Office 2000 SR-1 administrator updates (O2KSR1aDL.exe)
Office 2000 Update: Service Pack 2 – SP2 (sp2upd.exe)
Office 2000 Update: Service Pack 3 – SP3 (O2kSp3.exe)

Hope this helps all of you out there still using/supporting Office 2000.

read more
DamianUpdating Office 2000

Repairing a corrupt PST personal folders file

I wrote previously about corrupt PST files. The first you may know about it may be an error message like this:

Unable to expand the folder. The set of folders could not be opened. Errors could have been detected in the file drive:Documents and SettingsuserLocal SettingsApplication DataMicrosoftOutlookOutlook.pst. Quit all mail-enabled applications, and then use the Inbox Repair Tool.

Thankfully, Microsoft provide a PST repair tool for just this occurance:

  • On the Start menu, click Run.
  • In the Open box, type:
  • C:Program FilesCommon FilesSystemMapiLocaleIDscanpst.exe

Where LocaleID is the locale identifier (LCID) for your installation of Microsoft Office. For example, the LCID for English (United States) is 1033. For a list of LCIDs, see Microsoft Office Help.

  • Click OK.
  • In the Enter the name of the file you want to scan box, type the path and file name given in the error message above.
  • Note that you may not be able to use the Browse button to locate this file because it is located in a hidden folder.
  • To change the options for logging errors during the scan, click Options. If you choose Replace log or Append to log, the log file is saved to the same directory as the .pst file.
  • Click Start
  • When the file scan is completed, select the Make a backup of scanned file before repairing check box.
  • Click Repair

If the file is successfully repaired, you will see a Repair complete message. If the Inbox Repair Tool was unable to repair the file, you will need to use a backup of your file.

There are third party programs available which could also help:
http://i4you.wordpress.com/2008/09/06/about-microsoft-outlook-errors-and-outlook-pst-repair-tool/

read more
DamianRepairing a corrupt PST personal folders file

Microsoft Office has not been installed for the current user…

This is quite a common problem it seems – after installing an update to Microsoft office, some of the applications will not open.

Here is one solution:

  1. Create a temporary Windows login account with administrative rights, then log into that new account.
  2. While logged in as the temporary user, open every Office product you have, then close one at a time (Excel, Word, Powerpoint, Project etc…)
  3. After opening every Office application, start regedit. (Start > Run > then type in Regedit)
  4. Go to HKEY_CURRENT_USER > Software > Microsoft > Office, and highlight Office
  5. Right click on Office, and select ‘Export’
  6. Save the .reg file somewhere on your computer – note down the location
  7. Log off the temporary account, and login under your normal Windows account (the one giving you the error)
  8. Open regedit again, and then go to File > Import and pick the file that was exported.
  9. After the import completes, the applications should open correctly.
read more
DamianMicrosoft Office has not been installed for the current user…