difference between Excel 2000 and Excel XP, and Excel 2002

I would like to know what the differences are between Excel 2000 and Excel XP, and Excel 2002
0
anonymous (74731)
2/19/2004 2:06:05 PM
excel.newusers 15348 articles. 0 followers. Follow

2 Replies
278 Views

Similar Articles

[PageSpeed] 34

Go to John Walkenbach's site www.j-wal.com
Lots of info there.
-- 
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

"Eleanor" <anonymous@discussions.microsoft.com> wrote in message
news:CD9A6D01-EA2F-4031-B6C6-99E2E2DD0EE3@microsoft.com...
> I would like to know what the differences are between Excel 2000 and Excel
XP, and Excel 2002


0
bliengme5824 (3040)
2/19/2004 2:18:42 PM
This is a multi-part message in MIME format.

------=_NextPart_000_0062_01C3F6CA.F29BA860
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_0063_01C3F6CA.F29BA860"


------=_NextPart_001_0063_01C3F6CA.F29BA860
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

Excel 2003:

http://office.microsoft.com/assistance/preview.aspx?AssetID=3DHA010714961=
033&CTT=3D1&Origin=3DEC010229841033&QueryID=3D0Bx4IZ9tE

From the Excel 2002 help file:
Key new features in Microsoft Excel 2002
Importing data

Querying data from Web pages   Now it's even easier to get refreshable =
data from the Web into Excel for viewing and analysis. Use the new =
browser-like interface to visually select tables on Web pages for import =
into Excel, or copy data from a Web page and create a refreshable query. =
Web queries included with Excel provide fast, accurate information such =
as stock quotes for your spreadsheets. You can also create Web queries =
to Extensible Markup Language (XML) files.

Importing data   Getting data where you need it and when you need it is =
as easy as choosing an option and finding your data source in the Select =
Data Source dialog box. If you want to import data from a remote data =
source, use the Data Connection Wizard to locate and import data from =
sources as varied as Microsoft SQL Server, Open Database Connectivity =
(ODBC), and Online Analytical Processing (OLAP) data sources. Microsoft =
Office data connection (.odc) files are shareable.

Formulas and functions

ScreenTips for function arguments   Type a function in a cell and a =
convenient screen tip appears showing all of the arguments for the =
function, along with a link to the Help topic for the function.

Recommended functions in the Function Wizard   Type a natural language =
query, such as "How do I determine the monthly payment for a car loan", =
and the Function Wizard returns a list of recommended functions you can =
use to accomplish your task.

Cut-and-paste function reference examples   If you've wondered how to =
translate Help examples into meaningful worksheet data, you'll find the =
cut-and-paste function examples in Excel Help useful and time saving.

Task-based formula help   Real-life examples for real-life numeric =
problems make powerful additions to the Help you've come to count on.

Watch window   Keep track of cells and their formulas on the Watch =
Window toolbar, even when the cells are out of view. This moveable =
toolbar tracks cell properties including workbook, worksheet, name, =
cell, value, and formula.

Expanded AutoSum functionality   The practical functionality of AutoSum  =
has expanded to include a drop-down list of the most common functions. =
For example, you can click Average from the list to calculate the =
average of a selected range, or connect to the Function Wizard for more =
options.

Formula evaluator   You can see the various parts of a nested formula =
evaluated in the order the formula is calculated by using a simple =
dialog box on the Formula Auditing toolbar.

Trace precedent and dependent cells with Formula Auditing   Use the =
Formula Auditing toolbar to graphically display, or trace, the =
relationships between cells and formulas with blue arrows. You can trace =
the precedent cells or the dependent cells.

Formula error checking   Like a grammar checker, Excel uses certain =
rules to check for problems in formulas. These rules can help find =
common mistakes. You can turn these rules on or off individually.

Worksheet and workbook formatting

Color-coded worksheet tabs   Organize your work by adding color to your =
worksheet tabs.

Control  automatic changes with smart tags   Buttons that appear =
automatically on your worksheet can help you with tasks such as =
automatic correction options, paste options, automatic fill options, =
insert options, and formula error checking. With a click of a button you =
can choose from options related to your task without leaving the =
worksheet or the cells you're working on.

Unmerge on the toolbar   No more searching for a way to unmerge cells. =
Now unmerge is conveniently located on the Format toolbar.

Retain column widths   If you have worksheets with specified column =
widths, now you can paste information from another worksheet without =
losing that formatting by clicking the Paste Options  button, and then =
clicking Keep Source Column Widths.

Border drawing   A new border drawing tool allows you to outline complex =
borders with little effort.

More new features in Excel
Everyday tasks

Find and replace   Finding and replacing data in Excel includes great =
new options to match formats and search an entire workbook or =
worksheets.

Links management   Changes to the Edit Links dialog box allow you to =
check the status of the links in your worksheet and make changes. A new =
workbook option allows you to control whether to update links in your =
workbook automatically.

