(To view best on-screen in Windows Notepad, maximize the Notepad window and turn on wordwrap if it is not already on -- from the Edit menu, choose Word Wrap. For best printed results, open this document in Windows Write, Microsoft Word, or another word processor, select the entire document and format the text in 10 point Courier before printing.) --------------------------------------- Microsoft Excel Version 4.0 README File --------------------------------------- Contents File Compatibility with Previous Microsoft Excel Versions Macro Compatibility with Previous Microsoft Excel Versions Out of Memory Message After Quitting Microsoft Excel Additional Credit: Greymatter International, Inc. Modifying the Path Command in Your AUTOEXEC.BAT File Run Online Tutorials from a Read-Write Directory OPEN.DIALOG and SAVE.DIALOG Functions Q+E and SQL Server Compatibility Word for Windows 2.0 Print Merge and Microsoft Excel 4.0 Worksheets Documentation Errata Microsoft Excel 4.0 Directory/File Layout --------------------------------------------------------- File Compatibility with Previous Microsoft Excel Versions --------------------------------------------------------- Microsoft Excel version 4.0 reads all existing Microsoft Excel version 2.x and 3.0 documents. However, documents saved in Microsoft Excel version 4.0 format cannot be opened in Microsoft Excel version 3.0a or earlier. To open a document in an earlier version of Microsoft Excel, choose the Save As command from the File menu, and select the "Excel 3.0" or "Excel 2.1" file format. NOTE: You may lose some formulas and formatting when the document is saved in an earlier format. ---------------------------------------------------------- Macro Compatibility with Previous Microsoft Excel Versions ---------------------------------------------------------- Macros developed in previous versions of Microsoft Excel are fully compatible with Microsoft Excel version 4.0. ---------------------------------------------------- Out of Memory Message After Quitting Microsoft Excel ---------------------------------------------------- If you use Microsoft Windows 3.0, and you receive an out of memory message when you attempt to start an application after quitting Microsoft Excel, try starting the application again. This does not occur under Microsoft Windows 3.1. ------------------------------------------------- Additional Credit: Greymatter International, Inc. ------------------------------------------------- The following credit was inadvertently omitted from the Microsoft Excel User's Guide, Book 2: The Microsoft Excel Analysis ToolPak was developed by GreyMatter International, Inc., 173 Otis Street, P.O. Box 388, Cambridge, MA 02141. ---------------------------------------------------- Modifying the Path Command in Your AUTOEXEC.BAT File ---------------------------------------------------- If you choose not to have Microsoft Excel Setup modify your AUTOEXEC.BAT file, you can modify the file yourself. Specifically, you must modify the Path command to list the directory containing the Microsoft Excel program (EXCEL.EXE) and associated files. To modify the Path command, open the AUTOEXEC.BAT file in any text editor or word processor. To add a directory to the list, add the full pathname (drive letter, directory name). Pathnames must be separated by semicolons. To add a directory named EXCEL, you would add ;c\excel to the line in AUTOEXEC.BAT headed by "path". For example, path c:\dos;c:\windows;c:\myfiles;c:\excel Note: If you run Microsoft Excel from a network server, you must include ---- the server directory containing EXCEL.EXE, in the Path command of your workstation's AUTOEXEC.BAT file. When you finish editing the file, save it in a text-only format. You must restart your computer for the changes to take effect. For more information about the Path command and the AUTOEXEC.BAT file, see your MS-DOS manual. ------------------------------------------------ Run Online Tutorials from a Read-Write Directory ------------------------------------------------ To run the online tutorials, Microsoft Excel must save current workspace settings. To do this, the current directory must be a read-write directory. If not, you will receive a message that Microsoft Excel cannot save the information, and the tutorials will not run. ------------------------------------- OPEN.DIALOG and SAVE.DIALOG Functions ------------------------------------- These two macro functions were inadvertently omitted from the Microsoft Excel Function Reference. The functions become available when you install the FILEFNS.XLA add-in macro. You can learn about the functions in online Help. The quickest way to reach the information is to: 1. Double-click the Help tool. Microsoft Excel displays the Help Search dialog box. 2. In the text box, type: file functions 3. Choose the Go To button. -------------------------------- Q+E and SQL Server Compatibility -------------------------------- If you are using SQL Server 4.2 or greater and have installed Q+E, remove the following two files from your Excel directory: W3DBLIB.DLL DBNMP3.DLL These versions of the files are not compatible with SQL Server 4.2. Newer versions of these files are installed with SQL Server 4.2 and should be copied to your Windows \SYSTEM directory where they can be shared by Q+E as well as your other SQL Server applications. ------------------------------------------------------------------- Word for Windows 2.0 Print Merge and Microsoft Excel 4.0 Worksheets ------------------------------------------------------------------- If you intend to use the Microsoft Word for Windows 2.0 Print Merge command with a Microsoft Excel version 4.0 worksheet, you must first save the worksheet in Excel 3.0 file format. -------------------- Documentation Errata -------------------- The following errors in printed documentation were discovered after the books were delivered for printing. Please mark the changes in your copies of the books. We apologize for any inconvenience. Manual: Microsoft Excel User's Guide, Book 1 Chapter: 5, Creating a Worksheet Section: Moving Within and Selecting Blocks of Cells Page: 98 In the procedure "To select multiple blocks of cells," step 2, second paragraph, delete the word "include." Section: Editing Cell Entries Page: 119 The second sentence should read: "If you cut characters from the formula bar, click the enter box or press the ENTER key." Chapter: 6, Editing a Worksheet Section: Copying Cells Page: 183 In the "Important" section, first line, "move" should read "copy." In the last line, "Cut" should read "Copy." Chapter: 7, Formatting a Worksheet Section: Creating and Deleting Custom Formats Page: 221 In the last two entries in the table, "Any number or text" should read "Any number." Chapter: 8, Organizing and Documenting a Worksheet Section: Checking Names Page: 297 In the "Caution" section, fourth line, "two additional columns" shoud read "three additional columns." In the sixth line, add "3 indicates macro command category," after "a command macro,". Chapter: 9, Creating and using a Database on a Worksheet Section: Finding and Deleting Records with a Data Form Page: 319 In the last line of the second to last paragraph, =smith should read ="=smith" (quotes must be included as shown). Chapter: 10, Analyzing and Reporting Database Information Section: Entering Multiple Criteria Page: 335 The Note at the bottom of the page should read "To format postal codes . . . with leading zeros," not "To format postal codes . . . with leading zeros as text," Section: Extracting Data to an Extract Range Page: 341 In the procedure "To extract data from the database," the second step should read "Define or select the extract range" not "Define the extract range." Chapter: 13, Editing a Chart Section: Opening an Existing Chart Page: 435 In the paragraph after the procedure at the top of the page, last line, "Saving a Chart" should read "Saving a Document." Chapter: 15, Working with Graphic Objects Section: Preparing Graphics to Use in a Slide Show Page: 521 In step 3 of the first procedure, "Click the Copy tool" should read "From the Edit menu, choose Copy." Chapter: 16, Printing Section: Printing Reports Page: 543 In the procedure "To create a report," the third sentence under step 6 should read "If you want the pages to be numbered consecutively, select the Continuous Page Numbers check box." Chapter: 17, Using the Keyboard with Microsoft Excel Section: Command and Toolbar Shortcut Summary Page 561: In the third line of the table, "Find Next" should read "Find or Exit Find" Section: Toolbar and Tool Shortcuts Page: 566 The shortcut for the Font Name box should read CTRL+F (not CTRL+P); the shortcut for the Font Size box should read CTRL+P (not CTRL+F). Manual: Microsoft Excel User's Guide, Book 2 Chapter: 2, Performing What-if Analysis on a Worksheet Model Section: Using a Sample Worksheet Model Page: 63 Delete the "Note" paragraph. Section: Using Scenarios to Analyze Data Page: 67 In the third line of the first paragraph under the heading, change "Scenario Manger" to "Scenario Manager." Section: Generating a Report of Results and Alternate Solutions Page: 95 In the first paragraph after the illustration, the second sentence should read "One of two possible values is displayed in the Status column: Binding or Not Binding." The value "Not Satisfied" is never displayed in the Answer report. Also, delete the third bulleted paragraph immediately below. Chapter: 4, Customizing Microsoft Excel Section: More About Displaying and Customizing Toolbars Page: 16 In "Saving Additional Toolbar Setups," last line, change "FILE.OPEN" to "OPEN". Manual: Microsoft Excel User's Guide, Books 1 and 2 Section: Microsoft Support Services Page: xiv (Book 1); x (Book 2) To Netherlands/Luxembourg information, add the following electronic bulletin board number: 02503-34221. To Belgium information, add the following electronic bulletin board number: (31) 2503-34221. Page: xiv (Book 1); x (Book 2) Technical support telephone numbers for Switzerland and Liechtenstein should read as follows: Swiss and German 01/ 342.21.52 MS-DOS 01/ 342.40.36 All programming languages except: BASIC PDS, Quick Basic, Visual Basic, COBOL 01/ 342.40.81 Macintosh Software 01/ 342.40.82 Microsoft Excel for Windows, Multiplan, Powerpoint for Windows 01/ 342.40.83 Word (MS-DOS), Windows Write 01/ 342.40.84 Chart, Microsoft Works, Mouse, Flight Simulator, Paintbrush, Project (MS-DOS), Project for Windows 01/ 342.40.85 Microsoft Windows, Networks, Mail for PC Networks 01/ 342.40.86 BASIC PDS, Quick Basic, Visual Basic, COBOL 01/ 342.40.87 Word for Windows French 022/ 738.96.88 All Microsoft products Page: xv (Book 1); xi (Book 2) Technical support telephone numbers for Germany, Eastern Europe and Baltic states should read as follows: 089/ 3176-1110 Microsoft Windows 089/ 3176-1120 Microsoft Excel for Windows, Multiplan, Powerpoint for Windows 089/ 3176-1130 Word (MS-DOS), Windows Write, Pageview 089/ 3176-1131 Word for Windows 089/ 3176-1140 Chart, Microsoft Works, Mouse, Flight Simulator, Paintbrush, Easy Cad, Project (MS-DOS), Project for Windows 089/ 3176-1150 C-Compiler, Fortran, Pascal, Assembler 089/ 3176-1151 MS-DOS, Basic, COBOL 089/ 3176-1160 Macintosh Software Page: xvi (Book 1); xii (Book 2) For Canada, change the fax number to: 1 (416) 568-4689. Page: xvii (Book 1); xiii (book 2) For Japan, tech support numbers should read as follows: (81) (3) 3363-0160 MS-DOS Applications (81) (3) 3363-5040 Windows Applications (81) (3) 3363-7610 Language Products (MS-C, MASM, Quick-C) (81) (3) 3363-0170 Language Products (MS-BASIC, MS-FORTRAN, Visual BASIC) (81) (3) 3363-0160 FAX number, all products Manual: Microsoft Excel Function Reference Function: ADD.TOOL Page: 12 In the first bulleted paragraph, change "greater than 140" to "between 200 and 231". Function: APP.TITLE Page: 22 In the first bulleted item under "Remarks," insert "custom application title, followed by the" between "The" and "individual". Function: CHART.WIZARD Page: 50 Add the following sentence to the paragraph under "Remarks": "You must precede this function with a CREATE.OBJECT function if you are not using the macro recorder." Function: GET.WORKSPACE Page: 210 Under Type_num 21, "Microsoft Excel version 3.0" should read "Standard". Page 212: Under Type_num 39, add "in R1C1-text form" after "reference". Function: LAST.ERROR Page: 251 In the first line, change "reference of" to "value in"; in the fourth line, change "ERROR" to "REFTEXT". Function: RADIANS Page: 344 In the second paragraph, "Analysis ToolPak add-in macro" is incorrect. It should read "Add-in Functions" add-in macro. Function: RANDBETWEEN Page: 344 In the second paragraph, "Analysis ToolPak add-in macro" is incorrect. It should read "Add-in Functions" add-in macro. Function: SCENARIO.CELLS Page: 375 Under "Syntax," no argument is shown for the question mark version. Add the optional argument "changing_ref". Function: SCENARIO.GET Page: 376 Under "Syntax," add the following two Type_num items: 5 A horizontal array of the creation date and time, expressed as a serial number, of each scenario. 6 A horizontal array containing the user name of the person to last change each scenario. Manual: Switching to Microsoft Excel from Lotus 1-2-3 Section: Calculating 1-2-3 Formulas Page: 10 Delete "evaluates Boolean expression to a 0 or 1 but" from the second bulleted paragraph. Also, first paragraph after bulleted list should read: "When you open a 1-2-3 worksheet in Microsoft Excel, alternate expression evaluation is turned on for that sheet. This ensures that the formulas are calculated according to the preceding 1-2-3 rules." Section: Moving Worksheets, Formatting and Macros... Page: 27: Under the heading "Importing and Exporting 3-D Worksheets," add "and preserves 3-D formulas" to the first sentence. Delete the next sentence. Page 36: Under the heading "Getting Help Within Macro Prompts," change "/XI" to "/XL" in the second line. Section: Specifying Global Settings Page: 40 In step 5, first paragraph after "Caution," add "to specify the 1-2-3 and Windows directories," after "For example," in the second sentence. Other: Importing Allways Files Microsoft Excel Excel 4.0 does not support the Allways file format (.ALL). However, to import Allways formatting, open the .WK1/.ALL file in 1-2-3 rel 2.3 and then save the file. This creates a .WK1/.FMT file, which you can then open in Microsoft Excel. If you don't have 1-2-3 rel 2.3, you can open the file in 1-2-3 rel 3.1 or higher, and save the file as WK1. This will also create a .WK1/.FMT file which you can open in Microsoft Excel. This will preserve the Allways formatting. ----------------------------------------- Microsoft Excel 4.0 Directory/File Layout ----------------------------------------- Microsoft Excel version 4.0 Setup places the following directories and files on your computer's hard disk. Directories are shown in brackets []. The list reflects the installation of all options. Note: Setup places some files in your Windows directory and ---- subdirectories, as indicated below. Certain Microsoft Excel features and operations depend on these files in these locations. Please do not move or remove them. Windows main directory: WINHELP.EXE (1) WINHELP.HLP (1) Windows subdirectory: [SYSTEM] COMMDLG.DLL SHELL.DLL VER.DLL SMALLB.FON -or- SMALLE.FON -or- SMALLF.FON (2) Windows subdirectory: [MSAPPS\PROOF] MSSPELL.DLL MSSP_AM.LEX (3) MSSP_BR.LEX (3) CUSTOM.DIC (4) (1) These files are installed only if your Windows version is 3.0, and not 3.1. (2) One of these Small Fonts files is installed, depending on your video driver. Microsoft Excel requires Small Fonts in order to display text clearly in certain circumstances. A font file is installed only if your Windows version is 3.0, and not 3.1. (3) One of these files is copied, depending on whether you chose to install the American or British English dictionary during Setup. (4) This file is copied only if the file does not already exist in this directory. Contents of the Main Microsoft Excel Directory ---------------------------------------------- EXCEL.EXE README.TXT NETWORK.TXT XL4.REG XLCALL.DLL CNF2INI.EXE [XLSTART] PSS.HLP QEREADME.TXT [EXCELCBT] EXCELHLP.HLP TRANS123.XLM [LIBRARY] EXCELINI.TXT [EXAMPLES] EXCELDE.EXE TRANS.EXE TRANSMP.XLM QE.EXE QE.HLP [QE] DBNMP3.DLL QEXLA.DLL QEDBF.DLL QEXLS.DLL QEORA.DLL ORA6WIN.DLL QERDB.DLL SQSAPIW.DLL QESS.DLL W3DBLIB.DLL QETXT.DLL Contents of [EXCELCBT] ---------------------- EXOTIC.FMT PARTS.FMT SCHEDULE.FMT EXCELLES.CBT SURVEY.XLW WCOAST.XLW APERTURE.XLW BLUESKY.XLW DELI.XLW DIVISION.XLW EXCELCBT.CBT EXOTIC.WK1 PARTS.WK1 PHOTOS.XLW SALES.XLW SALESREP.XLW SCHEDULE.WK1 TOOLS.XLW YONDER.XLW CBTLIB3.DLL EXPORTS.XLW XLBASICS.CBT Contents of [LIBRARY] --------------------- FILEFNS.DLL FILEFNS.XLA [CROSSTAB] ADDINMGR.XLA [CHECKUP] REPORTS.XLA SCENARIO.XLA VIEWS.XLA ADDINFNS.XLA ALTSTART.XLA AUTOSAVE.XLA FLATFILE.XLA GLOSSARY.XLA DEBUG.XLA CHANGER.XLA SWITCH.XLA SWITCHTO.XLA WHATIF.XLA AUDIT.XLA COMPARE.XLA SUMMARY.XLA [ANALYSIS] [SLIDES] [COLOR] [SOLVER] Contents of [LIBRARY\CROSSTAB] ------------------------------ CROSSFNC.XLA CROSSTAB.XLL CROSSTMP.XLT Contents of [LIBRARY\CHECKUP] ----------------------------- CHECKUP.DLL CHECKUP.XLM Contents of [LIBRARY\ANALYSIS] ------------------------------ ANALYSF.XLA ANALYSIS.XLA ANOVA.XLA CORRELAT.XLA ENF.DLL FIN.DLL FORECAST.XLA FOURIER.XLA REGRESS.XLA STAT.DLL TESTS.XLA Contents of [LIBRARY\SLIDES] ---------------------------- SLIDES.XLA SLIDES.XLT XLSLIDES.DLL Contents of [LIBRARY\COLOR] --------------------------- AUTUMN.XLS BLACKWHT.XLS BLUERED.XLS BLUES.XLS DEFAULT.XLS DUSK.XLS PALETTES.XLA PASTEL.XLS RAINBOW.XLS REDS.XLS SUMMER.XLS SUNSET.XLS USER1.XLS USER2.XLS WINTER.XLS YELGREEN.XLS Contents of [LIBRARY\SOLVER] ---------------------------- SOLVER.DLL SOLVER.XLA SOLVREP.XLA Contents of [EXAMPLES] ---------------------- [SOLVER] AMORTIZE.XLS BILL.XLT BREAKEVN.XLS COLLEGE.XLS COLLHELP.XLM BUDGET.XLS SALETRAC.XLW STRUCTM.XLT Contents of [EXAMPLES/SOLVER] ----------------------------- EXAMPLE.XLM SOLVCHRT.XLC SOLVER1.XLS SOLVER2.XLS SOLVER3.XLS SOLVER4.XLS SOLVER5.XLS SOLVER6.XLS SOLVEREX.XLS Contents of [QE] ---------------- ADDR.DBF DEPT.DBF EMP.CSV EMP.DBF EMP.DBT EMP.TXT EMP.XLS EMPDEPT.NDX EMPHIRE.NDX EMPLNAME.NDX LOC.DBF QE.XLA 0392