Microsoft KB Archive/182498

{| The information in this article applies to:
 * width="100%"|
 * Microsoft Excel 98 Macintosh Edition

SUMMARY
MS Excel Readme is a text file that contains supplemental information about installing and using Microsoft Excel 98 Macintosh Edition. The "More Information" section of this article contains the complete text of this file, which is installed in your Microsoft Office 98:Readme folder.

MORE INFORMATION
MICROSOFT EXCEL 98 README FILE

(c) 1998 Microsoft Corporation. All rights reserved.

This document provides late-breaking or other information that supplements the Microsoft Excel 98 documentation. You will get the best results while viewing tables in this document if you open it in Microsoft Word.

Supplemental information for Visual Basic for Applications and Forms 2.0 is available in the MS VBA Readme file, which is located in the More Help folder in the Value Pack folder on your Microsoft Office 98 CD.

_________________________________________________________________

CONTENTS

INSTALLING MICROSOFT EXCEL 98 Minimum System Requirements for Microsoft Excel 98 and Microsoft Office 98 Performance with System 7.5.2 and 7.5.3 Using Punctuation Characters in Folder Names May Cause Problems Microsoft Excel Installer Overwrites 128-bit Version of Internet Explorer File MS Internet Library (PPC) MICROSOFT EXCEL 98 MEMORY AND PERFORMANCE ISSUES MICROSOFT EXCEL 98 HELP Using the Keyboard to Select Options in the Office Assistant Welcome Balloon Help Topics Graphics Don't Print Clearly Correction to MS Excel Help Topics Correction to MS Excel Upgrade Help Topics Correction to MS Clip Gallery Help Topics WORKING WITH MICROSOFT EXCEL 98 'Out of Memory' Message When Saving File as Microsoft Excel 5.0/95 Workbook Microsoft Excel 5.0 and Microsoft Graph 5.0 Custom Chart Types Don't Appear in Excel 98 and Graph 98 Microsoft Graph 97 Object Formatting Appears Incorrectly Clip Gallery Doesn't Preserve Graphic Image Transparency Internet Explorer Using Netscape Navigator and Hyperlinks in Office Shortcut Keys May Not Work with Non-U.S. Keyboard Layouts Using Microsoft Office 98 with Symantec AntiVirus for Macintosh MICROSOFT OFFICE 98 VALUE PACK Cannot Install Value Pack Components if Running Office Programs from the CD or a Network Message Appears When Using Microsoft Query for the First Time in        Microsoft Excel Error Adding Text or dBASE Tables in Microsoft Query Copy Value Pack:Clip Art:Overview File to Hard Disk and Run with CD in Drive Correction to Phone Number for Palo Alto Software

_________________________________________________________________ INSTALLING MICROSOFT EXCEL 98

Minimum System Requirements for Microsoft Excel 98 and Microsoft Office 98
To use Excel 98 or Office 98, you need:


 * Any PowerPC processor-based, Mac OS-compatible system.
 * Apple System 7.5 or later.
 * 16 MB of RAM required to run Excel individually (with virtual memory turned on); more memory is required to run additional programs simultaneously.
 * 24 MB of RAM required to run Excel individually from a network or from the CD; more memory is required to run additional programs simultaneously.
 * 33-78 MB of available hard disk space to install the Excel standalone program; approximately 55 MB required for Easy Install, depending on the configuration.
 * 48-148 MB of available hard disk space to install Microsoft Office; approximately 90 MB required for Easy Install, depending on the configuration.
 * CD-ROM drive required (or connection to a Local Area Network if installing over network).
 * Monitor or display supporting 16 grays or 256 colors and 640x400 or greater resolution.

To use Excel 98 or Office 98, it is *recommended* that you have:
 * A PowerPC processor with a clock speed of at least 120 MHz.
 * Apple System 7.5.5 or later.
 * 32 MB of RAM (don't have to have virtual memory turned on).
 * Color monitor or display supporting greater than 256 colors and 640x480 resolution.

Performance with System 7.5.2 and 7.5.3
Updates are available for versions 7.5.2 and 7.5.3 of the system software that contain substantial performance enhancements and improvements. These updates are strongly recommended by Apple for all Macintosh computers running previous releases of System 7.5 because they contain bug fixes and allow Power Macintosh programs to launch significantly faster when virtual memory is on. The updates to System 7.5.3 and System 7.5.5 are available in the Value Pack folder on your Microsoft Office 98 CD. For more information about installing components from the Value Pack, see the About the Value Pack file in the Value Pack folder on the CD-ROM or on the network you installed Excel or Office from.

Using Punctuation Characters in Folder Names May Cause Problems
If the name of the folder you install Microsoft Office 98, Microsoft Excel 98, Microsoft PowerPoint 98, or Microsoft Word 98 into includes a comma, single quotation mark ('), or exclamation point (!), you may have problems when you use the programs. To avoid problems, use the default folder or use only letters and numbers in folder names.

File MS Internet Library (PPC)
If you have the 128-bit version of Microsoft Internet Explorer installed on your Macintosh when you install Microsoft Office 98 or Microsoft Excel 98, the file MS Internet Library (PPC) is replaced by a newer, 40-bit version of the file with the same file name. This version of the file works fine with both Internet Explorer and Office 98 Web features.

To see if there is a new 128-bit version of Internet Explorer that is compatible with Microsoft Office 98, to replace the 40-bit version of the file MS Internet Library (PPC), you can visit the Internet Explorer Download Web site at

http://www.microsoft.com/ie/download/128bit.htm ________________________________________________________________ MICROSOFT EXCEL 98 MEMORY AND PERFORMANCE ISSUES

The following is a list of symptoms that may occur if there is not enough memory available in Excel. If you are receiving any of these symptoms, you can increase the memory requirements for Excel by doing the following:


 * 1) Quit Excel.
 * 2) From the desktop, double-click the hard disk icon.
 * 3) Double-click the folder you installed Office 98 in, usually Microsoft Office 98.
 * 4) Click the Microsoft Excel icon.
 * 5) On the File menu, click Get Info.
 * 6) Under Memory Requirements, increase the value in the Preferred Size box by the amount listed below for the symptom you are experiencing.