Hyperlink navigation   Selecting a cell with a hyperlink is improved. =
Click the hyperlink once to follow it. Click and hold to select the =
cell.

Sending a range   Sending out mid-month reports and summaries just got =
easier. Select a range on your worksheet, click E-mail  on the Standard =
toolbar, type an introduction to the report, and then send it without =
spending extra time on the task.

Insert and delete columns while filtering   You can insert and delete =
columns with AutoFilter turned on in Excel. You can even undo the action =
and preserve any applied filtering.

Speech playback   An option to have a computer voice play back data =
after every cell entry or after a range of cells has been entered makes =
verifying data entry convenient and practical. You can even choose the =
voice the computer uses to read back your data. This feature is =
available in Chinese, Japanese, and English (U.S.) only.

Printing   You've asked for the ability to insert graphics and file =
names in headers and footers, and with Excel you can. You'll also find a =
handy A4 paper resizing option on the International tab under Tools =
menu, Options command, which will scale the worksheet you formatted for =
A4 paper if you have  letter-size paper in your printer.

Smart tags   By turning on smart tags, you can type a U.S. financial =
symbol and use Smart Tag Actions  to insert a stock quote in your =
worksheet, find out more about the company you're doing business with, =
and more. You can also type the name of someone you've recently sent an =
e-mail message to into a cell, and then use smart tag options to =
schedule a meeting or add the name to your contacts list, all without =
leaving your worksheet.

Item properties in PivotTables   Online Analytical Processing (OLAP) is =
a powerful tool for aggregating numeric information, and now you can =
annotate your data with item properties to make your data warehouse even =
more valuable.

AutoRepublish   Anyone who frequently publishes Excel data to the Web =
will appreciate additional Web publishing features that allow you to =
automatically republish items to Web pages whenever you save a workbook =
with previously published items.=20

Open and save XML   With Excel, you can open and save Extensible Markup =
Language (XML) files, save entire workbooks in the XML Spreadsheet =
format, and create queries to XML source data.=20

Digital Dashboard and Web Parts   Use Excel to create Web Parts to =
include on your company's new Digital Dashboard. For example, you might =
create an updateable sales chart to highlight your division's =
contributions to the company's bottom line.=20

Worksheet protection   Excel adds power and flexibility to protect your =
data from changes to worksheets and cells. You can protect cell values =
and formulas, and allow the cell to be formatted. You can also ensure =
that only specific users are allowed to change cells.


