Yesterday's topic of formulas linked one workbook to another and as you may recall, in the end, MS Excel kept asking if you wanted to update the information. That's not necessarily a bad thing, but if you control both workbooks and you know there's no security problem, it can get somewhat annoying.

So, you must be asking, "Can I get Excel to stop asking and just go ahead with the update automatically?"

That's definitely a good question, so let's get right down to it. Should you decide that updating is always the right thing to do and you want Excel to stop asking and just do it, simply follow these easy steps.

If you're using Excel 2003 or older:

• Go to the Tools menu, Options choice.

• Under the Edit tab, uncheck the "Ask to Update Automatic Links" checkbox.

  

• Click OK.

• You need to start with the Office Button and then click on the Excel Options button found there.

• Once you're in the Excel Options dialogue window, you need to go to the Advanced Options, "When calculating this workbook" section.

  

• Uncheck the "Update links to other documents" choice.
  overnight viagra />
  

• Click OK.

Date: April 9th, 2008

Author: Greg Shultz

If you like using the Quick Launch toolbar but wish that it did not take up so much room on the taskbar, you can easily move the Quick Launch toolbar to any other location on the desktop. You can move it to the top, left, or right edge of the desktop. Here’s how:

After you drop the Quick Launch toolbar, it may appear as a window. If it does, just perform the drag-and-drop operation again making sure that toolbar anchors to the edge of the desktop. You may then need to resize the toolbar. Once you have it positioned where you want, right-click on the toolbar and select the Always On Top command so you can always access the Quick Launch toolbar just as you do the taskbar.

Note: This tip applies to Windows XP organic viagra Home and Windows XP Professional.

April 8th, 2008

Posted by Mary Jo Foley

Microsoft is set to begin a pilot of a new Genuine Advantage anti-piracy mechanism for Office that will add a “nag-like” feature, akin to what is now part of Windows Vista, to Office.

Office ordering viagra already currently includes an Office Genuine Advantage (OGA) validation mechanism (for Office XP and Office 2007), but Microsoft doesn’t do a whole lot to “punish” those it deems to be running non-Genuine versions of Office. However, as part of a new OGA notifications pilot program — which Microsoft is launching in Chile, Italy, Spain and Turkey, according to an April 8 announcement buried in a Q&A on Microsoft’s Web site — Microsoft is set to turn up the unpleasantness a notch.

I asked Microsoft to explain what will happen in the new pilot. According to Cori Hartje, Director Genuine Software Initiative:

“Today, in current OGA validation process, there is no visual & persistent representation within the experience of being a non-genuine Office user. The outcome for being non-genuine today is that the user does not gain access to Office templates and other downloads. In the pilot the non-genuine copy of Office will also have an icon on the toolbar or ribbon indicating that it is non-genuine.

“Specifically, users of non-genuine Office in the pilot areas will receive a pop-up dialog box alerting them their Microsoft Office software is not genuine. The customer will receive this dialog box the first time they open an Office application each day, and again two hours later for a period of 30 days. They will also receive information on how to learn more about the issue, and how to acquire genuine Microsoft Office. After receiving these dialog box notifications for 30 days, Office applications will be marked with a visual reminder that the copy of Office is not genuine. Both the dialog box and/or the visual reminder will disappear once the customer gets genuine Office and/or uninstalls the non-genuine Office products. None of the visual cues presented will impair a customer from accessing their data or preparing documents.”

In other words, the new OGA nagging won’t be like the old Windows kill switch. Instead it will be the kinder and gentler nagging which Microsoft adopted with Vista Service Pack (SP) 1.

There’s no exact timeframe I can find for how long the pilot will last or when Microsoft will broaden it to other countries. Microsoft says it will be delivering the new OGA notification mechanism via a “voluntary Microsoft update.” More fine print on the new OGA notification pilot:

“There will be no personal data collected or shared with Microsoft as customers implement the OGA notifications update. These notifications are designed to help alert customers who have acquired and are using non-genuine Office. Once notified, customers can take action to reduce the risk of running counterfeit software by getting genuine Office through the online purchase programs or by going to a local authorized Microsoft reseller.”

Bottom line: Get ready for more nagging if you’re either an Office pirate or deemed to be one by Microsoft.

Yesterday, we discussed how to write MS Excel formulas that reference cells located on a different worksheet within your workbook. Well, the next logical thing to do is go one step further and ask: how do we write formulas that reference cells from a completely different workbook?

That's a very good question and it's exactly what we're going to go over today!

The order viagra online uk easiest way to tackle this one is to let Excel do the referencing for you. So, begin by opening both the workbook with the data cells and the one that will contain the formula.

Now, go to the cell that contains the formula and begin as usual. That is, start with your equal sign and/or function and pause at the first place in the formula where you're looking to pull data from a different workbook.

For example:

=sum(

Next, you need to switch to the workbook that contains the data. (For all you keyboard people out there, Ctrl + F6 will rotate you through the open workbooks).

Once you're switched over to the data workbook, highlight the cell(s) that contain the needed information.

Now, you'll need to switch back to the formula workbook (Ctrl + F6 works here too).

When you return, you should see that Excel has automatically put in the reference you were looking for from the other workbook.

• If both workbooks are open, the data changes will immediately be reflected.

• If the data workbook is open when you open the formula workbook, the updates will be reflected upon opening the file.

• Now, here's the most involved situation:

  • If you're using Excel 2003 or older and you're opening the formula workbook without the data workbook being open, you will be asked if you want to update your formulas, like this:

    

    If you choose to update, Excel will then go into the data file and get the information it needs, without actually opening the workbook.

  • If you're using Excel 2007 and you're opening the formula workbook without the data workbook being open, you will see a security warning above the formula bar, like this:

    

    Clicking on the Options button will open this dialogue window:

    

    Choose "Enable this content" and click OK.

    Again, as with the other versions of Excel, if you choose to update, Excel will go into the data file and get the information it needs, without actually opening the workbook.

• 80 keyboard shortcuts for moving faster in Microsoft Word 2003
• 85 keyboard shortcuts for moving faster in Microsoft Excel
• order viagra on line href=”http://ct.techrepublic.com.com/clicks?t=46827981-fcda8243b2af06197976dd4e0ab0dea0-bf&brand=TECHREPUBLIC&s=5″ title=”http://ct.techrepublic.com.com/clicks?t=46827981-fcda8243b2af06197976dd4e0ab0dea0-bf&brand=TECHREPUBLIC&s=5″>50+ Keyboard shortcuts to move faster in Microsoft PowerPoint
• 70+ Keyboard shortcuts to move faster in Microsoft Access
• 80+ Keyboard shortcuts to move faster in Microsoft Outlook