When you use a wizard, you may receive a run-time error. SOLUTION: Increase the memory requirements for Excel by 2000K. If you use more than one wizard, each wizard uses additional memory, so you may need to further increase the memory requirements for Excel to accommodate the additional wizards. When you use the Visual Basic Editor, you may receive a low-memory message. SOLUTION: Increase the memory requirements for Excel by 2000K. Help topics that contain graphics may display the message "Unable to display picture." SOLUTION: Increase the memory requirements for Excel by 725K. NOTE: If you have large or complex documents, and increasing the memory requirements for Excel does not address the symptoms described above, continue increasing the memory until the symptoms disappear.

MICROSOFT EXCEL 98 HELP

Balloon
When you start Microsoft Excel for the first time, the Office Assistant shows a Welcome balloon with three options. You cannot start using Excel until you select the third option, or press ESC to close the balloon. To select an option using the keyboard, press COMMAND+1 to select the first option, COMMAND+2 to select the second option, or COMMAND+3 to select the third option.

NOTE: You may not be able to use the keyboard to select these options on a non-U.S. keyboard, such as Italian, if the numeric keys are available only when you hold down the SHIFT key.

Help Topics Graphics Don't Print Clearly
When you print a Help topic that contains a graphic, the graphic may not print clearly. In particular, this occurs when you print a topic with grayscale colors using a printer driver that does not have options to control dithering.

Correction to MS Excel Help Topics
The "Encapsulated PostScript (EPS) graphics filter" topic in the MS Excel Help file incorrectly states that the filter supports Encapsulated PostScript images with Windows Metafile (WMF) embedded previews. Although the image prints correctly, the embedded Windows Metafile (WMF) preview does not appear on the screen when you insert the graphic.

Correction to MS Excel Upgrade Help Topics
The "Toolbars, graphics and integration with Microsoft Office" topic in the MS Excel Upgrade Help file mentions the Office Shortcut Bar. There is no Office Shortcut Bar in Microsoft Office 98.

The "Microsoft Excel on the Web" topic in the MS Excel Upgrade Help file mentions the Web Form Wizard. There is no Web Form Wizard in Microsoft Excel 98.

Correction to MS Clip Gallery Help Topics
The "File formats the Clip Gallery can import" topic in the MS Clip Gallery Help file incorrectly states that the Clip Gallery supports the QuickTime MPEG File Format. The Clip Gallery cannot import this file format.