--=20
Jim Rech
Excel MVP
------=_NextPart_001_0063_01C3F6CA.F29BA860
Content-Type: text/html;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=3D2>Excel 2003:</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><A=20
href=3D"http://office.microsoft.com/assistance/preview.aspx?AssetID=3DHA0=
10714961033&amp;CTT=3D1&amp;Origin=3DEC010229841033&amp;QueryID=3D0Bx4IZ9=
tE"><FONT=20
size=3D2>http://office.microsoft.com/assistance/preview.aspx?AssetID=3DHA=
010714961033&amp;CTT=3D1&amp;Origin=3DEC010229841033&amp;QueryID=3D0Bx4IZ=
9tE</FONT></A></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>From the Excel 2002 help file:</FONT></DIV>
<DIV>
<H1><FONT size=3D2>Key new features in Microsoft Excel 2002</FONT></H1>
<P><A class=3DDropDown onclick=3DOutline2()=20
href=3D"mk:@MSITStore:C:\mso\mso02\Office10\1033\xlmain10.chm::/html/xlwh=
atsnewhome.htm#"><FONT=20
size=3D2><IMG height=3D10 =
src=3D"cid:005901c3f6f4$db5c2c90$5450120a@rech" width=3D14=20
border=3D0>Importing data</FONT></A></P>
<DIV class=3Dexpanded id=3DExpCol border=3D"0">
<P><FONT size=3D2>Querying data from Web pages&nbsp;&nbsp; Now it's even =
easier to=20
get refreshable data from the Web into Excel for viewing and analysis. =
Use the=20
new browser-like interface to visually select tables on Web pages for =
import=20
into Excel, or copy data from a Web page and create a refreshable query. =
Web=20
queries included with Excel provide fast, accurate information such as =
stock=20
quotes for your spreadsheets. You can also create Web queries to =
Extensible=20
Markup Language (XML) files.</FONT></P>
<P><FONT size=3D2>Importing data&nbsp;&nbsp; Getting data where you need =
it and=20
when you need it is as easy as choosing an option and finding your data =
source=20
in the Select Data Source dialog box. If you want to import data from a =
remote=20
data source, use the Data Connection Wizard to locate and import data =
from=20
sources as varied as Microsoft SQL Server, Open Database Connectivity =
(ODBC),=20
and Online Analytical Processing (OLAP) data sources. Microsoft Office =
data=20
connection (.odc) files are shareable.</FONT></P></DIV>
<P><A class=3DDropDown onclick=3DOutline2()=20
href=3D"mk:@MSITStore:C:\mso\mso02\Office10\1033\xlmain10.chm::/html/xlwh=
atsnewhome.htm#"><FONT=20
size=3D2><IMG height=3D10 src=3D"cid:005901c3f6f4$db5c2c90$5450120a@rec" =
width=3D14=20
border=3D0>Formulas and functions</FONT></A></P>
<DIV class=3Dexpanded id=3DExpCol border=3D"0">
<P><FONT size=3D2>ScreenTips for function arguments&nbsp;&nbsp; Type a =
function in=20
a cell and a convenient screen tip appears showing all of the arguments =
for the=20
function, along with a link to the Help topic for the =
function.</FONT></P>
<P><FONT size=3D2>Recommended functions in the Function =
Wizard&nbsp;&nbsp; Type a=20
natural language query, such as "How do I determine the monthly payment =
for a=20
car loan", and the Function Wizard returns a list of recommended =
functions you=20
can use to accomplish your task.</FONT></P>
<P><FONT size=3D2>Cut-and-paste function reference examples&nbsp;&nbsp; =
If you've=20
wondered how to translate Help examples into meaningful worksheet data, =
you'll=20
find the cut-and-paste function examples in Excel Help useful and time=20
saving.</FONT></P>
<P><FONT size=3D2>Task-based formula help&nbsp;&nbsp; Real-life examples =
for=20
real-life numeric problems make powerful additions to the Help you've =
come to=20
count on.</FONT></P>
<P><FONT size=3D2>Watch window&nbsp;&nbsp; Keep track of cells and their =
formulas=20
on the Watch Window toolbar, even when the cells are out of view. This =
moveable=20
toolbar tracks cell properties including workbook, worksheet, name, =
cell, value,=20
and formula.</FONT></P>
<P><FONT size=3D2>Expanded AutoSum&nbsp;functionality&nbsp;&nbsp; The =
practical=20
functionality of AutoSum <IMG height=3D20=20
src=3D"cid:005a01c3f6f4$db5e9d90$5450120a@rech" width=3D21 border=3D0> =
has expanded to=20
include a drop-down list of the most common functions. For example, you =
can=20
click Average from the list to calculate the average of a selected =
range, or=20
connect to the Function Wizard for more options.</FONT></P>
<P><FONT size=3D2>Formula evaluator&nbsp;&nbsp; You can see the various =
parts of a=20
nested formula evaluated in the order the formula is calculated by using =
a=20
simple dialog box on the Formula Auditing toolbar.</FONT></P>
<P><FONT size=3D2>Trace precedent and dependent cells with Formula=20
Auditing&nbsp;&nbsp; Use the Formula Auditing toolbar to graphically =
display, or=20
trace, the relationships between cells and formulas with blue arrows. =
You can=20
trace the precedent cells or the dependent cells.</FONT></P>
<P><FONT size=3D2>Formula error checking&nbsp;&nbsp; Like a grammar =
checker, Excel=20
uses certain rules to check for problems in formulas. These rules can =
help find=20
common mistakes. You can turn these rules on or off=20
individually.</FONT></P></DIV>
<P><A class=3DDropDown onclick=3DOutline2()=20
href=3D"mk:@MSITStore:C:\mso\mso02\Office10\1033\xlmain10.chm::/html/xlwh=
atsnewhome.htm#"><FONT=20
size=3D2><IMG height=3D10 src=3D"cid:005901c3f6f4$db5c2c90$5450120a@rec" =
width=3D14=20
border=3D0>Worksheet and workbook formatting</FONT></A></P>
<DIV class=3Dexpanded id=3DExpCol border=3D"0">
<P><FONT size=3D2>Color-coded worksheet tabs&nbsp;&nbsp; Organize your =
work by=20
adding color to your worksheet tabs.</FONT></P>
<P><FONT size=3D2>Control&nbsp; automatic changes with smart =
tags&nbsp;&nbsp;=20
Buttons that appear automatically on your worksheet can help you with =
tasks such=20
as automatic correction options, paste options, automatic fill options, =
insert=20
options, and formula error checking. With a click of a button you can =
choose=20
from options related to your task without leaving the worksheet or the =
cells=20
you're working on.</FONT></P>
<P><FONT size=3D2>Unmerge on the toolbar&nbsp;&nbsp; No more searching =
for a way=20
to unmerge cells. Now unmerge is conveniently located on the Format=20
toolbar.</FONT></P>
<P><FONT size=3D2>Retain column widths&nbsp;&nbsp; If you have =
worksheets with=20
specified column widths, now you can paste information from another =
worksheet=20
without losing that formatting by clicking the Paste Options <IMG =
height=3D20=20
src=3D"cid:005b01c3f6f4$db65c980$5450120a@rech" width=3D22 border=3D0> =
button, and=20
then clicking Keep Source Column Widths.</FONT></P>
<P><FONT size=3D2>Border drawing&nbsp;&nbsp; A new border drawing tool =
allows you=20
to outline complex borders with little effort.</FONT></P></DIV>
<H1><FONT size=3D2>More new features in Excel</FONT></H1>
<P><A class=3DDropDown onclick=3DOutline2()=20
href=3D"mk:@MSITStore:C:\mso\mso02\Office10\1033\xlmain10.chm::/html/xlwh=
atsnewhome.htm#"><FONT=20
size=3D2><IMG height=3D10 src=3D"cid:005901c3f6f4$db5c2c90$5450120a@rec" =
width=3D14=20
border=3D0>Everyday tasks</FONT></A></P>
<DIV class=3Dexpanded id=3DExpCol border=3D"0">
<P><FONT size=3D2>Find and replace&nbsp;&nbsp; Finding and replacing =
data in Excel=20
includes great new options to match formats and search an entire =
workbook or=20
worksheets.</FONT></P>
<P><FONT size=3D2>Links management&nbsp;&nbsp; Changes to the Edit Links =
dialog=20
box allow you to check the status of the links in your worksheet and =
make=20
changes. A new workbook option allows you to control whether to update =
links in=20
your workbook automatically.</FONT></P>
<P><FONT size=3D2>Hyperlink navigation&nbsp;&nbsp; Selecting a cell with =
a=20
hyperlink is improved. Click the hyperlink once to follow it. Click and =
hold to=20
select the cell.</FONT></P>
<P><FONT size=3D2>Sending a range&nbsp;&nbsp; Sending out mid-month =
reports and=20
summaries just got easier. Select a range on your worksheet, click =
E-mail <IMG=20
height=3D20 src=3D"cid:005c01c3f6f4$db683a80$5450120a@rech" width=3D21 =
border=3D0> on=20
the Standard toolbar, type an introduction to the report, and then send =
it=20
without spending extra time on the task.</FONT></P>
<P><FONT size=3D2>Insert and delete columns while filtering&nbsp;&nbsp; =
You can=20
insert and delete columns with AutoFilter turned on in Excel. You can =
even undo=20
the action and preserve any applied filtering.</FONT></P>
<P><FONT size=3D2>Speech playback&nbsp;&nbsp; An option to have a =
computer voice=20
play back data after every cell entry or after a range of cells has been =
entered=20
makes verifying data entry convenient and practical. You can even choose =
the=20
voice the computer uses to read back your data.&nbsp;This feature is =
available=20
in Chinese, Japanese, and English (U.S.) only.</FONT></P>
<P><FONT size=3D2>Printing&nbsp;&nbsp; You've asked for the ability to =
insert=20
graphics and file names in headers and footers, and with Excel you can. =
You'll=20
also find a handy A4 paper resizing option on the International tab =
under Tools=20
menu, Options command, which will scale the worksheet you formatted for =
A4 paper=20
if you have&nbsp; letter-size paper in your printer.</FONT></P>
<P><FONT size=3D2>Smart tags&nbsp;&nbsp; By turning on smart tags, you =
can type a=20
U.S. financial symbol and use Smart Tag Actions <IMG height=3D20=20
src=3D"cid:005d01c3f6f4$db6cf570$5450120a@rech" width=3D21 border=3D0> =
to insert a=20
stock quote in your worksheet, find out more about the company you're =
doing=20
business with, and more. You can also type the name of someone you've =
recently=20
sent an e-mail message to into a cell, and then use smart tag options to =

