Extend your Office apps via Live Workspace

I spent Wednesday afternoon getting to know Microsoft's new Office Live Workspace, a free service that lets you store Office files online for easy access and sharing.

Once I got used to what the service isn't--it isn't a way to actually work on the files in a browser--I came to appreciate how easy the service makes it to save Word, Excel, and PowerPoint files on the Web, and open them in their original app on any PC with an Internet link.

The biggest downside is how difficult it is to get the service working on a Vista machine running Office 2007. I was uploading and downloading Office 2003 documents on my XP machine in just a few minutes, but I had to jump through a series of hoops to do the same in their Office 2007 equivalents on my newer Vista PC.

I decided to start from scratch by creating a new Windows Live account rather than using my existing Hotmail account. Signing up for the account was a breeze, though I opted out of most of the options the installer presented. For example, I had no interest in downloading Messenger, the Windows Live Toolbar (my browser's cluttered enough already), or anything having to do with OneCare, which single-handedly destroyed my home network when I tried out the beta last summer. Be sure to uncheck the option to make MSN your home page, and you may want to avoid sending Microsoft any more data than the company already helps itself to.

Once the Windows Live installation completed, it took just a few more clicks to get started with Office Live Workspace. You're prompted to give the generic workspace a name and description, which you can change later simply by mousing over the name in the left pane and choosing one of the options that appears.

Of course, there's not much you can do with the service until you get some files uploaded. You can add files from inside the workspace one at a time or in batches, though the batch approach uses an ActiveX control, and thus requires Internet Explorer 6 or higher. Since I normally use Firefox (and had used that browser to create the workspace), switching to IE just to upload a bunch of files at once would have been a major inconvenience. Still, I never intended to use this method to add files to the workspace. Instead, I downloaded the Office Live Add-in, which lets you upload files to and download them from the workspace directly inside Word, Excel, and PowerPoint.

Read more

Create a simple form in Microsoft Word

Microsoft Office includes industrial-strength tools for creating forms of all types, but the Access database and InfoPath information manager are overkill for my meager form requirements. If I need to collect basic information from a bunch of people in a hurry, such as for planning a potluck lunch, I stick with the simple form-creation tools in Word.

Word 2007 groups the options found on the Forms toolbar in Word 2003 into the Legacy Tools button in the Controls section under the Developer tab. These form fields are a subset of Office 2007's Content Controls, which allow you to populate … Read more

Convert any Office file to PDF for free

Recently an associate whose PC lacked Adobe Acrobat sent me a Word file via e-mail, asking if I could convert it to PDF and e-mail it back to her. Since the process took all of about 30 seconds, I was delighted to help. Then the next day she sent two more files in need of conversion to PDF, and a couple of days after than another. After her fourth request of the week I felt compelled to tell her about two ways she could have converted the files herself for free: Adobe's own Create Adobe PDF Online free trial, … Read more

Making the switch from Microsoft Office to Web apps

The only reason I've opened Microsoft Outlook or any other desktop e-mail program in the last year is to test tips. Since I added my ISP account to my Gmail in-box, and moved my Outlook appointments to Google Calendar, I get all the information I need in my browser.

Now I'm getting ready to boot Word, Excel, and PowerPoint for their Web alternatives, but before I bail on Office entirely, I stuck a toe in the Web-apps water by using the free ThinkFree Online service irregularly over the past few weeks. So far, I haven't missed Word, … Read more

Expand your file-protection options via Microsoft Office 2007's Trust Center

One of the most notable additions to Microsoft's 2007 Office System was the Trust Center, which centralizes the security options in Word, Excel, Outlook, PowerPoint, and the other applications in the suite. Of course, this being Office, it figures that many of the most important security features--including the new Document Inspector--also reside elsewhere.

To open the Trust Center in the 2007 versions of Word, Excel, PowerPoint, and Access, click the Office button, select the Options button at the bottom-right of the window, choose Trust Center in the left pane, and click the Trust Center Settings button in the right … Read more

Stay safe while using Microsoft Office 2003

You trust Microsoft Office with your most important documents, spreadsheets, e-mail, and presentations. Unfortunately, many of the default security settings in Office applications may not provide a sufficient level of protection for your data, your system, and your reputation. Follow these steps to fine-tune the security settings in Office 2003; tomorrow I'll cover the new security options in Office 2007's Trust Center and elsewhere.

Office 2003 lets you encrypt files so that you need a password to read or edit them. In Word 2003, open the document and click Tools > Protect Document. To restrict the styles that … Read more

A partial cure Microsoft Word 2007 crashes: disable add-ins

A funny thing happened after I installed Windows Vista Service Pack 1 on my PC: Word 2007 started crashing whenever I closed it, and all but a handful of the application's settings became inaccessible.

I still haven't figured out how to keep Word from crashing on exit, but I regained access to the program's settings by disabling all add-ins. Unfortunately, it took me the better part of an afternoon to figure out this partial solution, and I'm no closer to finding the source of the crashes, though Vista SP1 is the prime suspect.

My first attempt … Read more

Move your e-mail out of Outlook and into the folders of your choice

There's something about Microsoft Outlook that reminds me of the old Soviet Union: the program wants to centralize everything and store it in one big PST file that only it can access. There may be advantages to this approach to managing your e-mail, contacts, tasks, and calendar, but you know what can happen when you put all your eggs in one basket.

That's why it makes sense to move copies of your important Outlook files to folders that live outside the Office system. Saving messages and other data to local storage is relatively easy, whether you move them … Read more

Your options for placing Excel data in Word

Whenever you move data from Microsoft Excel to its Office mate Word, it seems there's always a compromise involved: If the formatting makes the transition intact, then changing the data either causes problems or simply can't be done. If you can alter the data, either the formatting is a mess, or the resulting Word document is huge. Here are the advantages and disadvantages of the various ways to add Excel data to a Word document, starting with the simplest.

Copy the cells and paste them as a Word table: If your Excel worksheet is formatted simply, and you … Read more

Let viewers set the pace of your PowerPoint presentations

It's your presentation, and you have every right to control its pace by deciding when to move to the next slide. But there are times when you want to let the presentation run itself, or you may want to allow the person viewing it to decide when to move to the next slide (or maybe even a little of both). You can convert any PowerPoint presentation into a self-running slide show, or add controls that let the viewer go to the next slide, with just a few simple settings.

Once you've finished putting your presentation's slides in … Read more