The "Clip Gallery databases" topic in the MS Clip Gallery Help file incorrectly states that the Clip Gallery database -- called the primary database -- is stored in Macintosh HD:Microsoft Office 98:Office:Art Gallery. The Clip Gallery database is actually stored in Macintosh HD:System Folder:Preferences:Clip Gallery User Database.

The "Create a shared Clip Gallery database and configure a user's computer to access it" topic in the MS Clip Gallery Help file gives the incorrect name and location for the Clip Gallery database file. The corrected steps in this topic should read as follows:

Create a shared Clip Gallery database

 To use the existing Clip Gallery database file, Clip Gallery User Database, as a shared database, go directly to step 8. To create a shared Clip Gallery database from scratch, from the desktop, open the Macintosh HD:System Folder:Preferences folder. Click the Clip Gallery User Database icon, and then type a new name for this file, such as Clip Gallery User Database Old, to keep as a backup.  Open the Clip Gallery from within any program. The Clip Gallery creates a new empty Clip Gallery database file named Clip Gallery User Database. Step 7 should read as follows: 7. From the desktop, copy the new Clip Gallery User Database file to a central location on the shared disk. 

________________________________________________________________ WORKING WITH MICROSOFT EXCEL 98

'Out of Memory' Message When Saving File as Microsoft Excel 5.0/95 Workbook When you save a workbook in the Microsoft Excel 5.0/95 Workbook format that contains a graphic, you may receive the message "Out of memory" and the graphic may not appear when you open the saved workbook. This behavior occurs with compressed graphic files and high-resolution graphic files when the resolution of the graphic is very high. To avoid receiving this message and losing the graphic, do the following before you save the workbook in the Microsoft Excel 5.0/95 Workbook format:


 * 1) Select the graphic.
 * 2) On the Edit menu, click Cut.
 * 3) On the Edit menu, click Paste Special.
 * 4) In the Paste As list, click Picture.

in Excel 98 and Graph 98
If you created custom chart types in either Microsoft Excel 5.0 or Microsoft Graph 5.0, the custom chart types are not automatically available in Excel 98 or Graph 98. To view the custom chart types you created in Excel 5.0 or Graph 5.0 in Excel 98 and Graph 98, do the following before you create custom chart types in Excel 98 or Graph 98:


 * 1) From the desktop, double-click the hard disk icon.
 * 2) Double-click the System Folder icon.
 * 3) Double-click the Preferences icon.
 * 4) Double-click the Excel Startup Folder 5.
 * 5) Arrange the folders so you can see both the Preferences and the Excel Startup Folder 5 folders.
 * 6) Locate the Excel Chart AutoFormats (5) icon in the Excel Startup Folder 5 folder, and then drag this file to the Preferences folder.
 * 7) Click the Excel Chart AutoFormats (5) icon name.
 * 8) Type the new name, "Excel Chart User Gallery" (without the quotation marks), and then press RETURN.
 * 9) Locate the Graph Chart AutoFormats (5) icon in the Preferences folder and click its name.
 * 10) Type the new name, "Graph Chart User Gallery" (without the quotation marks), and then press RETURN.

The custom chart types you created in Excel 5.0 and Graph 5.0 now appear on the Custom Types tab in the Chart Type dialog box when you select the User- defined option in Excel 98 and Graph 98.

Microsoft Graph 97 Object Formatting Appears Incorrectly
When you open an Excel workbook that contains a Microsoft Graph 97 object created in Microsoft Windows, some of the chart formatting may appear incorrectly. To correct the formatting, double-click the chart to open it in Microsoft Graph 98.

Clip Gallery Doesn't Preserve Graphic Image Transparency
When you import a graphic image into the Clip Gallery, alpha channel information is not preserved. A result of this behavior is that when you insert a Clip Gallery image into your Office document, the transparency of the image may be lost. To preserve the transparency of an image, point to Picture on the Insert menu, and then click From File to insert your image.

Internet Explorer
If you currently use Internet Explorer version 4.0, please upgrade to version 4.0a. Internet Explorer version 4.0a is included on the Office CD, or you can download the latest version from the Web at:

http://www.microsoft.com/ie/mac

