|
Excel 2002 How-to articles
- Microsoft Map
removed from the computer when you upgrade to Excel 2002 or to Excel
2003
- How to save
files in other formats in Excel 2002
- List of issues
in Excel 2002 that are fixed by Office XP Service Pack 3
- The recalculation
of a worksheet that contains a SUMIF formula takes longer to finish
than expected in Excel 2003 and in Excel 2002
- List of supported
file formats in Excel 2002
- Description
of the limitations for working with arrays in Excel 2000, Excel
2002, and Excel 2003
- Add-ins that
are not included with Excel 2002 and Excel 2003
- Excel 2002
Stops Responding After You Save File in Excel 97-2002 & 5.0/95 Workbook
Format
- Types of formatting
and features preserved in Excel 2002 workbook sent as body of HTML
e-mail message
- Description
of the AutoRecover functions in Excel 2002 and in Excel 2003
- The Excel 97
custom toolbars are not imported when you upgrade from Excel 97
to Excel 2002
- How to make
Paste options disappear after you paste in Excel 2002 or in Excel
2003
- Error Message
After You Start Excel: Microsoft Excel 2002 Has Not Been Started
or Is Not Installed
- Importing data
may take longer than expected or Excel may appear to stop responding
(hang) when you import data into a workbook in Excel 2002 or in
Office Excel 2003
- The RTD function
generates an Excel 4.0 macro warning when you open an Excel 2002
workbook in Excel 97
- Excel objects
appear truncated when you paste them in PowerPoint 2002
- How to reset
the last cell in Excel
- You cannot
change, add, or delete data in tables that are linked to an Excel
workbook in Office Access 2003 or in Access 2002
- Error message
when you try to open or to save a 2007 Office document: "Do you
want to download a compatibility pack so that you can work with
this file"
- "Excel could
not start the e-mail program" error message when you use the Send
To command in Excel 2002
- How formula
calculations are performed in Excel 2002 or Excel 2003
- Description
of digital signatures in Excel 2002 workbooks
- Description
of options that help you protect your worksheets in Excel 2003 and
Excel 2002
- "Compile error
in hidden module: RegistrationDB" error message when you start or
quit Excel 2002
- Frequently
asked questions about using links in Excel 2003 and in Excel 2002
- How to transfer
XML data to Microsoft Excel 2002 by using Visual C#
- How to recover
data from damaged workbooks in Excel 2002 and in Excel 2003
- How to create
a conditional format to hide errors in Excel
- Transfer XML
Data to Microsoft Excel 2002 by Using Visual Basic .NET
- How to control
the startup message about updating linked workbooks in Excel 2003
and in Excel 2002
- How to use
the "Find and Replace" dialog box in Excel 2002 or in Excel 2003
- Use the Excel
Formula Evaluator in Excel 2002
- How to use
Visual Basic for Applications (VBA) to change UserForms in Excel
2003, Excel 2002, and Excel 2000
- Articles About
New Security Features in Excel 2002
- Frequently
asked questions about Web queries in Excel 2002 and Excel 2003
- Insert a Picture
into the Header or Footer in Microsoft Excel 2002
- How to change
the color palette for workbooks in Excel 2002 or Excel 2003
- You receive
an error message when you save a workbook, define a name, delete
a name, or use a defined name in a formula in Excel 2002 or 2003
- Analysis ToolPak
functions unexpectedly return #NAME error value in Excel 2003 and
in Excel 2002
- How to use
an Excel RTD server with DCOM
- Create a RealTimeData
Server for Excel 2002 or later versions with Visual C++
- The worksheet
may be printed at a different size than you expect when you print
a worksheet in Excel 2002 and Excel 2003
- You receive
a "This file is not in a recognizable format" error message when
you try to open a file in Works 3.0 or 4.0 format in Excel 2000
or Excel 2002
- Description
and examples of data validation in Excel
- How to use
the Error Checking Options button in Excel 2002 or in Excel 2003
- How to use
Excel startup folders in Excel 2002
- How to use
Visual Basic or ASP to create an XML spreadsheet for Excel 2002
and Excel 2003
- How to create
multiple views, create a report, and print a report in Excel 2002
and Excel 2003
- How to send
a range of cells in an e-mail message by using Visual Basic for
Applications in Excel 2002 or Excel 2003
- Articles About
New Formatting Features in Excel 2002
- Registry Keys
That Control the File Repair Feature
- How to check
and manage the status of links in Excel 2002 or Excel 2003
- Calculation
takes longer than expected when a formula depends on a custom array
function in Excel 2003 and in Excel 2002
- How to run
subroutines and macros from Visual Basic in Excel 2000 or Excel
2002
- How to Sort
Sheets in a Workbook
- How to use
MFC to automate Excel 2000 and Excel 2002 and obtain an array from
a range in Excel 2000 and Excel 2002
- Error Message
"Cannot insert object" in Excel
- The link source
for a defined name is not available in Excel 2002 and Excel 2003
- How to use
the Auto Fill Options button in Excel
- How to use
conditional formatting to shade every other row in Excel
- How to create
a form letter by using information from an Excel 2002 worksheet
in Word 2002
- You cannot
double-click to open an Excel attachment in Outlook 2002
- How to use
a logical AND or OR in a SUM+IF statement in Excel
- You receive
a "Too many different cell formats" error message in Excel
- You cannot
send e-mail messages from Word, PowerPoint, and Excel
- How to convert
text to numbers in Excel 2002 and in Excel 2003
- Products that
qualify for the Microsoft Office XP upgrade
- You receive
an "OWC .DLL object could not be loaded" error message when you
open a worksheet in Excel 2002 SP2
- #VALUE error
when you add text and values in Excel
- When you use
the Sort and Top 10 command, the data in a pivot table may not be
sorted correctly in Excel 2003 and in Excel 2002
- How to combine
cells of information in Excel
- Description
of smart tag functionality in Excel 2002 or Excel 2003
- MOD() Function
Returns #NUM! Error Value
- You cannot
start or install Excel and the Excel.exe file on your hard disk
is renamed as Excel.exe.vir
- Some Excel
features are unavailable if you disable Visual Basic for Applications
and run Excel
- Add the Workbook
Path to the Header and Footer in Excel
- Description
of the limits of PivotTable reports in Excel
- "Cannot find
the file" error message when you open Excel files from outside of
Excel
- Frequently
Asked Questions About the Find and Replace Feature in Excel 2002
- In Excel 2003
and in Excel 2002, you are prompted to save the changes when no
changes were made
- You receive
an error message when you add a chart to a workbook in Excel
- How to Use
the "Insert Options" Button in Excel 2002 or in Excel 2003
- Some exported
fields display a number sign (#) delimiter when you export a list
to Excel 2002 from a Windows SharePoint Services Web site
- GETPIVOTDATA
formula is automatically created when you try to create simple link
in Excel 2002 and in Excel 2003
- How to use
A functions in Excel
- How to Recover
a Lost Worksheet or Lost Version of a Worksheet
- How to handle
corrupted Excel workbooks by saving them in the SYLK format in Excel
2003 or in Excel 2002
- Run-Time error
when you use the Range.Calculate method in Excel
- Incorrect password
error when opening an Excel 2002 workbook by using Excel 97 or in
Excel 2000
- Error message:
To prevent possible loss of data, Microsoft Excel cannot shift nonblank
cells off the worksheet
- In Excel, PowerPoint,
and Word, a white background or white area in a graphic may appear
as off-white, but the background or white area of the graphic prints
as light gray
- How to use
dates and times in Excel
- Set Up and
Use the RTD Function in Excel 2002
- How to sum
a range of cells based on a number format in Excel
- How to recognize
the difference among Excel 97 files, Excel 2000 files, and Excel
2002 files by using Visual C++ 6.0
- Excel opens
without displaying a workbook
- You can use
keyboard shortcuts to select border styles in Excel 2002 or 2003
- You Receive
a "Cannot Open Protected File" Error Message When You Open a Tab-Delimited
Text File
- Excel data
does not retain its formatting in mail merge operations in Word
- You receive
a "Run-time error '91'" error message when you use a macro to search
for a fill color in Excel 2002 and in Excel 2003
- Unable to Quit
Excel When the Program Is Running in Reduced Functionality Mode
- Security Settings
and Excel RealTimeData Servers
- Compile error
in hidden module Tbrun97.xls in Excel
- How to change
the case of text in Excel
- How to convert
multiple rows and columns to columns and rows in Excel
- Excel Uses
Microsoft OLE DB Provider for OLAP Services 8.0 for All OLAP Queries
- You receive
a "The list cannot be imported because a Windows SharePoint Services-compatible
spreadsheet application is not installed" error message when you
try to import an Excel 2003 spreadsheet in your Windows SharePoint
Services site
- How to count
the occurrences of a number or text in a range in Excel for Mac
- How to use
system, user, and file data source names (DSN) in Excel 2000 or
Excel 2002
- BUG: Microsoft
Excel Does Not Repaint Properly with Automation
- How to automate
Excel using MFC and worksheet functions
- Manual Page
Break Does Not Move in Excel 5.0/95 File
- How to record
a macro using relative cell references in Excel
- You receive
"Internal Error 2344" and "Installer ended prematurely because of
an error" error messages when you run Office 2000 Setup
- Frequently
Asked Questions About Web Publishing in Excel 2002
- You receive
an error message when you save a file after the network connection
is lost in Excel
- Suppress the
Printing of Errors in Workbook Cells in Excel 2002
- Pie Chart Shows
Incorrect Percentage Value in Excel
- How to help
prevent file corruption in Excel
- Dates and times
displayed as serial numbers when viewing formulas in Excel
- How To Use
ADO with Excel Data from Visual Basic or VBA
- Error When
You Connect to OLAP After You Install SQL Server 2000 Analysis Services
- How To Transfer
Data from an ADO Recordset to Excel with Automation
- When you ungroup
a grouped set of drawing shapes that was copied from Excel, PowerPoint,
or Word, there are two sets of duplicate drawing shapes that overlay
each other
- Articles About
New Printing Features in Excel 2002
- How to Use
the OFFSET Function
- Columns and
rows are labeled numerically in Excel
- You may receive
a "Please wait while Office Configures Office Professional" when
you start Excel 2002 or 2003
- Hyperlinks
in Embedded Excel Workbook Do Not Work
- Excel Stops
Responding When You Copy and Paste an Object Between Workbooks
- Use Small Business
Financial Manager in Excel 2002
- Changes to
the Excel Object Model in Excel 2002
- Some print
settings are unavailable when you select multiple sheets in Excel
2002 or Excel 2003
- How to use
the INDEX and MATCH worksheet functions with multiple criteria in
Excel
- A blank page
appears at the end of a printout in Excel 2002 and Excel 2003
- "The drive
or network connection that the shortcut 'Insert Visio Button.DOT.LNK'
refers to is unavailable" error message when you start Word or Excel
after you upgrade to Visio 2002
- Some data labels
appear inconsistently in your charts when you open an Excel 2002
workbook in Excel 2000
- How to specify
trusted sources for Digital Certificates in Excel 2002, PowerPoint
2002, and Word 2002
- You receive
an error message when you use the Paste Special command in Excel
- When you update
the data in the query table in Microsoft Excel 2002, the update
process takes longer than you expect to finish
- How to set the
starting page number in the header or footer in Excel
- Embedded Excel
Objects Disappear in Corel Draw 10
- How to use
the Conditional Sum Wizard in Microsoft Excel
- How to create
mirrored text in PowerPoint, in Word, and in Excel
- Exported Comma
Separated File Ignores Regional Settings
- How to use
the AutoCorrect Options buttons in Excel
- How to use
shared workbooks with different versions of Excel
- Cannot change
the data type in a Parameter Query in Microsoft Query 2002
- Cannot Save
Excel File That You Open in Microsoft Internet Explorer
- Use the AutoRepublish
Feature in Excel 2002
- Workbook data
does not merge as expected in Excel 2002
- E-mail Button
Does Not Appear on the Standard Toolbar
- You cannot
print a background graphic that is included on an Excel worksheet
- Custom Toolbars
Missing After Upgrade from Earlier Version
- Excel Appears
to Stop Responding and Cannot Print from the Open or Save As Dialog
Boxes
- Decimal point
or trailing zeros unexpectedly appear in number in Excel
- Contents of
the Samples.xls Workbook
- Cells Automatically
Format with Hijri Date Format When You Type "a-" Before a Number
- "Replace All"
command replaces cells in unselected worksheets in Excel 2002 or
in Excel 2003
- Protected Ranges
Not Adjusted When You Edit in Previous Versions of Excel
- The Excel Chart
Prints with Jagged Edges and a Different Font
- Excel RTD Function
Cannot Return an Array
- Save a Workbook
as a Web Page in Excel 2002
- The values
that you save in an XML spreadsheet do not match the values that
appear in Excel 2002 and in Excel 2003
- Turn Off Function
Argument ToolTips in Excel 2002
- Error Message:
Excel Was Previously Unable to Load Your Toolbar Customizations
Starting Excel
- JPN: Excel
Stops Responding When a Calculated Field Is Inserted in a PivotTable
- Text To Speech
Operation Pauses When You Move Text To Speech Toolbar
- The speed of
iterations in a VBA macro that uses the Calculate method decreases
as the macro runs in Excel 2002
- You Cannot
Install Speech Recognition from Excel
- Can't Use PrintOut
Method When Custom Dialog Box Is Visible
- Excel 2002
and Excel 2000 Files Take Longer to Open then Excel for Windows
95 Files
- You may not
be able to see areas for adding data when you create a pivot table
in Excel 2002
- Features and
Formatting Lost Saving to Excel 5.0/95
- Formulas Return
#VALUE! or #NAME! After Upgrade
- Cannot Drag
Page Breaks in Page Break Preview
- You may receive
an error message or the Publisher icon becomes generic or no longer
appears in the Start menu when you start an Office program
- PRB: BizTalk
Editor Error When You Import Excel 2002 XML Worksheet
- Known Issues
With Excel 2002 When Using the Office XP Pack for the Tablet PC
- How to use
earlier versions of Excel, PowerPoint, and Word to open and save
files from 2007 Office programs
- Cannot use
the IMPORTARDATOSDINAMICOS function in the Spanish version of Excel
2002
- "Invalid XML
Declaration" Error Message When You Import Data from a Web Source
- "Print Cell
Errors As" Setting Is Lost When You Open and Save Workbook in Earlier
Version
- A hyperlinked
text box does not function after you save the workbook as a Web
page to a Web server in Excel 2002 and in Excel 200
- Limitations
of the Break Links command in Excel 2003 and in Excel 2002
- Microsoft Excel
2002 and XML
- "Unable to
Read File" Error Message When You Open an Excel Workbook That Contains
Links to Other Excel Workbooks
Office XP, Word, Excel, Outlook, PowerPoint, Access, Publisher,
Visio und FrontPage 2002 How-to articles
Google Pack Download -
Zum kostenlosen Download des Google Packs
Office-Updates,
Windows-Updates,
service
packs,
downloads,
viewers.
- Security Updates for Windows,
Office, and Internet Explorer
- Office 2007 downloads, service packs,
security updates, viewers, add-ins, trial editions, and more.
- Office 2003 downloads, service packs,
security updates, viewers, add-ins, and more.
- Office XP downloads, service packs, security
updates, viewers, add-ins, and more.
- Office 2000 downloads, service packs,
security updates, viewers, add-ins, and more.
- Outlook downloads, service packs,
updates, tipps, add-ins, and more.
- FrontPage downloads, service packs, updates,
viewers, add-ins, and more.
- Office Viewer & Converter -
Word Viewer -
Excel Viewer -
PowerPoint Viewer
- Office 97, 2000, XP, 2003 &
2007 service pack downloads
- Office for Mac downloads, service packs
& updates
- Office 97, 2000, XP, 2003 & 2007 Resource
Kit Tools
- Office 97, 2000, XP, 2003 & 2007 Tipps
und Anleitungen
- Office Vorlagen - Word, Excel,
PowerPoint, Access, Publisher, Visio & OneNote
- Office Vorlagen -
Kalender 2008 (2008 Calendars)
- Google Pack Download - Zum kostenlosen
Download des Google Packs
|