schedule a meeting or add the name to your contacts list, all without =
leaving=20
your worksheet.</FONT></P>
<P><FONT size=3D2>Item properties in PivotTables&nbsp;&nbsp; Online =
Analytical=20
Processing (OLAP) is a powerful tool for aggregating numeric =
information, and=20
now you can annotate your data with item properties to make your data =
warehouse=20
even more valuable.</FONT></P>
<P><FONT size=3D2>AutoRepublish&nbsp;&nbsp; Anyone who frequently =
publishes Excel=20
data to the Web will appreciate additional Web publishing features that =
allow=20
you to automatically republish items to Web pages whenever you save a =
workbook=20
with previously published items. </FONT></P>
<P><FONT size=3D2>Open and save XML&nbsp;&nbsp; With Excel, you can open =
and save=20
Extensible Markup Language (XML) files, save entire workbooks in the XML =

Spreadsheet format, and create queries to XML source data. </FONT></P>
<P><FONT size=3D2>Digital Dashboard and Web Parts&nbsp;&nbsp; Use Excel =
to create=20
Web Parts to include on your company's new Digital Dashboard. For =
example, you=20
might create an updateable sales chart to highlight your division's=20
contributions to the company's bottom line. </FONT></P>
<P><FONT size=3D2>Worksheet protection&nbsp;&nbsp; Excel adds power and=20
flexibility to protect your data from changes to worksheets and cells. =
You can=20
protect cell values and formulas, and allow the cell to be formatted. =
You can=20
also ensure that only specific users are allowed to change=20
cells.</FONT></P></DIV></DIV>
<DIV><BR><FONT size=3D2>-- <BR>Jim Rech<BR>Excel =
MVP</FONT></DIV></BODY></HTML>

