home *** CD-ROM | disk | FTP | other *** search
Microsoft Windows Help File Content | 1995-11-13 | 20.1 KB | 330 lines |
- :Base excel.hlp>main
- :Title Excel 7.0 Knowledge Base Help File
- 1 Categories and Keywords for All Knowledge Base Articles
- Categories and Keywords for All Knowledge Base Articles =Q94671
- 1 Categories and Keywords for Excel Knowledge Base Articles
- Office, Excel, and Project Article Keywords =Q123516
- 1 Excel Knowledge Base Articles
- Excel: LOOKUP, HLOOKUP, VLOOKUP Return Incorrect Values =Q24659
- Excel: Moving Between Unlocked Cells in Protected Worksheet =Q25492
- Calculate Precision As Displayed Versus Format Number =Q25653
- Printing without Headers or Footers Using PAGE.SETUP in Excel =Q25764
- Excel: How to Keep Certain Values from Being Displayed =Q25903
- Excel: Can't Change Left/Right Margins for Headers and Footers =Q26626
- Auto_Open Macro Not Working Correctly on Excel Worksheet =Q28189
- Avoiding Circular-Reference Errors When Keeping Running Totals =Q28872
- Options Protect Document and Password Features in Excel =Q29027
- Excel Err Msg: "File Format Is Not Valid" with Linked Document =Q30583
- Calculating the Future Value of a Single Cash Flow in Excel =Q30970
- Excel: "Database Range Not Defined"/Data Missing Saving to dBASE =Q31817
- Curve Fitting with Excel Using the TREND Function =Q34315
- Curve Fitting with Excel Using the Newton Method =Q34318
- Excel: Keeping a Cumulative Total in a Column or Row =Q36950
- Two-Step Method to Calculate Bond Price in Excel =Q37993
- Excel: Errors Sorting Cells That Contain References =Q40401
- Converting a Number with Minus Sign on Right to Minus on Left =Q42964
- Excel: General Number Format Rounds Off Real Numbers =Q45646
- XL5: Data Lost When File Saved in .DBF File Format =Q46228
- Auto_Close, Auto_Open Macros Not Executed in Excel =Q46350
- Exporting HPGL Format from Microsoft Excel =Q47142
- Excel: Importing and Exporting R:BASE Databases =Q47664
- Data Sort Not Sorting Correctly in Excel =Q48254
- Math Coprocessor May Use Different Level of Precision =Q57298
- Excel: Using INDEX and MATCH Against Multiple Criteria =Q59482
- Use of the IRR Function in Excel =Q59616
- Excel and Lotus DIF File Differences =Q60997
- Excel: How to Copy Column Widths =Q61269
- Formula to Find Number of Weekdays Between Dates =Q61575
- Manually Recalculating a Single Cell or Range =Q61622
- Halting Macro for User Input in Excel =Q62290
- Sorting on Portions of the Contents of a Cell =Q62719
- Excel: Locating Circular References =Q65362
- How to Calculate the Number of Months Between Two Given Dates =Q67093
- Excel Macro to Print All Open Documents =Q67571
- Setting and Removing a Noncontiguous Print_Area =Q68200
- Contents of Cells Show Through Objects with HP Printers =Q68269
- XLM: Opening and Closing Word for Windows Using an Excel Macro =Q68510
- Printing Nonadjacent Areas on One Sheet =Q68511
- XLM: How to Create International Macros in Excel =Q69527
- Using SEND.KEYS() to Change Paper Source in Printer Setup =Q69614
- Using FORMULA.CONVERT() to Change Relative/Absolute References =Q70096
- Paste Linking an Excel Embedded Chart into Word for Windows =Q70471
- Excel: Graphic Objects Affect Printout of Shaded Cells =Q71268
- Consolidation Does Not Consolidate Text in Excel =Q71303
- Activating An Embedded Chart Using A Macro =Q71539
- Copying a Multiple Selection in Excel =Q71696
- Excel: "Can't Access Document" Error Opening or Saving File =Q71730
- Using IPMT to Calculate Interest Paid for Multiple Periods =Q71952
- Solver Error Messages =Q72415
- Parsing Names in a Worksheet Without Data Parse in Excel =Q72573
- Converting Hours in Decimal Form to HH:MM:SS Format in Excel =Q72578
- Excel: Optimizing Worksheets for Fastest Calculation =Q72622
- Converting a Decimal Degree Value to Degrees, Minutes, Seconds =Q73023
- Days360 Calculates as Designed in Excel =Q73210
- Excel: Creating Gantt Charts =Q73281
- Using INDEX() to Automatically Update Range in SUM() Formula =Q73586
- Excel: Dates Assume Twentieth Century in Microsoft Excel =Q73673
- Excel: Changing the Default Directory =Q74342
- Excel: Methods to Automatically Add Zeros After a Number =Q74523
- Maximum Array Size in Microsoft Excel =Q75376
- Recovering Data from a Damaged Excel File =Q75818
- Converting Text to Numbers in Excel =Q75945
- Consolidate Function Doesn't Create Links to Blank Cells =Q76181
- PMT Argument Not Required with FV, NPER, PV, and RATE Function =Q76358
- XL: Creating a Two-Dimensional Lookup Table in Microsoft Excel =Q76428
- Macro to Add Data Point Labels to a Chart in Excel =Q77086
- Performing a Lookup with Unsorted Data in Excel =Q77114
- Starting Excel with No Worksheets Open =Q77538
- Using a Logical AND or OR in a SUM+IF Statement in Excel =Q77676
- Using the [Init Commands] Section of the EXCEL.INI File =Q77981
- Excel: Floating-Point Arithmetic May Give Inaccurate Results =Q78113
- Excel: Ignoring Zero Values in the AVERAGE Function =Q78195
- Excel: Can't Evaluate Link to Closed Document in Formula Bar =Q81025
- Excel: File Translation Between Macintosh and Windows Versions =Q81274
- XL Err Msg: 'Error in Formula' If Filename Starts with Number =Q81318
- Excel: Functions Recalculated If New Data or Cells Entered =Q81856
- Excel: Solver Uses Generalized Reduced Gradient Algorithm =Q82890
- Excel or Project: GP Fault in WIN87EM.DLL =Q84701
- Excel: Random Number Generation =Q86523
- Excel: Calculating Work Hours for a Given Time Period =Q87855
- Excel: Can't Use Spelling Tool If Custom Dictionary Corrupted =Q88587
- Excel: YEARFRAC Does Not Count Extra Day in Leap Years =Q89031
- Excel: INTRATE() Function Uses Simple Interest =Q89942
- Excel: Solver Error Value in a Target or Constraint =Q90185
- Third-Party Vendors of Microsoft Excel-Related Products =Q90508
- Excel: Algorithm Used by the XIRR() Function =Q90728
- Excel: Displaying Automatic Page Breaks =Q92364
- Excel: Columns Half Width or Invisible in Column Chart Overlay =Q93862
- Excel: How to Run a Word for Windows Macro from Excel =Q94364
- Excel: Regression Tool Error If More Than 16 X Ranges =Q94631
- Excel: Changing the Date or Time Format in a Header or Footer =Q94870
- Excel: How to Work With Serial Dates and Julian Dates =Q95078
- Excel: Can't Print Color Headers and Footers =Q95478
- How to Add or Subtract from a Given Time with TIME() and MOD() =Q95530
- Excel: File Saved in WK3 Displays Numbers Incorrectly in 1-2-3 =Q96379
- Excel Err Msg: Cannot Open Consolidation Source File =Q97617
- Excel: Troubleshooting Font Problems =Q97911
- Excel: Patterned Cells May Not Print to HP LaserJet 4 =Q98399
- Excel: Working with Time Periods That Exceed 24 Hours =Q99349
- Excel: LINEST() Function Returning Only One Value =Q99639
- Excel: Resetting Last Cell Address Fixes Memory/Printing Probs =Q100406
- Excel Err Msg: Can't Do that Command on Nonadjacent Selections =Q100715
- Excel: Links Return #REF Error Value =Q100717
- MSQuery: ODBC Information Not Displayed in Error Messages =Q101449
- Excel: Macros to Disable Keyboard Input =Q101567
- Excel: Finding Open Applications that are DDE Capable =Q102362
- Excel: Defined Names Are Not Deleted Dynamically =Q102944
- Excel: XLM Macro to Delete Blank Rows Within a Range =Q103022
- Excel: How to Use AutoSum in a Macro =Q103164
- XL: Chart Windows Appear Different in Version 5.0 =Q104299
- XL: How Pivot Tables Differ from Version 4.0 Crosstab Tables =Q104309
- XL: Non-Excel 5.0 Documents Take a Long Time to Open and Save =Q104310
- Excel: DDE Links to Microsoft Access Not Updated Automatically =Q104440
- Excel: Fields Truncated When File Is Saved in .DBF Format =Q104441
- XL: Macro Error Using Menu Customizing Function Commands =Q104493
- XL: Square Bracket Notation Is Less Efficient Than Tunneling =Q104502
- Excel: How the Current Mode of Calculation Is Determined =Q104695
- XL: Double-Clicking Control Activates Default Button =Q104936
- XL: Macros to Sort Tabs in the Active Workbook =Q105069
- XL: Can't Link Edit Box to Worksheet Cell from Control Tab =Q105110
- XL: "Not Enough Memory" or Computer Hangs with AutoFilter =Q105322
- XL: Passed Strings Greater Than 255 Characters Are Truncated =Q105416
- XL: Not All Toolbars Listed on Popup Menu =Q105451
- XL: Defined Names for Print Area or Titles May Not Be Dynamic =Q105817
- XL: Can't Use PrintOut When Custom Dialog Box Is Visible =Q105876
- XL: Error Using Data Form If Too Many Fields Are Present =Q106206
- XL5: PivotTable Wizard Does Not Automatically Refresh Data =Q106243
- XL: Multiple Sheets Inserted with Autotemplate =Q107545
- XL: Not All Worksheet Functions Supported As Application =Q107564
- XL: How To Add a Sheet After Last Sheet in a Single Action =Q107622
- XL: Disabling Microsoft Excel Control Menu Commands =Q107689
- XL: Only First 100 Names Listed in the Name Box =Q107704
- XL: Scatter Chart Line Disappears After Changing Series Axis =Q107753
- XL: Using Worksheet Functions in Visual Basic Procedures =Q107879
- XL: Macro to Print a Group of Files Located in Same Directory =Q107880
- XL: ChDir May Fail When Changing to a Root Directory =Q108351
- XL5: Can't Run Macros That Use File Functions Add-in Functions =Q108356
- XL: Errors if XL5GALRY.XLS Saved wth Password =Q108358
- XL: Inconsistent Results Moving Chart Data Labels =Q108369
- XL5: Window Options Not Saved in Workspace File =Q108474
- XL: Cannot Open Workbook When Dependent Worksheet Is Open =Q108475
- XL: Error When Macro Closes Its Own Workbook =Q108507
- XL: Range.EntireRow May Return Incorrect Result =Q108518
- XL: Running Subroutines and Macros from Visual Basic =Q108519
- XL: Range_Lookup Argument in VLOOKUP() Finds Exact Match =Q108639
- XL: Basis Argument for Financial Functions =Q108725
- XL: Cells.Find Returns Error When No Match Found =Q108892
- XL: Macro to Open the Most Recently Used File =Q109113
- XL5 AppNote: Upgrade and Setup Questions and Answers (WE0922) =Q109190
- Excel: Calculating Weighted Averages =Q109211
- XL: Cannot Open Microsoft Works 3.0 or 4.0 Files =Q109246
- XL: Dates in Pivot Table May Be Converted into Text =Q109420
- XL5: Formatting Dialog Frame When Sheet Protected Hangs Excel =Q109422
- XL: Not Possible to Position Custom Dialog Boxes =Q109423
- XL: How to Use the Help Button in Custom Dialog Boxes =Q109424
- XL: Update Remote References Option Selected by Default =Q110006
- XL Err Msg: "Setup Needs To Modify A File" During Setup =Q110074
- XL: ShowDataForm Method Fails If Data Can't Be Found =Q110462
- XL: Chart Trendline Equation or Data Label Disappears =Q110499
- XL: Pivot Table Uses COUNT Instead of SUM with Blank Cells =Q110599
- XL: Pivot Table Refresh Overwrites Formatting =Q110602
- XL: Setting Initial Values When Running Built-In Dialog Box =Q110670
- XL: Returning Multiple Values from a Custom Function =Q110693
- XL: Visual Basic Example to Delete Blank Rows =Q110759
- Computing Periodic Annual Interest Rate in Microsoft Excel =Q110854
- XL5: Startup Directory Is XLSTART Not PERSONAL.XLS =Q110855
- XL5: Defining Name in Name Box Causes Type Mismatch Error =Q110857
- XL Err Msg: Not Enough Memory To Display Pivot Table =Q110890
- XL5: Error Messages When Accessing Files from Floppy Disks =Q110944
- XL OLE Automation: Workbook Hidden Using GetObject Function =Q111247
- XL: Status Bar Text for Toolbar Button Changes Unexpectedly =Q111269
- XL5 Docerr: Shell Function Pathname and Windowstyle Parts =Q111282
- XL: CreateObject Function Starts Invisible Instance of Excel =Q111311
- XL: Some Special Characters Are Changed in Imported Files =Q111397
- XL: XL5GALRY.XLS Opened As Hidden Workbook =Q111491
- XL5: System Hangs with Circular Workbook Links =Q111492
- XL: Determining Which Items Are Selected in a List Box =Q111564
- XL5 Err Msg: "Not Enough Stack Space to Run Macro" =Q111867
- XL5: List in Dialog Box Does Not Reflect Changes Made by Macro =Q111900
- XL: Print Reports Not Using Continuous Page Numbers =Q112101
- XL: Printing Cell Notes As Separate Printout =Q112221
- XL: 'For Each Item in List' Doesn't Work =Q112330
- Excel: Negative Date/Time Value Displayed as Pound Signs (#) =Q112361
- XL: Fonts Too Big After Print or Print Preview =Q112456
- XL5: Message Always Sent from cc:Mail as "Low Priority" =Q112507
- XL: Pie Chart Shows Incorrect Percentage Value =Q112773
- XL: OLE Automation, Can't Use Named Arguments in Visual Basic =Q112813
- XL5: Can't Print Collated Copies =Q112821
- Unexpected Results with Mixed Text and Numbers in Lookup Table =Q113261
- Excel: GP Fault in ANALYSIS.XLL Using Regression Tool =Q113468
- XL: Visual Basic Code to Use Instead of DIRECTORIES() =Q113491
- XL: Visual Basic Nested Case Statement Example =Q113659
- XL: Protect Method Fails When Module Is Hidden =Q113786
- XL: Visual Basic Example to Total Rows and Columns in an Array =Q113940
- XL: Toolbar Button Colors Appear Incorrectly =Q114172
- XL: Commands You Can Use To Customize Setup /A =Q114314
- XL: Error Message: FUNCRES.XLA Is Not a Valid Add-in =Q114388
- XL: Command to Create Add-in File from Visual Basic Module =Q114436
- XL: Copy of Recorded Macro Code Doesn't Work Correctly =Q114437
- XL: Error Editing/Saving File When Can't Access File on Disk =Q114440
- XL: Incorrect Polynomial Trendline on XY (Scatter) Chart =Q114629
- XL: Error Opening 4.0 Workbook with Unbound File on Network =Q114952
- Incorrect Margin Using Fit To Scaling Option with PostScript =Q114956
- XL: Text to Columns May Yield Incorrect Results =Q115074
- XL: Error Calling Macro Contained in Open Add-In =Q115208
- XL: Control Method of Sheet Class Failed with Grouped Control =Q115312
- XL: Visual Basic Macro to Convert Lotus Files to Excel =Q115343
- XL: Pivot Table Cannot Group Data =Q115471
- XL: Row and Column Range Converted to Two-Dimensional Array =Q115513
- XL5: AutoFormat Page Setup Options Not Applied to Chart =Q115514
- XL: Non-Loop Array Transfer to a Worksheet =Q115776
- Excel: Explanation of Recursive Calculation and Evaluation =Q115941
- XL: VB Macro to Change Between Relative/Absolute References =Q116028
- XL5: Pressing F1 on Custom Dialog May Not Activate Help Button =Q116059
- XL: Visual Basic Example of Spinner Use on a Date =Q116118
- XLM: Importing Text Files Larger Than 16384 Rows =Q116232
- XL: Visual Basic Procedures for Julian Date Calculations =Q116281
- Excel: Converting Multiple Rows/Columns to Columns/Rows =Q116289
- XL: Can't Trap No or Cancel in "Replace Existing" Dialog Box =Q116327
- No Macro Function to Access Solver Dialog Box =Q116340
- XL: Hidden Cells in a Worksheet May Become Unhidden =Q117128
- XL: "<Macro> On <Workbook> Is Not Defined" Updating Links =Q117231
- XL: SQL.REQUEST and SQLREQUEST Function Syntax Differences =Q117364
- XL: Maximum Page Number Allowed Is 32767 =Q117410
- XL: Dialog Constants That Do Not Have an Interactive Dialog =Q117412
- XL5: Print Titles Do Not Appear on Every Page of Output =Q117799
- XL: Opening Text File Overrides Manual Calculation =Q117839
- XL5: GP Fault Inserting or Formatting Picture on a Chart =Q117848
- XL: Removing the Control Menu and Application Window Controls =Q117855
- XL: Data Number Formatting Lost Creating Pivot Table =Q118371
- XL: Supported Graphic File Formats for Import =Q118374
- XL5 Err Msg: "OLE Automation Error" or "Out of Memory" =Q118379
- XL: Macro to Add Labels to Points in an XY (Scatter) Chart =Q118485
- XL: Macro to Check for Page Breaks on Worksheet =Q118589
- XL: Problems with Function Wizard and IS Functions =Q118849
- XL: Submenu Item Appears Enabled with Worksheet Maximized =Q118955
- XL: Macro Translation Assistant Not Installed =Q118956
- GP Fault Using DDEExecute with Multiple Commands =Q118974
- XL: Columns Hidden in File Saved to WK1 Format in SuperCalc =Q118998
- Excel: MOD() Function Returns #NUM! Error Value =Q119083
- XL: Cell Borders Not Sorted with Data =Q119130
- XL: Custom AutoFilter Won't Filter Numbers Formatted as Text =Q119257
- Excel: YIELD Function Incorrectly Returns #NUM! Error Value =Q119316
- XL: Can't Synchronize Windows By Choosing Arrange All =Q119718
- XL: Text Import Wizard Maximum Row Limitation of 32767 =Q119770
- XL: Macro to Remove Hidden Names in Active Workbook =Q119826
- AppNote: "Jet Error Help File (Msjeterr.hlp)" (WE1238) =Q119849
- Calling a Microsoft Excel Macro from a Lotus 1-2-3 Macro =Q119882
- XL: How to Copy Files from Cabinets on DMF-Formatted Disks =Q120006
- XL: How to Select Cells/Ranges Using Visual Basic Procedures =Q120198
- XL: Importing Text Files Larger Than 16384 Rows =Q120596
- XL5: GP Fault Copying, Moving, or Scrolling Visual Basic Module =Q120721
- XL: Overview of ODBC Add-in Functions and Arguments =Q120870
- XL: Canceling OnTime Macro When Time Argument Is Volatile =Q121212
- XL: Protected File Opens Without Prompt for Password =Q121214
- XL: Can't Use Visual Basic Procedure to Reference Project =Q121269
- XL: Setting Print Area and Print Titles on Worksheet =Q121401
- XL5: Sample Visual Basic Procedure to Print Range of Cells =Q121818
- EXCEL: How to Create a Column Chart with Two Y Axes =Q121819
- XL: Custom Function to Express Degree as Fractions of Degrees =Q121944
- XL5 Err Msg: GP Fault in Module SDM.DLL =Q122059
- XL: GP Fault When Info Window Viewed in Print Preview =Q122137
- XL: COMPARE.XLA Does Not Work in Microsoft Excel 5.0 =Q122330
- Procedure to Export Text File with Comma AND Quote Delimiter =Q123183
- Excel: Dialog Sheet Control Disabled If an Object Is Behind It =Q123187
- XL: Header/Footer Margin Settings Not Saved in View Manager =Q123192
- How to Compute the Average Growth Rate of an Investment =Q123198
- XL: Visual Basic Module to Create Gantt Chart =Q123260
- XL: WordBasic Command FileExit Generates An Error =Q123327
- Excel: OnEntry Macro to Create a Running Total =Q123578
- XL: Detailed Solutions for Interest Rate Formulas =Q123757
- XL5: Error Returning Formula with Long Sheet and Filename =Q123762
- XL: 5.0c Allows You To Choose Recording Method Before Recording =Q124092
- XL: OLE Automation Example: Controlling MS Excel from VB =Q124094
- XL: Inserting a Vertical Line in Microsoft Excel Chart =Q124112
- XL5 Err Msg: "File Format No Longer Supported" Creating Add-in =Q124180
- XL5 Err Msg: Columns (or Rows) Method of Range Class Failed =Q124220
- XL: Using AutoSum in a Visual Basic Macro =Q124222
- Public and Module-Level Variables Lost with SaveAs Method =Q124224
- Error '1004' When Using the SQLRequest Macro Function =Q124226
- XL5 Err Msg: "Can't Find Project or Library" Running Macro =Q124277
- XL5: TRANS.EXE Not Installed with Custom or Complete Install =Q124383
- XL5: Cannot Change or Delete Constraints in Solver =Q124499
- XL: Can't Use Find/Replace on Text with Leading Apostrophe =Q124739
- XL: Left/Right-Aligned Header/Footer Text Ignores Margins =Q124751
- XL: Print/Preview Worksheet with OLE Object Causes GP Fault =Q124807
- XL: VB Procedure to Emulate Find Command =Q124924
- XL: Macro Recorder Can't Record Page Setup in Group Mode =Q124934
- XL: Creating Non-Default Text Labels on an XY (Scatter) Chart =Q125178
- Finding Graphic Objects Within a Range with TopLeftCell =Q125179
- XL: Can't Use ActivateMicrosoftApp Method to Activate Excel =Q125181
- XL: Macro to Select Every nth Row/Column =Q125267
- XL: Setting Default Save As to Microsoft Excel 4.0 File Format =Q125270
- Sample Macro to Open a Text File Without Displaying TextWizard =Q125401
- XL5: Creating a Masked Password Dialog Box in Visual Basic =Q125422
- XL: How to Delete and Restore a Menu That Has a Submenu =Q125423
- XL: Disabling OLE Services in Windows NT Hangs MS Excel =Q125588
- XL: Can't Set Print Area or Print Titles =Q125640
- XL: Visual Basic Macro to List Circular References =Q125848
- XL: Sending Mail from MS Excel Using VBAMAPI.DLL (Part 1) =Q125854
- XL: Macros to Delete Formula Links =Q126093
- XL: Consolidated Labels Use Name of Workbook Instead of Sheet =Q126100
- XL: Using the Range Method to Convert String to a Range =Q126367
- XL: Menu Command Runs Macro from Wrong Add-In =Q126663
- XL: "Invalid External Reference" Using ChartWizard Method =Q126817
- XL: Sorting Alpha-Numeric Text as Numeric Values =Q126931
- "Cannot Access <FILENAME.XLA>" Opening Add-Ins Dialog Box =Q126998
- XL: Find Feature does Not Work on Filtered List =Q127060
- XL: Macro to Print Notes as Separate Printout =Q127206
- XL: Macrofun.exe File Is Available for Download on CompuServe =Q128185
- XL7 Patch Available: 15-Digit Number, Linking, and Transpose =Q128650
- XL: Range Command in Macro Selects Cells from Entire Range =Q133139
- XL7: AutoCalculate Not Available on Macro Sheet =Q133415
- XL: DefType Statements Change If Workbook Used on New Platform =Q134412
- FastTips: "Printing Questions and Answers" (WE1209) =Q135833
- FastTips: "Upgrading Questions and Answers" (WE1207) =Q135834
- FastTips: "Basic Use Questions and Answers" (WE1208) =Q135836
- FastTips: "Shared Documents Questions and Answers" (WE1210) =Q135837
- 1 Created 11/17/95, Other Sources of Information
- More Information On Knowledge Base (KB) Helpfiles =Q199990
-