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.
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
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.
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
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
