Posts Tagged ‘#excel’

Office Backup

Helpful Hints, Warnings | Posted by Dennis November 23rd, 2011

I’ve discussed lots of ways to protect your data, but there’s one I missed.  If you have a lot of Word, Excel, or Office documents, there’s a slick feature in Office that you can use.  I’ve already told you about the Outlook add-on that will back up your email file, but this is about the OTHER parts of Office.  If you look at the options for Word, Excel, etc. in the SAVE section there is an option to save AutoRecover info every X minutes.  You can decide how often it does this.    The same section allows you to make local copies if you are using a network storage location.  These options can help a lot if you lose your latest draft for some reason.  Here’s a complete rundown on retrieval options for Office 2007 on the Microsoft site.

Office 2010

Helpful Hints, News | Posted by Dennis October 22nd, 2011

The newest version of Office, the productivity software that includes Word, Excel, etc., is the 2010 edition.  It’s now safe to use.  As usual, there were glitches in the initial release so we warned our customers to stay away for awhile.  Now it seems stable, so I thought I’d let you know about some of the purchasing changes.  Unlike Office 2007, this new version only has 3 purchase options.  They’ve done away with the multitude of packages they offered previously, probably because it confused customers.  Now you can buy 1) Office Home and Student, 2) Office Home and Business, and 3) Office Professional.  The Pro version is the ONLY ONE that has Publisher and Access.  Here’s a chart that shows the options.  They also did away with the UPGRADE option, which used to be available for about $100 less than the full product.  I think these were bad moves on Microsoft’s part.  More options are better.  By the way, if you don’t like having to shell out $100-300 for a license, there’s an open-source freebie out there that a friend of mine just told me about called LibreOffice.  It has a lot of powerful features and is very similar to the newer Microsoft products.  This one replaces the old OpenOffice suite that I told you about earlier.  You can download it here.

Protecting a file

Helpful Hints, Warnings | Posted by Dennis July 20th, 2011

After you encrypt an Excel fileIn a previous post I talked about encryption, but a user asked me a good question:  What if I only want to protect 1 file or document?  So I did a little digging, and it turns out that Office 2007 and later support AES 128 bit SH1 encryption.  I assume that’s good enough for the banks (?).  It will make it easy to protect Word and Excel docs… the instructions are here.  After that, just try to open the file and you get a prompt for password.  Close it, and it’s encrypted again. I still like Truecrypt for multiple files, but this will be a nice solution for a single file.  Be sure to use a strong password, but DON’T FORGET IT!