------=_NextPart_001_0063_01C3F6CA.F29BA860--

------=_NextPart_000_0062_01C3F6CA.F29BA860
Content-Type: image/gif;
	name="bluedrop.gif"
Content-Transfer-Encoding: base64
Content-ID: <005901c3f6f4$db5c2c90$5450120a@rech>

R0lGODlhDgAKAMQTAAAdiQAA/6Wl7r268qmm4wwoj9DO9gcA39/h8QQA6gYA4pWV/9DQ/x0V2yQd
24uL/5qa/7e3/////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEA
ABMALAAAAAAOAAoAAAUs4CSOZGmeqFkAbMsWJOJAy8NIUYOUxhH8gYPhNFD8FIOUIJEQpEQEwnM6
CQEAOwA=

------=_NextPart_000_0062_01C3F6CA.F29BA860
Content-Type: image/gif;
	name="0226.gif"
Content-Transfer-Encoding: base64
Content-ID: <005a01c3f6f4$db5e9d90$5450120a@rech>

R0lGODlhFQAUAJEAAP///2Z4pQAAAAAAACH5BAAAAAAALAAAAAAVABQAAAI6jI+pAe0Pn4k0zorB
zXQ3AYYh5H0CdEpMBGal01YvnForW9tULN80SvIBRMQgp3fsCJOaZXJ2XEgXBQA7AA==

------=_NextPart_000_0062_01C3F6CA.F29BA860
Content-Type: image/gif;
	name="5720.gif"
Content-Transfer-Encoding: base64
Content-ID: <005b01c3f6f4$db65c980$5450120a@rech>

R0lGODlhFgAUAPf/AP//////AMzMzJmZmZmZAGZmmQAAmQAAAP//zP//mf//Zv//M//M///MzP/M
mf/MZv/MM//MAP+Z//+ZzP+Zmf+ZZv+ZM/+ZAP9m//9mzP9mmf9mZv9mM/9mAP8z//8zzP8zmf8z
Zv8zM/8zAP8A//8AzP8Amf8AZv8AM/8AAMz//8z/zMz/mcz/Zsz/M8z/AMzM/8zMmczMZszMM8zM
AMyZ/8yZzMyZmcyZZsyZM8yZAMxm/8xmzMxmmcxmZsxmM8xmAMwz/8wzzMwzmcwzZswzM8wzAMwA
/8wAzMwAmcwAZswAM8wAAJn//5n/zJn/mZn/Zpn/M5n/AJnM/5nMzJnMmZnMZpnMM5nMAJmZ/5mZ
zJmZZpmZM5lm/5lmzJlmmZlmZplmM5lmAJkz/5kzzJkzmZkzZpkzM5kzAJkA/5kAzJkAmZkAZpkA
M5kAAGb//2b/zGb/mWb/Zmb/M2b/AGbM/2bMzGbMmWbMZmbMM2bMAGaZ/2aZzGaZmWaZZmaZM2aZ
AGZm/2ZmzGZmZmZmM2ZmAGYz/2YzzGYzmWYzZmYzM2YzAGYA/2YAzGYAmWYAZmYAM2YAADP//zP/
zDP/mTP/ZjP/MzP/ADPM/zPMzDPMmTPMZjPMMzPMADOZ/zOZzDOZmTOZZjOZMzOZADNm/zNmzDNm
mTNmZjNmMzNmADMz/zMzzDMzmTMzZjMzMzMzADMA/zMAzDMAmTMAZjMAMzMAAAD//wD/zAD/mQD/
ZgD/MwD/AADM/wDMzADMmQDMZgDMMwDMAACZ/wCZzACZmQCZZgCZMwCZAABm/wBmzABmmQBmZgBm
MwBmAAAz/wAzzAAzmQAzZgAzMwAzAAAA/wAAzAAAZgAAM////wAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH/C0FET0JFOklSMS4wAt7t
ACH5BAEAANgALAAAAAAWABQAAAiSAAsIHEiwoEGBABIqXMiQIcKGEBs+ZHig4oGIACZarBggwMaL
Cx8eIDCAwAGPJw+UHAAyocgBLAXInKnSZMgCCUey/FgRZsuMOAHUXEmyaMmfIo0SMMC0qQGkQYeS
NMCQ6c2cSqkupKoVaE6iA7hadeoyataIWl8aFUs2bVChG7tWLYvWqV26GPNOzAvxoF+/AQEAOwAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==

