January 3rd, 2008

Posted by Robin Harris

Office 2003 Service Pack 3, which was made available in September, blocks a lengthy list of word-processing file formats, including Word 6.0 and Word 97 for Windows, and Word 2004 for Macintosh. It also blocks older versions of Excel, PowerPoint, Lotus Notes, Corel Quattro spreadsheet, and Corel Draw graphics package.

daily dose cialis

On releasing the service pack, Microsoft said one of its main benefits was that it would make it easier to interoperate with Microsoft's latest operating system, Vista, and its latest productivity suite, Office 2007. The older file formats that are now blocked are in decreasing day-to-day use, but the blocking of them will make retrieval of archived material more difficult.

The changes were revealed in a Microsoft support document, which was uploaded to its site in December. Users were given no warning of the effects when they downloaded SP3.

In the support document, Microsoft said SP3 blocked access to those formats because they were less secure than newer versions. "By default, these file formats are blocked because they are less secure. They may pose a risk to you," it said.

Microsoft released details of a work-around to restore access. The work-around requires changes to the registry, which could render a PC unusable if carried out incorrectly.

The work-around was branded by one critic on tech Web site Slashdot as "mind-bogglingly complex."

Other users responded negatively to the change. A system administrator at a U.K. university, who asked not to be named, called it "a money-making exercise," adding that it would cause a problem to the central IT resource not to have access to some older file formats but that the effect would be greater on other less "progressive" departments within the university.

Microsoft could offer no comment at the time of writing on why it had blocked access to the file formats.

Richard Thurston of ZDNet UK reported from London.

Ever wish you had your gridlines, column letters and row numbers on the printout of an MS Excel worksheet?

On some of the larger worksheets or on worksheets where there aren't a lot of labels on the data, this tip could be the little "miracle" you've been looking for. Okay, maybe the word miracle is a bit strong, daily cialis results but then again, it all depends on how lost you've become in your data. It's all in the perspective!

I know sometimes I just have to see it in print to find the mistakes. If only that would ensure I could catch them all. I don't know about you, but some days, my mistake list seems endless!

At any rate, once you've made the decision that you need your gridlines and/or headings, your solution is just a few clicks away.

For people using older versions of Excel, your solution is found in the Page Setup information. So, we'll begin by going to the File menu, Page Setup choice.

Once the Page Setup window opens, you're looking for the Sheet tab.

In the middle section, called Print, you're looking for the Gridlines and Row and Column Headings checkboxes.

Make sure you select the items you need.

Click OK.

For Excel 2007 users, you need the Page Layout ribbon.

Check the Print box for Headings and/or Gridlines as necessary.

There you have it. All the labels and gridlines you could ever want!

Now, you know where to find everything!

Here's a little tidbit that comes from a reader's question!

The reader was having difficulty with MS Excel's column labeling cialis wiki feature. Instead of letters for column headers, she had numbers.

(Did you notice the cell name given in the corner? Obviously not what most of you are used to).

It was driving her crazy, because it didn't match the other systems she worked on at school and/or work.

So, what's the deal here? Is the one system just "out of whack" or what?

Can it be "fixed?"

Good questions!

Yes, it can be fixed!

To retrieve your beloved letter headings, simply begin with Excel's Options.

For older versions of Excel, they're found via the Tools menu, Options choice.

In the Options dialogue window, you're looking for the General tab.

In Excel 2007, you need the Excel Options button, which is located in the bottom right corner of the Office Button menu.

You need the Formulas section under Excel's options.

In any version, you'll need to uncheck the "R1C1 reference style" box.

Click OK.

Poof!

Your missing letters have been returned. If only everything could be so easy to retrieve!

Have you ever had an MS Excel workbook that you're constantly working in, making the same changes to several different worksheets?

What did you do?

Did you go to the first sheet, make changes, move to the next sheet, make the same changes, move to the next sheet, make the same changes again and so on?

How tiresome was that?

Want a quicker way to make identical changes on different sheets?

Maybe a way that allows you to make just one set of changes that will include all of the necessary worksheets?

Sounds too good to be true, doesn't it?!

Well, there's no need to pinch yourself. You're not dreaming. It can be done and it doesn't require any special feature or function. You just have to know about a couple extra clicks!

Ready to get started?

Yes?

Good, let's get going!

• The first thing you need to do is go to the first worksheet to be changed/edited.

• Next, you need to select the sheet tabs of all the worksheets that need the same changes.

  • To select a series of tabs, hold down the Shift key and click on the last sheet tab in the series. You should see that the first, last and all tabs in between are selected simultaneously.

  • If you have non-consecutive sheets to change, hold down the Ctrl key and click on the tab for each sheet cialis wholesale to be changed.

• Once you have all the tabs selected, you're ready to begin your changes.