Using Netscape Navigator and Hyperlinks in Office
If you use Netscape Navigator as your Web browser, you may receive the following message when you click a hyperlink or open a Web page in an Office program: "Office cannot open the URL you specified. Make sure you have a web browser installed and that it is configured correctly." This message appears because Netscape has not been registered in the Internet Preferences file. To avoid receiving this message, do the following:


 * 1) On the Apple menu, point to Control Panels, and then click Configuration Manager.
 * 2) In the list on the left, under Network, click Protocol Helpers.
 * 3) In the Protocol list, click File, and then click Change.
 * 4) Click Choose Helper.
 * 5) Locate and double-click the Netscape Navigator program file.
 * 6) Repeat steps 3-5 for the following protocols: ftp, gopher, http, and https.
 * 7) In the list on the left, under Network, click Proxies.
 * 8) Make sure that your proxy setting information is the same as in Netscape Navigator.

NOTE: You must quit and restart any Office programs that are running before this change takes effect. You can also use the Internet Config application to register Netscape Navigator in the Internet Preferences file. Instructions for obtaining and using Internet Config can be found at:

http://www.stairways.com/ic/index.html

Shortcut Keys May Not Work with Non-U.S. Keyboard Layouts
Shortcuts keys may not work in Microsoft Excel if you are using a keyboard layout other than U.S., such as Arabic. To use shortcut keys, change the keyboard layout to U.S. If you have multiple keyboard layouts selected in the Keyboard dialog box, including U.S., click U.S. on the Keyboard menu. If the Keyboard menu does not appear on the menu bar or if U.S. is not listed on the Keyboard menu, do the following:


 * 1) From the desktop, point to Control Panels on the Apple menu, and then click Keyboard.
 * 2) In the list of keyboard layouts, select the U.S. check box.
 * 3) Close the Keyboard dialog box.
 * 4) On the Keyboard menu, click U.S.

For information about using shortcut keys in Excel, use the Office Assistant or the Help Index to search for "shortcut keys." For more information about changing the keyboard layout, see the documentation that came with your Macintosh.

Using Microsoft Office 98 with Symantec AntiVirus for Macintosh
Microsoft Office 98 is incompatible with Symantec AntiVirus for Macintosh virus definitions released before February 1998. If you are using one of these older SAM virus definition files and you cannot immediately download the latest update, you should disable the SAM Intercept extension in Extensions Manager before you run any of the Office applications.

For additional information and the latest SAM definitions, check the Symantec Web site at:

http://www.symantec.com ________________________________________________________________ MICROSOFT OFFICE 98 VALUE PACK

or a Network
If you run a Microsoft Office program from the CD or network drive instead of installing it to your hard disk, you cannot use the Value Pack Installer to install Value Pack components. The Value Pack Installer requires that your Office programs be installed on your hard disk because, to work correctly, Value Pack components must be located in specific folders on your hard disk relative to the rest of the Office files.

Excel
If you install Microsoft Query from the Value Pack (Data Access component), a message appears the first time you use the Create New Query or Run Database Query command (Data menu, Get External Data command) in Microsoft Excel. The message incorrectly states that Microsoft Query has not been installed. However, if you use the command a second time, Microsoft Query will start correctly and you will not receive the message again. This problem only occurs the first time you use Microsoft Query in Microsoft Excel.

Error Adding Text or dBASE Tables in Microsoft Query
If you have problems adding tables with the text or dBASE ODBC drivers, refer to the following articles in the Microsoft Knowledge Base:

Q179108 XL98: Problems Adding dBASE Database in Microsoft Query

Q179660 XL98: Problems Adding Text Database in Microsoft Query

To obtain any of these articles from Microsoft Technical Support on the World Wide Web, follow these steps:

  Connect to the Microsoft Support site at the following address: http://support.microsoft.com/support/default.asp NOTE: If you've never visited this site before, you will be required to register.  Search for either of the articles above using the Q number. Click Find. Click a title to view the article.</li></ol>

Drive
The Overview file located in the Value Pack:Clip Art folder is available to preview and copy clip art files to the Clipboard. Copy the Overview file to your hard disk and view the clip art files while the CD is still in your CD- ROM drive. The Overview file searches for the clip art files located on the CD.

Correction to Phone Number for Palo Alto Software
The Small Business Pack templates, installed as a component of the Value Pack, were originally developed by Palo Alto Software. The phone number listed for Palo Alto Software is incorrect. The correct number is (541) 683- 6162.
 * }

-

Last reviewed: March 30, 1998

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.