------=_NextPart_000_0062_01C3F6CA.F29BA860
Content-Type: image/gif;
	name="3795.gif"
Content-Transfer-Encoding: base64
Content-ID: <005c01c3f6f4$db683a80$5450120a@rech>

R0lGODlhFQAUAKIAAP///2Z4pQAAAMzMzJmZmQAAmZkAAAAAACH5BAAAAAAALAAAAAAVABQAAANd
GLrcHiDKSaeqkWhdbyWUQHkTWIkSmWERCqjEIM/0gMKsYdgRjum8F0RiKhiPkaCPpYQIntAoFNAE
CGgYUfX6HAA2nOsWe5oKrbbrF2wdOckht1VKd/WGrPxj/0gAADsA

------=_NextPart_000_0062_01C3F6CA.F29BA860
Content-Type: image/gif;
	name="SmartTag2.gif"
Content-Transfer-Encoding: base64
Content-ID: <005d01c3f6f4$db6cf570$5450120a@rech>

R0lGODlhFQAUALP/AP//////AP8A//8AAAD//wD/AAAA/wAAAIAAgAAAgGZ4pcDAwICAgAAAAAAA
AAAAACwAAAAAFQAUAAAEXlDJSatVIOvNt+xg94UkMHIMcqiMiHHrFnuvdizdgtBbmqUJWytzAuxI
B00xmUkggpqjqWbcOGVKKjPz3EiLDOazaxxOOQgcZ7E9o9sqTlETViHM2RJprs/3XReBFREAOwA=

------=_NextPart_000_0062_01C3F6CA.F29BA860--

0
jrrech (1933)
2/19/2004 2:30:00 PM
Reply:

Similar Artilces:

Table relationships in Excel?
Hello, I have an excel file exported from SQL server. There are two tables 1. User (columns: id, name, address, etc) 2. Tasks (columns: id, userid, description) Is there a way to display the user NAME insead of the ID in the tasks table? Many thanks in advance! Saturnius You could do a vlookup on the linked field. If id is the same in both tables use a vlookup function "saturnius" wrote: > Hello, > I have an excel file exported from SQL server. There are two tables > 1. User (columns: id, name, address, etc) > 2. Tasks (columns: id, userid, description) > > Is...

Pulling data daily from a differently named report everyday
Hello, I have a spreadsheet where I use formulas to pull data from multiple reports on a shared server everyday. What I do is to save those reports under a certain name everyday since the formulas have to have the static report name in them to pull data. (For example, A1 may pull data from c:\reportfolder\reportA, B1 may pull from c: \reportfolder2\reportB, etc). In these report folders our IT group runs a new report in it everyday but of course they change the name of the report every day (to reflect the date) . . so in the reportfolder there will be "reportA-3-12-2009", and "...

enlarge validation drop down box excel 2000
I use validation drop down dialogue boxes in Excel 2000 to fill in purchase orders from an existing list of products. This works fine for the most part but I have a few questions. I have close to 1000 products on my list. When I use the drop down box to fill in my forms, the box is too small or too sensitive. With the list being that long, the data displayed in the box tends to jump around when I scroll, page up or page down. I feel that if the box could be made longer, the data would be more stable and easier to access. Is this possible? It appears to me that my validation list is on...

Hotmail: Can't Send/Receive 1 of 3 Accounts (using XP)
I'm using Outlook XP, and I have 3 Hotmail accounts. 2 of them I've been using for a long time without any problems. However, with the 3rd one I just added now, Outlook stalls for about a minute before spitting out: --- A connection to the server could not be established. http://services.msn.com/svcs/hotmail/httpmail.asp is now in offline mode. There may be server or network problems or your timeout interval may be too short. Please search Microsoft Outlook Help for [HTTP Mail troubleshooting] --- That's the message when I just add the account to the list of accounts. When I...

Excell graphs
Hello, I would like to make a grafh with excell but seem to be very lost. :confused: I would like the graph to go horisontal left to right continous(one bar.) Like a time-line. Thanks for any tips -- dammit1 ------------------------------------------------------------------------ dammit1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16311 View this thread: http://www.excelforum.com/showthread.php?threadid=278285 By 'time-line', do you mean a gantt chart? http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343 http://peltiertech...

Excel slow to epen with Network Connection
Hi Excel 2003 has recently become very slow to open. Regardless of the workbook / file. I have disabled all Add-In's and cleaned out the temp folder. The slow down appears to be related to having a live network / internet connection. If I disable my connection or pull out my network cable and launch Excel it opens straight away, if I plug it back in or re-enable it it takes 30-45 seconds to open. I have added Excel to the Windows Firewall exception list but it still takes around 15-25 seconds to open a workbook. Any ideas what its doing? I have read somewhere online about it bef...

