Datasheet

10. In the Edit DWORD Value dialog box, click the Decimal option, and type 1 in the Value
data field.
11. Click OK to enter the value.
Figure 26-2 shows the Registry Editor after I made the change.
Figure 26-2: The Registry Editor, with a new setting that disables the hyperlink warning message.
After performing these steps, restart Excel. The new setting takes effect. By the way, this
change affects all Microsoft Office 2007 applications.
Even after making this change, you may still get a warning when you click a hyperlink for
a certain type of file. For example, after I made this modification, I still saw a warning
when I clicked a hyperlink for an MP3 music file. I had to make another change for this
particular file type:
1. Double-click the My Computer icon to open an Explorer window.
2. Choose Tools ➪ Folder Options.
3. Click the File Types tab.
4. In the Register File Types list, select the extension for the type of file that’s generating
a hyperlink warning (for example, MP3).
5. Click Advanced to display the Edit File Type dialog box.
Tip 26: Disabling Hyperlink Warnings
67
Part I
04_137666 ch01.qxp 5/22/07 7:31 PM Page 67