Converting Outlook XP .pst to Outlook 2007 format
I installed Office 2007 over my existing Office XP. I prefer to keep my .pst file in a location that is easily found, I keep it in C:\1data\Outlook. When I try to convert it to the new format it tells me the file is in use, of course it is in use, I have to have Outlook open to convert. How do I get around that? I still wish to keep it in the same location as my two backup programmes, Outlook backup and Datakeeper backup, are pointed there. Thank you How are you trying to convert it? http://www.slipstick.com/outlook/ansi-to-unicode.asp -- Diane Poremsky [MVP - Outlook] Author, Teac...

How to programme this in excel?
This is what I want to know.. cell B1 & C1 is the cell to enter the duties of two staffs (namely X & Y). B1 is for staff X, C1 is for staff Y. staff can chose any one of duty in B1 & C1 frm a dropdownlist of 10 different duties(like "Break shift", "10 - 6 PM", "10 - 2 PM"..and so on).. We have another cell D1 E1 & F1 where we enter the staff strength in the shop on three intervals of time (say 10 - 2PM, 2 - 6PM, & 6 - 10PM) Assume D1 cell to show the staffs present in the shop during time interval 10 - 2PM, E1 for 2 - 6PM & F...

change excel pointer
Hiw can I change the colour of the white excel mouse pointer? Not an Excel question since changing the mouse pointer applies to all apps. Use Start|Control Panel->Mouse; open Pointers tab and make a selection. I hope no one else uses the computer! best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "sarahc" <sarahc@discussions.microsoft.com> wrote in message news:6D8625A7-EBDB-4A1F-B10D-969EE94BAA62@microsoft.com... > Hiw can I change the colour of the white excel mouse pointer? Hi, all; I'm using a different color mouse pointer...

Different margins on different pages
I am setting up a template for letters at work. The first page of our letterhead has one ste of margins and all subsequent pages will have a different sent of margins. I know that section breaks can be used, but if staff copy and paste text from existing letters into this new template, the section break moves. Is there any way of locking the section break to the page? so the pasted text goes over the top of it? Hi Lilly80, You could setup your document with a 'different first page' layout. That allows the first page to have a different set of margins to the rest o...

Excel 2007: No screen refresh
Hello I have a network which around 30 Windows XP pcs, incl. Office 2007 Pro. All updates are installed. Under some circumstance, Excel 2007 will not refresh the screen, for example when Excel was minimized and will maximized. I saw this problem not on all pcs but on some. I did also update the graphic card driver and on one pc I changed also the graphic card. Do you know this problem? Is there a workaround? Kind regards, Martin Schweizer ...

Different values for error bars in series
In Excel 2007, how do you put in different error bar values for each data point in a series? So far I am only able to put in one value for all in my bar chart. Hi, See Jon's blog on the subject. http://peltiertech.com/WordPress/error-bars-in-excel-2007/#comments Cheers Andy On 06/04/2010 15:52, wdwind1 wrote: > In Excel 2007, how do you put in different error bar values for each data > point in a series? So far I am only able to put in one value for all in my > bar chart. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info ...

Using banner paper Publisher 2002
Can you use banner paper in Publisher 2002? I am fairly new to the app and I have searched high and low and can't seem to figure out if I can use it and if so how? Any thougths? After managing to set up OE-QuoteFix on his new PC, Ed reads a message from Tracy Buthe <anonymous@discussions.microsoft.com>... > Can you use banner paper in Publisher 2002? I am fairly > new to the app and I have searched high and low and can't > seem to figure out if I can use it and if so how? What size banner paper are you using? -- Ed Bennett - MVP Microsoft Publisher http://www.mvp...

Excel Database #2
I have been doing my invoices in Excel from Office 2000 and storing the relevent bits into a database created by the template wizard in the Data drop-down. Now I have office XP on my new machine but this option does not appear in Excel, How can i create an invoice template that stores to a database now? ...

MS Excel help needed for newbie
Hi group. I'm by no means a programmer. I'm trying to knock together a (what should be) simple spreadsheet in Microsoft Excel for a calculation I have to do on a regular basis. I'm hoping that some kind people within this group will be able to help me with some formulas and questions. If anyone is able to help me could you please contact me at fflatthefatcat@hotmail.co.uk TIA Dean. On Oct 5, 7:57=A0am, Dean Brown <bramfiel...@googlemail.com> wrote: > Hi group. > > I'm by no means a programmer. I'm trying to knock together a (what > should be) simple ...

Windows 7 Upgrade from XP Pro IE 8 Certificate Errors
My PC was recently upgraded from XP Pro to Windows 7 Pro. I had IE 8 before on XP, but now I am getting certificate errors for many of the sites that I regularly visit including our companies own intranet site, google mail, several financial institutions websites, etc. I know these sites are safe, but I cannot figure out what the upgrade process has done to my system to cause me to get these certificate errors. I have spent much time googling, and tried many different IE setttings, double checked the date time setting on my machine etc. all to no avail. PLEASE HELP!!! Below ...

Can't save Excel using Save button,
When I try to save an Excel spreadsheet, I get a message saying "GWXL97.xla could not be found. Check spelling of file name and verify that the file location is correct." I have never named any of files by that name and don't know what it refers to. I have to hit the "X" button on the upper right hand corner and wait for it to ask me if I want to save it, then go through the save process. This happens even if I try to save changes to an existing excel document This may help... xl: close button is dimmed after groupwise is installed http://support.microsoft.com...

A Different CRM for GP
Hello, We are pondering the idea of implementing MS Dynamics CRM. However, I am curious whether anyone else has had success in integrating a different CRM product with GP 10.0. It's not that we don't like the MS product; I just like to ensure I have covered all bases. Our partner does not have any other recommendations as they have not worked with any other CRM applications. Any information would be greatly apprecaited. Thank you, -- Jessie GoldMine is a good product, very mature, and easier to maintain table structures. There are links to GP but I cannot remember the fir...

Unable to open embedded word document from Excel
Hi, I have Excel 2003 (SP3) installed on my computer. In an Excel file, I inserted a word object (created from file, display as icon) and the insertion worked fine. When I try to open my word document from Excel, nothing happens. No error message and the file doesn't open. It is like if my file icon is simply a draw. When I open the same Excel file with another computer(Excel 2003), I can open my word embedded object easily. In fact, I can insert Excel or txt object in Word document without any problem but everything I insert in Excel doesn't work (word, txt, et...

How to add a description to an excel table
Hello, how can I add a decription to an excel table? I want to set a name and a description of a table content. So I know, what data is contained in a table. My workspace contains more than one table. bye Click on any cell in your table(s). Then Insert > Comment -- Gary''s Student "Przemyslaw" wrote: > Hello, > how can I add a decription to an excel table? > I want to set a name and a description of a table content. So I know, what > data is contained in a table. My workspace contains more than one table. > bye ...

"Excel needs to close"
Frequently, when turning my computer on, I will get the error message, "Microsoft Excel for Windows has encountered a problem and needs to close". It has not been left on nor was it used in the previous session of computer use. I am using XP Home. How can I fix it or should I even be concerned? Check to see what is starting up when you boot your computer up. See if anything is in teh startup folder, check using msconfig as well "Ed Mullikin" <edmull2@cox.net> wrote in message news:3om_h.111445$s8.90157@newsfe21.lga... > Frequently, when turning my comp...

Copying spinners for each cell in Excel 2003?
I have an inventory tracking sheet that keeps track of my inventory. I've added in a spinner control to increase/decrease a value in a certain cell. In my worksheet, the value is located in column E, and the spinner control is in column F. I have about 200 spinners to add, and need to fill down the links to it's adjacent cell. I found something related to checkboxes, but how do I adapt it for the spinner control? The first value is in E3, and the first spinner is in F3. Create 200 spiners in F3:F203 and link to E3:E203 Sub add_spinners_and_links() Dim myRng As Range Dim Spnr...

character spacing Excel 2003
How does one get all numbers in a column to have set spacing instead of proportional spacing? I remember setting proportional or fixed back in the days of DOS, and haven't used it since and I'm unable to find it in Microsofts online help for either Excel or Word (2003). Try using a fixed width font like Courier or Courier New. -- Biff Microsoft Excel MVP "Joe" <JOsterheim@gmail.com> wrote in message news:nfvtf3t6lq188pkavtqadelnas3a5i28be@4ax.com... > How does one get all numbers in a column to have set spacing instead > of proportional spacing? I remember...

2 users access calendar online with different rights
hi user A wants to give user B permission to see, add and edit entries in calendar online http://www.exchangedomain.ch/usersname/kalender/ user B is able to see, but not to add or edit entries at the moment in outlook itself its working. user B can open the folder calendar of user A and make entries and change entries what have to be done that this is possible also with web access exchange ? thankx mike schwarz On Thu, 26 Oct 2006 14:09:29 +0200, "Mike Schwarz" <ctek@ctek.ch> wrote: >hi > >user A wants to give user B permission to see, add and edit entries in &...

Same column, different cell width at different row
I have tried inserting a break and split, didn't work. I just want to separate the top half of a page with the bottom half so I can apply different cell width on the same column. Or how would I be able to do this? Same column but different cell width. Thanks! Glenn You can't do that. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Glenn Chung" <GlennChung@discussions.microsoft.com> wrote in message news:20746997-9D99-4684-A352-120370D27036@microsoft.com... >I have tried inserting a break and split, di...