Docstoc

FREE LEGAL FORMS GUIDES, 52 STATE COURT FORMS PACKAGES, CHEAPEST SITE ON THE WEB, ALL PACKAGES COST ONLY $19.99, SINGLE LEGAL FORMS ONLY $1.99,

Document Sample
FREE LEGAL FORMS GUIDES, 52 STATE COURT FORMS PACKAGES, CHEAPEST SITE ON THE WEB, ALL PACKAGES COST ONLY $19.99, SINGLE LEGAL FORMS ONLY $1.99, Powered By Docstoc
					<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html ><head
id="OOHead"><meta http-equiv="Content-Type" content="text/html;
charset=utf-8" /><meta name="robots" content="noindex,nofollow" /><meta
name="MS.LOCALE" content="en-US"/><title>
      Excel 2007 Help
</title><link id="css-ontclient"
href="http://officeimg.vo.msecnd.net/_layouts/ont.client.css?b=5540%2E400
0" rel="stylesheet" /><link id="css-article"
href="http://officeimg.vo.msecnd.net/_layouts/article.css?b=5540%2E4000"
rel="stylesheet" /><link id="css-content"
href="http://officeimg.vo.msecnd.net/en-
us/files/156/550/HX010151526.css?b=5540%2E4000" rel="stylesheet"
/><noscript><link id="css-article-ns"
href="http://officeimg.vo.msecnd.net/_layouts/article.noscript.css?b=5540
%2E4000" rel="stylesheet"></link></noscript><script
id="AjaxClientLibrary"
src="http://officeimg.vo.msecnd.net/_layouts/MicrosoftAjax.js?b=5540%2E40
00" type="text/javascript"></script><script id="jquerystcjs"
src="http://officeimg.vo.msecnd.net/_layouts/jquery.js?b=5540%2E4000"
type="text/javascript"></script><script id="Globaljsjs" src="/en-
us/jsonstrings.aspx?b=5540.4000&g=Global"
type="text/javascript"></script><script id="GlobalSvc" src="/en-
us/_vti_bin/anonsvc/Global.svc/js?b=5540.4000"
type="text/javascript"></script><script id="oostcjs"
src="http://officeimg.vo.msecnd.net/_layouts/oo.js?b=5540%2E4000"
type="text/javascript"></script><script id="Playerjsjs" src="/en-
us/jsonstrings.aspx?b=5540.4000&g=Player"
type="text/javascript"></script><script id="SilverlightJs"
src="http://officeimg.vo.msecnd.net/_layouts/Silverlight.js?b=5540%2E4000
" type="text/javascript"></script><script id="feedbackstcjs"
src="http://officeimg.vo.msecnd.net/_layouts/feedback.js?b=5540%2E4000"
type="text/javascript"></script><script id="VideoControlstcjs"
src="http://officeimg.vo.msecnd.net/_layouts/VideoControl.js?b=5540%2E400
0" type="text/javascript"></script><script id="o12playerstcjs"
src="http://officeimg.vo.msecnd.net/_layouts/o12player.js?b=5540%2E4000"
type="text/javascript"></script><script id="Articlejsjs" src="/en-
us/jsonstrings.aspx?b=5540.4000&g=Article"
type="text/javascript"></script><script id="articlestcjs"
src="http://officeimg.vo.msecnd.net/_layouts/article.js?b=5540%2E4000"
type="text/javascript"></script><script type="text/javascript">var
g_llcc="en-us";var
g_mktgrp="english";OOArticles.SetArticleLinkMode('hv');var
g_feedbackDecimalSeparator=".";var g_feedbackControlStore=null;var
g_feedbackInitQuestionCache=null;var g_feedbackNullValue="null";var
g_strFeedbackLegal="By clicking Submit, you accept the \u003ca
target=\u0022_blank\u0022 class=\u0022cdFeedbackLegalLink\u0022
href=\u0022http:\u002f\u002foffice.microsoft.com\u002fen-
us\u002ftou.aspx\u0022\u003eMicrosoft Service
Agreement\u003c\u002fa\u003e";var g_strCharRemaining="Characters
remaining: {0}";var g_strCharOver="You entered {0} characters. Please
enter {1} or fewer characters.";var g_strFeedbackSubmit="Submit";var
g_strFeedbackStarsTooltip="{0} of 5 stars";var
g_strFeedbackROStarsTooltip="Click to rate: {0} out of 5 stars";if
(typeof GlobalSvc !== 'undefined' && typeof GlobalSvc.set_path !==
'undefined')GlobalSvc.set_path('/en-
us/_vti_bin/anonsvc/Global.svc');$(function(){InitGlobalFeedbackVariables
();InitGlobalFeedbackVariables();g_feedbackControlStore.AddEntry('HA01021
7956', new FeedbackControl('HA010217956','Article','Asset', false));var
feedbackControl = g_feedbackControlStore.GetEntry('HA010217956');if
(typeof feedbackControl !== 'undefined' && feedbackControl != null) {
feedbackControl.SetFullParent('feedbackDiv');feedbackControl.LoadInitialQ
uestionGroup();}var SeeAlsoControl=new
OOC.SeeAlsoControl();$("body")[0].focus();OOC.Chrome.InitSearchBox();OOC.
Chrome.InitAspNetForm();});</script><meta name="DCSext.oo_source"
content="Client" /><meta name="DCSext.oo_app" content="ZXL120" /><meta
name="DCSext.oo_ul" content="en-US" /><meta name="DCSext.oo_offver"
content="Office+2007" /><meta name="DCSext.oo_assetid"
content="HA010217956" /><meta name="WT.cg_n" content="client" /><meta
name="DCSext.oo_market" content="en-US" /><meta id="wt-title"
name="WT.ti" content="" /><meta name="DCSext.oo_bc" content="client"
/><meta name="DCSext.oo_clicktype" content="4" /><meta name="WT.dl"
content="13" /><script type="text/javascript">$(function()
{AdjustClientLinksForMetrics('ZXL','12');});</script><script
type="text/javascript">var gLinkT='assetid=xt';var
gDomain='m.webtrends.com';var
gTrackEvents=(typeof(gTrackEventsOverride)!='undefined')&&gTrackEventsOve
rride?1:0;var gDcsId='dcs0junic89k7m2gzez6wz0k8_7v8n';var
gFpcDom='.microsoft.com';var gFpc='WT_FPC';$(function(){$('#wt-
title').attr('content',document.title);OOUtil.JSAsyncLoader(OOUtil.Script
Reference('http:\u002f\u002fofficeimg.vo.msecnd.net\u002f_layouts\u002fwt
.js?b=5540\u00252E4000'));});</script></head><body
class="cdClientViewerBody cdclv14Body"><form name="OOForm" method="post"
action="../sites/production/LEGACY-SERVICE-
HELPPREVIEW.ASPX?AssetId=HA102179569990&amp;lcid=1033&amp;NS=EXCEL&amp;Ve
rsion=12&amp;CTT=4&amp;origin=EC001022991&amp;lc=en-us" id="OOForm">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE"
value="/wEPDwUKMTI2MDU2NzI4NQ9kFgQCAw8WAh4JaW5uZXJodG1sBdo+DQo8cD48YSBuYW
1lPSJCTWJhY2t0b3RvcCIgaWQ9IkJNYmFja3RvdG9wIj48L2E+WW91IGNhbiB1c2UgYW4gT2Z
maWNlIERhdGEgQ29ubmVjdGlvbiAoLm9kYykgZmlsZSB0byBjb25uZWN0IHRvIGEgTWljcm9z
b2Z0IFNRTCBTZXJ2ZXIgZGF0YWJhc2UgZnJvbSBhIE1pY3Jvc29mdCBPZmZpY2UgRXhjZWwgM
jAwNyBmaWxlLiBTUUwgU2VydmVyIGlzIGEgZnVsbC1mZWF0dXJlZCwgcmVsYXRpb25hbCBkYX
RhYmFzZSBwcm9ncmFtIHRoYXQgaXMgZGVzaWduZWQgZm9yIGVudGVycHJpc2Utd2lkZSBkYXR
hIHNvbHV0aW9ucyB0aGF0IHJlcXVpcmUgb3B0aW11bSBwZXJmb3JtYW5jZSwgYXZhaWxhYmls
aXR5LCBzY2FsYWJpbGl0eSwgYW5kIHNlY3VyaXR5LjwvcD4NCjxvbCBjbGFzcz0iY250SW5kZ
W50MzYiIHR5cGU9IjEiIHN0YXJ0PSIxIj4NCiAgPGxpPk9uIHRoZSA8YiBjbGFzcz0idWkiPk
RhdGE8L2I+IHRhYiwgaW4gdGhlIDxiIGNsYXNzPSJ1aSI+R2V0IEV4dGVybmFsIERhdGE8L2I
+IGdyb3VwLCBjbGljayA8YiBjbGFzcz0idWkiPkZyb20gT3RoZXIgU291cmNlczwvYj4sIGFu
ZCB0aGVuIGNsaWNrIDxiIGNsYXNzPSJ1aSI+RnJvbSBTUUwgU2VydmVyPC9iPi48L2xpPg0KP
C9vbD4NCjxwIGNsYXNzPSJjbnRJbmRlbnQzNiI+PGltZyBzcmM9Imh0dHA6Ly9vZmZpY2VpbW
cudm8ubXNlY25kLm5ldC9lbi11cy9maWxlcy83ODIvODExL1pBMDEwMTY1NDA1LmdpZiIgYWx
0PSJFeGNlbCBSaWJib24gaW1hZ2UiIHRpdGxlPSJFeGNlbCBSaWJib24gaW1hZ2UiIGJvcmRl
cj0iMCI+IDwvcD4NCjxwIGNsYXNzPSJjbnRJbmRlbnQzNiI+VGhlIERhdGEgQ29ubmVjdGlvb
iBXaXphcmQgc3RhcnRzLiBUaGlzIHdpemFyZCBoYXMgdGhyZWUgcGFnZXMuPC9wPg0KPHAgY2
xhc3M9ImNudEluZGVudDM2Ij48YiBjbGFzcz0icnVuaW5oZWFkIj5QYWdlIDE6IENvbm5lY3Q
gdG8gRGF0YWJhc2UgU2VydmVyPC9iPiZuYnNwOyZuYnNwOyZuYnNwO8KgPC9wPg0KPG9sIGNs
YXNzPSJjbnRJbmRlbnQzNiIgdHlwZT0iMSIgc3RhcnQ9IjIiPg0KICA8bGk+SW4gc3RlcCAxL
CB0eXBlIHRoZSBuYW1lIG9mIHRoZSBTUUwgU2VydmVyIGNvbXB1dGVyIGluIHRoZSA8YiBjbG
Fzcz0idWkiPlNlcnZlciBuYW1lPC9iPiBib3guPC9saT4NCiAgPGxpPkluIHN0ZXAgMiwgdW5
kZXIgPGIgY2xhc3M9InVpIj5Mb2cgb24gY3JlZGVudGlhbHM8L2I+LCBkbyBvbmUgb2YgdGhl
IGZvbGxvd2luZzo8L2xpPg0KICA8dWwgdHlwZT0iZGlzYyI+DQogICAgPGxpPlRvIHVzZSB5b
3VyIGN1cnJlbnQgTWljcm9zb2Z0IFdpbmRvd3MgdXNlciBuYW1lIGFuZCBwYXNzd29yZCwgY2
xpY2sgPGIgY2xhc3M9InVpIj5Vc2UgV2luZG93cyBBdXRoZW50aWNhdGlvbjwvYj4uPC9saT4
NCiAgICA8bGk+VG8gZW50ZXIgYSBkYXRhYmFzZSB1c2VyIG5hbWUgYW5kIHBhc3N3b3JkLCBj
bGljayA8YiBjbGFzcz0idWkiPlVzZSB0aGUgZm9sbG93aW5nIFVzZXIgTmFtZSBhbmQgUGFzc
3dvcmQ8L2I+LCBhbmQgdGhlbiB0eXBlIHlvdXIgdXNlciBuYW1lIGFuZCBwYXNzd29yZCBpbi
B0aGUgY29ycmVzcG9uZGluZyA8YiBjbGFzcz0idWkiPlVzZXIgTmFtZTwvYj4gYW5kIDxiIGN
sYXNzPSJ1aSI+UGFzc3dvcmQ8L2I+IGJveGVzLjwvbGk+DQogIDwvdWw+DQo8L29sPg0KPHAg
Y2xhc3M9ImNudEluZGVudDcyIj48YiBjbGFzcz0iY250U2VjdXJpdHkiPlNlY3VyaXR5PC9iP
iZuYnNwOyZuYnNwOyBVc2Ugc3Ryb25nIHBhc3N3b3JkcyB0aGF0IGNvbWJpbmUgdXBwZXJjYX
NlIGFuZCBsb3dlcmNhc2UgbGV0dGVycywgbnVtYmVycywgYW5kIHN5bWJvbHMuIFdlYWsgcGF
zc3dvcmRzIGRvbid0IG1peCB0aGVzZSBlbGVtZW50cy4gU3Ryb25nIHBhc3N3b3JkOiBZNmRo
IWV0NS4gV2VhayBwYXNzd29yZDogSG91c2UyNy4gUGFzc3dvcmRzIHNob3VsZCBiZSA4IG9yI
G1vcmUgY2hhcmFjdGVycyBpbiBsZW5ndGguIEEgcGFzcyBwaHJhc2UgdGhhdCB1c2VzIDE0IG
9yIG1vcmUgY2hhcmFjdGVycyBpcyBiZXR0ZXIuIEZvciBtb3JlIGluZm9ybWF0aW9uLCBzZWU
gPGEgaHJlZj0iaHR0cDovL29mZmljZS5taWNyb3NvZnQuY29tL3JlZGlyL1hUMDExMDA0NTE5
OTkwLmFzcHg/Y2xpZW50PTEmVmVyPTEyJk5TPUVYQ0VMJmxjPWVuJTJEVVMmQ1RUPTUmb3JpZ
2luPUhBMDEwMjE3OTU2Ij5IZWxwIHByb3RlY3QgeW91ciBwZXJzb25hbCBpbmZvcm1hdGlvbi
B3aXRoIHN0cm9uZyBwYXNzd29yZHM8L2E+Lkl0IGlzIGNyaXRpY2FsIHRoYXQgeW91IHJlbWV
tYmVyIHlvdXIgcGFzc3dvcmQuIElmIHlvdSBmb3JnZXQgeW91ciBwYXNzd29yZCwgTWljcm9z
b2Z0IGNhbm5vdCByZXRyaWV2ZSBpdC4gU3RvcmUgdGhlIHBhc3N3b3JkcyB0aGF0IHlvdSB3c
ml0ZSBkb3duIGluIGEgc2VjdXJlIHBsYWNlIGF3YXkgZnJvbSB0aGUgaW5mb3JtYXRpb24gdG
hhdCB0aGV5IGhlbHAgcHJvdGVjdC48L3A+DQo8cCBjbGFzcz0iY250SW5kZW50MzYiPjxiIGN
sYXNzPSJydW5pbmhlYWQiPlBhZ2UgMjogU2VsZWN0IERhdGFiYXNlIGFuZCBUYWJsZTwvYj4m
bmJzcDsmbmJzcDsmbmJzcDvCoDwvcD4NCjxvbCBjbGFzcz0iY250SW5kZW50MzYiIHR5cGU9I
jEiIHN0YXJ0PSI0Ij4NCiAgPGxpPlVuZGVyIDxiIGNsYXNzPSJ1aSI+U2VsZWN0IHRoZSBkYX
RhYmFzZSB0aGF0IGNvbnRhaW5zIHRoZSBkYXRhIHlvdSB3YW50PC9iPiwgc2VsZWN0IGEgZGF
0YWJhc2UuIFVuZGVyIDxiIGNsYXNzPSJ1aSI+Q29ubmVjdCB0byBhIHNwZWNpZmljIHRhYmxl
PC9iPiwgc2VsZWN0IGEgc3BlY2lmaWMgdGFibGUgb3Igdmlldy48L2xpPg0KPC9vbD4NCjxwI
GNsYXNzPSJjbnRJbmRlbnQzNiI+QWx0ZXJuYXRpdmVseSwgeW91IGNhbiBjbGVhciB0aGUgPG
IgY2xhc3M9InVpIj5Db25uZWN0IHRvIGEgc3BlY2lmaWMgdGFibGU8L2I+IGNoZWNrIGJveCw
gc28gdGhhdCBvdGhlciB1c2VycyB3aG8gdXNlIHRoaXMgY29ubmVjdGlvbiBmaWxlIHdpbGwg
YmUgcHJvbXB0ZWQgZm9yIHRoZSBsaXN0IG9mIHRhYmxlcyBhbmQgdmlld3MuPC9wPg0KPHAgY
2xhc3M9ImNudEluZGVudDM2Ij48YiBjbGFzcz0icnVuaW5oZWFkIj5QYWdlIDM6IFNhdmUgRG
F0YSBDb25uZWN0aW9uIEZpbGUgYW5kIEZpbmlzaDwvYj4mbmJzcDsmbmJzcDsmbmJzcDvCoDw
vcD4NCjxvbCBjbGFzcz0iY250SW5kZW50MzYiIHR5cGU9IjEiIHN0YXJ0PSI1Ij4NCiAgPGxp
Pk9wdGlvbmFsbHksIGluIHRoZSA8YiBjbGFzcz0idWkiPkZpbGUgTmFtZTwvYj4gYm94LCByZ
XZpc2UgdGhlIHN1Z2dlc3RlZCBmaWxlIG5hbWUuIENsaWNrIDxiIGNsYXNzPSJ1aSI+QnJvd3
NlPC9iPiB0byBjaGFuZ2UgdGhlIGRlZmF1bHQgZmlsZSBsb2NhdGlvbiAoTXkgRGF0YSBTb3V
yY2VzKS48L2xpPg0KICA8bGk+T3B0aW9uYWxseSwgdHlwZSBhIGRlc2NyaXB0aW9uIG9mIHRo
ZSBmaWxlLCBhIGZyaWVuZGx5IG5hbWUsIGFuZCBjb21tb24gc2VhcmNoIHdvcmRzIGluIHRoZ
SA8YiBjbGFzcz0idWkiPkRlc2NyaXB0aW9uPC9iPiwgPGIgY2xhc3M9InVpIj5GcmllbmRseS
BOYW1lPC9iPiwgYW5kIDxiIGNsYXNzPSJ1aSI+U2VhcmNoIEtleXdvcmRzPC9iPiBib3hlcy4
8L2xpPg0KICA8bGk+VG8gZW5zdXJlIHRoYXQgdGhlIGNvbm5lY3Rpb24gZmlsZSBpcyBhbHdh
eXMgdXNlZCB3aGVuIHRoZSBkYXRhIGlzIHVwZGF0ZWQsIGNsaWNrIHRoZSA8YiBjbGFzcz0id
WkiPkFsd2F5cyBhdHRlbXB0IHRvIHVzZSB0aGlzIGZpbGUgdG8gcmVmcmVzaCB0aGlzIGRhdG
E8L2I+IGNoZWNrIGJveC4gVGhpcyBjaGVjayBib3ggZW5zdXJlcyB0aGF0IHVwZGF0ZXMgdG8
gdGhlIGNvbm5lY3Rpb24gZmlsZSB3aWxsIGFsd2F5cyBiZSB1c2VkIGJ5IGFsbCB3b3JrYm9v
a3MgdGhhdCB1c2UgdGhhdCBjb25uZWN0aW9uIGZpbGUuPC9saT4NCiAgPGxpPlRvIHNwZWNpZ
nkgaG93IHRoZSBleHRlcm5hbCBkYXRhIHNvdXJjZSBvZiBhIFBpdm90VGFibGUgcmVwb3J0IG
lzIGFjY2Vzc2VkIGlmIHRoZSB3b3JrYm9vayBpcyBzYXZlZCB0byBFeGNlbCBTZXJ2aWNlcyB
hbmQgaXMgb3BlbmVkIGJ5IHVzaW5nIEV4Y2VsIFNlcnZpY2VzLCBjbGljayA8YiBjbGFzcz0i
dWkiPkF1dGhlbnRpY2F0aW9uIFNldHRpbmdzPC9iPiwgYW5kIHRoZW4gc2VsZWN0IG9uZSBvZ
iB0aGUgZm9sbG93aW5nIG9wdGlvbnMgdG8gbG9nIG9uIHRvIHRoZSBkYXRhIHNvdXJjZTogPC
9saT4NCiAgPHVsIHR5cGU9ImRpc2MiPg0KICAgIDxsaT48YiBjbGFzcz0icnVuaW5oZWFkIj4
8YiBjbGFzcz0idWkiPldpbmRvd3MgQXV0aGVudGljYXRpb248L2I+PC9iPiZuYnNwOyZuYnNw
OyZuYnNwO8KgU2VsZWN0IHRoaXMgb3B0aW9uIHRvIHVzZSB0aGUgV2luZG93cyB1c2VyIG5hb
WUgYW5kIHBhc3N3b3JkIG9mIHRoZSBjdXJyZW50IHVzZXIuIFRoaXMgaXMgdGhlIG1vc3Qgc2
VjdXJlIG1ldGhvZCwgYnV0IGl0IGNhbiBhZmZlY3QgcGVyZm9ybWFuY2Ugd2hlbiBtYW55IHV
zZXJzIGFyZSBjb25uZWN0ZWQgdG8gdGhlIHNlcnZlci48L2xpPg0KICAgIDxsaT48YiBjbGFz
cz0icnVuaW5oZWFkIj48YiBjbGFzcz0idWkiPlNTTzwvYj48L2I+Jm5ic3A7Jm5ic3A7Jm5ic
3A7wqBTZWxlY3QgdGhpcyBvcHRpb24gdG8gdXNlIFNpbmdsZSBTaWduIE9uIChTU08pLCBhbm
QgdGhlbiBlbnRlciB0aGUgYXBwcm9wcmlhdGUgaWRlbnRpZmljYXRpb24gc3RyaW5nIGluIHR
oZSA8YiBjbGFzcz0idWkiPlNTTyBJRDwvYj4gYm94LiBBIHNpdGUgYWRtaW5pc3RyYXRvciBj
YW4gY29uZmlndXJlIGEgV2luZG93cyBTaGFyZVBvaW50IFNlcnZpY2VzIHNpdGUgdG8gdXNlI
GEgU2luZ2xlIFNpZ24gT24gZGF0YWJhc2UgaW4gd2hpY2ggYSB1c2VyIG5hbWUgYW5kIHBhc3
N3b3JkIGNhbiBiZSBzdG9yZWQuIFRoaXMgbWV0aG9kIGNhbiBiZSB0aGUgbW9zdCBlZmZpY2l
lbnQgd2hlbiBtYW55IHVzZXJzIGFyZSBjb25uZWN0ZWQgdG8gdGhlIHNlcnZlci48L2xpPg0K
ICAgIDxsaT48YiBjbGFzcz0icnVuaW5oZWFkIj48YiBjbGFzcz0idWkiPk5vbmU8L2I+PC9iP
iZuYnNwOyZuYnNwOyZuYnNwO8KgU2VsZWN0IHRoaXMgb3B0aW9uIHRvIHNhdmUgdGhlIHVzZX
IgbmFtZSBhbmQgcGFzc3dvcmQgaW4gdGhlIGNvbm5lY3Rpb24gZmlsZS4gPC9saT4NCiAgPC9
1bD4NCjwvb2w+DQo8cCBjbGFzcz0iY250SW5kZW50NzIiPjxiIGNsYXNzPSJjbnRTZWN1cml0
eSI+U2VjdXJpdHk8L2I+Jm5ic3A7Jm5ic3A7QXZvaWQgc2F2aW5nIGxvZ29uIGluZm9ybWF0a
W9uIHdoZW4gY29ubmVjdGluZyB0byBkYXRhIHNvdXJjZXMuIFRoaXMgaW5mb3JtYXRpb24gbW
F5IGJlIHN0b3JlZCBhcyBwbGFpbiB0ZXh0LCBhbmQgYSBtYWxpY2lvdXMgdXNlciBjb3VsZCB
hY2Nlc3MgdGhlIGluZm9ybWF0aW9uIHRvIGNvbXByb21pc2UgdGhlIHNlY3VyaXR5IG9mIHRo
ZSBkYXRhIHNvdXJjZS48L3A+DQo8b2wgY2xhc3M9ImNudEluZGVudDM2IiB0eXBlPSIxIiBzd
GFydD0iOSI+DQogIDxsaT4NCiAgICA8cD48YiBjbGFzcz0iY250bm90ZSI+Jm5ic3A7Tm90ZS
ZuYnNwOzwvYj4mbmJzcDsmbmJzcDtUaGUgYXV0aGVudGljYXRpb24gc2V0dGluZyBpcyB1c2V
kIG9ubHkgYnkgRXhjZWwgU2VydmljZXMsIGFuZCBub3QgYnkgRXhjZWwuPC9wPg0KICA8L2xp
Pg0KICA8bGk+Q2xpY2sgPGIgY2xhc3M9InVpIj5PSzwvYj4uPC9saT4NCiAgPGxpPkNsaWNrI
DxiIGNsYXNzPSJ1aSI+RmluaXNoPC9iPiB0byBjbG9zZSB0aGUgRGF0YSBDb25uZWN0aW9uIF
dpemFyZC48L2xpPg0KPC9vbD4NCjxwIGNsYXNzPSJjbnRJbmRlbnQzNiI+VGhlIDxiIGNsYXN
zPSJ1aSI+SW1wb3J0IERhdGE8L2I+IGRpYWxvZyBib3ggaXMgZGlzcGxheWVkLjwvcD4NCjxv
bCBjbGFzcz0iY250SW5kZW50MzYiIHR5cGU9IjEiIHN0YXJ0PSIxMiI+DQogIDxsaT5VbmRlc
iA8YiBjbGFzcz0idWkiPlNlbGVjdCBob3cgeW91IHdhbnQgdG8gdmlldyB0aGlzIGRhdGEgaW
4geW91ciB3b3JrYm9vazwvYj4sIGRvIG9uZSBvZiB0aGUgZm9sbG93aW5nOjwvbGk+DQogIDx
1bCB0eXBlPSJkaXNjIj4NCiAgICA8bGk+VG8gY3JlYXRlIGFuIEV4Y2VsIHRhYmxlLCBjbGlj
ayA8YiBjbGFzcz0idWkiPlRhYmxlPC9iPiAodGhpcyBpcyB0aGUgZGVmYXVsdCkuPC9saT4NC
iAgICA8bGk+VG8gY3JlYXRlIGEgUGl2b3RUYWJsZSByZXBvcnQsIGNsaWNrIDxiIGNsYXNzPS
J1aSI+UGl2b3RUYWJsZSBSZXBvcnQ8L2I+LjwvbGk+DQogICAgPGxpPlRvIGNyZWF0ZSBhIFB
pdm90Q2hhcnQgYW5kIFBpdm90VGFibGUgcmVwb3J0LCBjbGljayA8YiBjbGFzcz0idWkiPlBp
dm90Q2hhcnQgYW5kIFBpdm90VGFibGUgUmVwb3J0PC9iPi48L2xpPg0KICA8L3VsPg0KPC9vb
D4NCjxwIGNsYXNzPSJjbnRJbmRlbnQzNiI+PGIgY2xhc3M9ImNudG5vdGUiPiZuYnNwO05vdG
UmbmJzcDs8L2I+Jm5ic3A7Jm5ic3A7VGhlIDxiIGNsYXNzPSJ1aSI+T25seSBDcmVhdGUgQ29
ubmVjdGlvbjwvYj4gb3B0aW9uIGlzIGF2YWlsYWJsZSBvbmx5IGZvciBhbiBPTEFQIGRhdGFi
YXNlLjwvcD4NCjxvbCBjbGFzcz0iY250SW5kZW50MzYiIHR5cGU9IjEiIHN0YXJ0PSIxMyI+D
QogIDxsaT5VbmRlciA8YiBjbGFzcz0idWkiPldoZXJlIGRvIHlvdSB3YW50IHRvIHB1dCB0aG
UgZGF0YT88L2I+LCBkbyBvbmUgb2YgdGhlIGZvbGxvd2luZzo8L2xpPg0KICA8dWwgdHlwZT0
iZGlzYyI+DQogICAgPGxpPlRvIHBsYWNlIHRoZSBkYXRhIGluIGFuIGV4aXN0aW5nIHdvcmtz
aGVldCwgc2VsZWN0IDxiIGNsYXNzPSJ1aSI+RXhpc3Rpbmcgd29ya3NoZWV0PC9iPiwgYW5kI
HRoZW4gdHlwZSB0aGUgbmFtZSBvZiB0aGUgZmlyc3QgY2VsbCBpbiB0aGUgcmFuZ2Ugb2YgY2
VsbHMgd2hlcmUgeW91IHdhbnQgdG8gbG9jYXRlIHRoZSBkYXRhLjwvbGk+DQogIDwvdWw+DQo
8L29sPg0KPHAgY2xhc3M9ImNudEluZGVudDcyIj5BbHRlcm5hdGl2ZWx5LCBjbGljayA8YiBj
bGFzcz0idWkiPkNvbGxhcHNlIERpYWxvZzwvYj4gPGltZyBzcmM9Imh0dHA6Ly9vZmZpY2Vpb
Wcudm8ubXNlY25kLm5ldC9lbi11cy9maWxlcy8yODgvNDg5L1pBMDA2MDQ0NDg5LmdpZiIgYW
x0PSJCdXR0b24gaW1hZ2UiIHRpdGxlPSJCdXR0b24gaW1hZ2UiIGJvcmRlcj0iMCI+IHRvIHR
lbXBvcmFyaWx5IGNvbGxhcHNlIHRoZSBkaWFsb2cgYm94LCBzZWxlY3QgdGhlIGJlZ2lubmlu
ZyBjZWxsIG9uIHRoZSB3b3Jrc2hlZXQsIGFuZCB0aGVuIGNsaWNrIDxiIGNsYXNzPSJ1aSI+R
XhwYW5kIERpYWxvZzwvYj4gPGltZyBzcmM9Imh0dHA6Ly9vZmZpY2VpbWcudm8ubXNlY25kLm
5ldC9lbi11cy9maWxlcy84NTcvOTcwL1pBMDA2MDQ1ODEwLmdpZiIgYWx0PSJCdXR0b24gaW1
hZ2UiIHRpdGxlPSJCdXR0b24gaW1hZ2UiIGJvcmRlcj0iMCI+LjwvcD4NCjx1bCBjbGFzcz0i
Y250SW5kZW50NzIiIHR5cGU9ImRpc2MiPg0KICA8bGk+VG8gcGxhY2UgdGhlIGRhdGEgaW4gY
SBuZXcgd29ya3NoZWV0IHN0YXJ0aW5nIGF0IGNlbGwgQTEsIGNsaWNrIDxiIGNsYXNzPSJ1aS
I+TmV3IHdvcmtzaGVldDwvYj4uPC9saT4NCjwvdWw+DQo8b2wgY2xhc3M9ImNudEluZGVudDM
2IiB0eXBlPSIxIiBzdGFydD0iMTQiPg0KICA8bGk+T3B0aW9uYWxseSwgeW91IGNhbiBjaGFu
Z2UgdGhlIGNvbm5lY3Rpb24gcHJvcGVydGllcyAoYW5kIGFsc28gY2hhbmdlIHRoZSBjb25uZ
WN0aW9uIGZpbGUpIGJ5IGNsaWNraW5nIDxiIGNsYXNzPSJ1aSI+UHJvcGVydGllczwvYj4sIG
1ha2luZyB5b3VyIGNoYW5nZXMgaW4gdGhlIDxiIGNsYXNzPSJ1aSI+Q29ubmVjdGlvbiBQcm9
wZXJ0aWVzIDwvYj5kaWFsb2cgYm94LCBhbmQgdGhlbiBjbGlja2luZyA8YiBjbGFzcz0idWki
Pk9LPC9iPi48L2xpPg0KPC9vbD4NCjxwIGNsYXNzPSJjbnRJbmRlbnQzNiI+Rm9yIG1vcmUga
W5mb3JtYXRpb24sIHNlZSA8YSBocmVmPSJodHRwOi8vb2ZmaWNlLm1pY3Jvc29mdC5jb20vY2
xpZW50L2hlbHBwcmV2aWV3LmFzcHg/QXNzZXRJZD1IQTEwMTc1NDQzOTk5MCZsY2lkPTEwMzM
mTlM9RVhDRUwmVmVyc2lvbj0xMiZDVFQ9NSZvcmlnaW49SEEwMTAyMTc5NTYiPkNvbm5lY3Rp
b24gcHJvcGVydGllczwvYT4uPC9wPmQCBQ8WAh8AZWRkO5OFV1m1C4edw6wY/StxXktKN9s="
/>
</div>
</form><a name="top" class="cdTopLink"> </a><div
class="cdclv14Breadcrumbs"><a
href="http://office.microsoft.com/client/helphome.aspx?lcid=1033&amp;NS=E
XCEL&amp;Version=12">Excel 2007 Home</a> &gt; <a
href="http://office.microsoft.com/client/helpcategory.aspx?CategoryID=CL1
00729039990&amp;lcid=1033&amp;NS=EXCEL&amp;Version=12">Excel 2007 Help
and How-to</a> &gt; <a
href="http://office.microsoft.com/client/helpcategory.aspx?CategoryID=CH1
00648479990&amp;lcid=1033&amp;NS=EXCEL&amp;Version=12">Importing
data</a></div><div class="cdclv14Header cdclv14HeaderCenter"><div
class="cdclv14HeaderLogoSearch"><img
src="http://officeimg.vo.msecnd.net/_layouts/images/general/office_logo.j
pg?b=5540%2E4000" alt="Office.com" /><span
class="cdclv14HeaderSearch"><form method="get"
action="http://office.microsoft.com/client/searchresults.aspx"
id="frmSearch" class="cdfullsrchctrl" autocomplete="off">
      <div class="cdmostborders cdbottomborder">
            <input class="cdsrchtxt" name="qu" type="text" value=""
maxlength="128" id="qu" accesskey="3" title="Search for" /><button
type="submit" class="cdsrchbtn" value="" title="Click to search"
alt="Click to search"><img
src="http://officeimg.vo.msecnd.net/_layouts/images/general/search_button
.png?b=5540%2E4000" title="Click to search" alt="Click to search"
/></button><input name="lcid" value="1033" type="hidden" /><input
name="NS" value="EXCEL" type="hidden" /><input name="Version" value="12"
type="hidden" /><input name="sc" value="HP,HA,RZ,FX,XT,EM" type="hidden"
/><input name="from" value="inpage" type="hidden" /><span>Search
help</span>
      </div>
</form></span><img class="cdclv14HeaderSearchBing"
src="http://officeimg.vo.msecnd.net/_layouts/images/general/bing.png?b=55
40%2E4000" alt="Powered by Bing" /></div><div
class="cdclv14HeaderLinks">More on Office.com: <span><a
href="http://office.microsoft.com/en-
us/downloads/?CTT=205">downloads</a><span> | </span><a
href="http://office.microsoft.com/en-us/images/?CTT=205">images</a><span>
| </span><a href="http://office.microsoft.com/en-
us/templates/?CTT=205">templates</a></span></div></div><h1
class="cdclv14Title">Connect to (import) SQL Server data</h1><div
class="cdclvSection"><div id="m_article" class="cntArticleBody">
<p><a name="BMbacktotop" id="BMbacktotop"></a>You can use an Office Data
Connection (.odc) file to connect to a Microsoft SQL Server database from
a Microsoft Office Excel 2007 file. SQL Server is a full-featured,
relational database program that is designed for enterprise-wide data
solutions that require optimum performance, availability, scalability,
and security.</p>
<ol class="cntIndent36" type="1" start="1">
  <li>On the <b class="ui">Data</b> tab, in the <b class="ui">Get
External Data</b> group, click <b class="ui">From Other Sources</b>, and
then click <b class="ui">From SQL Server</b>.</li>
</ol>
<p class="cntIndent36"><img src="http://officeimg.vo.msecnd.net/en-
us/files/782/811/ZA010165405.gif" alt="Excel Ribbon image" title="Excel
Ribbon image" border="0"> </p>
<p class="cntIndent36">The Data Connection Wizard starts. This wizard has
three pages.</p>
<p class="cntIndent36"><b class="runinhead">Page 1: Connect to Database
Server</b>&nbsp;&nbsp;&nbsp; </p>
<ol class="cntIndent36" type="1" start="2">
  <li>In step 1, type the name of the SQL Server computer in the <b
class="ui">Server name</b> box.</li>
  <li>In step 2, under <b class="ui">Log on credentials</b>, do one of
the following:</li>
  <ul type="disc">
    <li>To use your current Microsoft Windows user name and password,
click <b class="ui">Use Windows Authentication</b>.</li>
    <li>To enter a database user name and password, click <b
class="ui">Use the following User Name and Password</b>, and then type
your user name and password in the corresponding <b class="ui">User
Name</b> and <b class="ui">Password</b> boxes.</li>
  </ul>
</ol>
<p class="cntIndent72"><b class="cntSecurity">Security</b>&nbsp;&nbsp;
Use strong passwords that combine uppercase and lowercase letters,
numbers, and symbols. Weak passwords don't mix these elements. Strong
password: Y6dh!et5. Weak password: House27. Passwords should be 8 or more
characters in length. A pass phrase that uses 14 or more characters is
better. For more information, see <a
href="http://office.microsoft.com/redir/XT011004519990.aspx?client=1&Ver=
12&NS=EXCEL&lc=en%2DUS&CTT=5&origin=HA010217956">Help protect your
personal information with strong passwords</a>.It is critical that you
remember your password. If you forget your password, Microsoft cannot
retrieve it. Store the passwords that you write down in a secure place
away from the information that they help protect.</p>
<p class="cntIndent36"><b class="runinhead">Page 2: Select Database and
Table</b>&nbsp;&nbsp;&nbsp; </p>
<ol class="cntIndent36" type="1" start="4">
  <li>Under <b class="ui">Select the database that contains the data you
want</b>, select a database. Under <b class="ui">Connect to a specific
table</b>, select a specific table or view.</li>
</ol>
<p class="cntIndent36">Alternatively, you can clear the <b
class="ui">Connect to a specific table</b> check box, so that other users
who use this connection file will be prompted for the list of tables and
views.</p>
<p class="cntIndent36"><b class="runinhead">Page 3: Save Data Connection
File and Finish</b>&nbsp;&nbsp;&nbsp; </p>
<ol class="cntIndent36" type="1" start="5">
  <li>Optionally, in the <b class="ui">File Name</b> box, revise the
suggested file name. Click <b class="ui">Browse</b> to change the default
file location (My Data Sources).</li>
  <li>Optionally, type a description of the file, a friendly name, and
common search words in the <b class="ui">Description</b>, <b
class="ui">Friendly Name</b>, and <b class="ui">Search Keywords</b>
boxes.</li>
  <li>To ensure that the connection file is always used when the data is
updated, click the <b class="ui">Always attempt to use this file to
refresh this data</b> check box. This check box ensures that updates to
the connection file will always be used by all workbooks that use that
connection file.</li>
  <li>To specify how the external data source of a PivotTable report is
accessed if the workbook is saved to Excel Services and is opened by
using Excel Services, click <b class="ui">Authentication Settings</b>,
and then select one of the following options to log on to the data
source: </li>
  <ul type="disc">
    <li><b class="runinhead"><b class="ui">Windows
Authentication</b></b>&nbsp;&nbsp;&nbsp; Select this option to use the
Windows user name and password of the current user. This is the most
secure method, but it can affect performance when many users are
connected to the server.</li>
    <li><b class="runinhead"><b
class="ui">SSO</b></b>&nbsp;&nbsp;&nbsp; Select this option to use Single
Sign On (SSO), and then enter the appropriate identification string in
the <b class="ui">SSO ID</b> box. A site administrator can configure a
Windows SharePoint Services site to use a Single Sign On database in
which a user name and password can be stored. This method can be the most
efficient when many users are connected to the server.</li>
    <li><b class="runinhead"><b
class="ui">None</b></b>&nbsp;&nbsp;&nbsp; Select this option to save the
user name and password in the connection file. </li>
  </ul>
</ol>
<p class="cntIndent72"><b
class="cntSecurity">Security</b>&nbsp;&nbsp;Avoid saving logon
information when connecting to data sources. This information may be
stored as plain text, and a malicious user could access the information
to compromise the security of the data source.</p>
<ol class="cntIndent36" type="1" start="9">
  <li>
    <p><b class="cntnote">&nbsp;Note&nbsp;</b>&nbsp;&nbsp;The
authentication setting is used only by Excel Services, and not by
Excel.</p>
  </li>
  <li>Click <b class="ui">OK</b>.</li>
  <li>Click <b class="ui">Finish</b> to close the Data Connection
Wizard.</li>
</ol>
<p class="cntIndent36">The <b class="ui">Import Data</b> dialog box is
displayed.</p>
<ol class="cntIndent36" type="1" start="12">
  <li>Under <b class="ui">Select how you want to view this data in your
workbook</b>, do one of the following:</li>
  <ul type="disc">
    <li>To create an Excel table, click <b class="ui">Table</b> (this is
the default).</li>
    <li>To create a PivotTable report, click <b class="ui">PivotTable
Report</b>.</li>
    <li>To create a PivotChart and PivotTable report, click <b
class="ui">PivotChart and PivotTable Report</b>.</li>
  </ul>
</ol>
<p class="cntIndent36"><b
class="cntnote">&nbsp;Note&nbsp;</b>&nbsp;&nbsp;The <b class="ui">Only
Create Connection</b> option is available only for an OLAP database.</p>
<ol class="cntIndent36" type="1" start="13">
  <li>Under <b class="ui">Where do you want to put the data?</b>, do one
of the following:</li>
  <ul type="disc">
    <li>To place the data in an existing worksheet, select <b
class="ui">Existing worksheet</b>, and then type the name of the first
cell in the range of cells where you want to locate the data.</li>
  </ul>
</ol>
<p class="cntIndent72">Alternatively, click <b class="ui">Collapse
Dialog</b> <img src="http://officeimg.vo.msecnd.net/en-
us/files/288/489/ZA006044489.gif" alt="Button image" title="Button image"
border="0"> to temporarily collapse the dialog box, select the beginning
cell on the worksheet, and then click <b class="ui">Expand Dialog</b>
<img src="http://officeimg.vo.msecnd.net/en-
us/files/857/970/ZA006045810.gif" alt="Button image" title="Button image"
border="0">.</p>
<ul class="cntIndent72" type="disc">
  <li>To place the data in a new worksheet starting at cell A1, click <b
class="ui">New worksheet</b>.</li>
</ul>
<ol class="cntIndent36" type="1" start="14">
  <li>Optionally, you can change the connection properties (and also
change the connection file) by clicking <b class="ui">Properties</b>,
making your changes in the <b class="ui">Connection Properties </b>dialog
box, and then clicking <b class="ui">OK</b>.</li>
</ol>
<p class="cntIndent36">For more information, see <a
href="http://office.microsoft.com/client/helppreview.aspx?AssetId=HA10175
4439990&lcid=1033&NS=EXCEL&Version=12&CTT=5&origin=HA010217956">Connectio
n properties</a>.</p></div><div class="cdclvSeeAlsoWrap"><div
class="cdSeeAlso"><h4>See Also</h4><ul><li><a
href="http://office.microsoft.com/redir/XT103694109990.aspx?client=1&amp;
Ver=12&amp;NS=EXCEL&amp;lc=en%2DUS&amp;CTT=3"
name="{&quot;a&quot;:&quot;XT010369410&quot;,&quot;at&quot;:&quot;Busines
s Intelligence with Excel and
SharePoint&quot;,&quot;d&quot;:null,&quot;p&quot;:&quot;Provided by
Microsoft&quot;,&quot;t&quot;:&quot;Link&quot;,&quot;u&quot;:&quot;&quot;
,&quot;uh&quot;:&quot;9B09AAE24109EE6A61057FB8B944CE61&quot;}">Business
Intelligence with Excel and SharePoint</a></li><li><a
href="http://office.microsoft.com/client/helppreview.aspx?AssetId=HP10201
7109990&amp;lcid=1033&amp;NS=EXCEL&amp;Version=12&amp;CTT=3"
name="{&quot;a&quot;:&quot;HP010201710&quot;,&quot;at&quot;:null,&quot;d&
quot;:&quot;Show All Hide All There is a world of data outside of your
Microsoft Office Excel workbook that you can use inside of your workbook.
But how do you find it,...&quot;,&quot;p&quot;:&quot;Provided by
Microsoft&quot;,&quot;t&quot;:&quot;Article&quot;,&quot;u&quot;:null,&quo
t;uh&quot;:null}">Overview of connecting (importing)
data</a></li></ul></div></div><div class="cdclvFeedback"><div
id="feedbackDiv"></div><div class="cdclr"></div></div><div
id="m_editorial" class="cdclvEditorialWrap"></div></div><noscript><img
id="DCSIMG"
src="http://m.webtrends.com/dcs0junic89k7m2gzez6wz0k8_7v8n/njs.gif?dcsuri
=/nojavascript&amp;WT.js=No" alt="" class="cdMetricsImage"
/></noscript><!--TS00c:634277629957902229--><!--TS09c:634277629958058235-
-><!--TS0Ac:634277629958838265--><!--TS05c:634277629958838265--><!--
TS06c:634277629959306283--><!--TS11c:634277629959462289--><!--
TS12c:634277629959462289--><!--TS0Fc:634277629959462289--><!--
TS10c:634277629959462289--><!--TS03c:634277629959462289--><!--
TS04c:634277629959462289--><!--TS03c:634277629959462289--><!--
TS04c:634277629959462289--><!--TS11c:634277629959462289--><!--
TS12c:634277629959462289--><!--TSFFc:634277629959462289--><!--
TSFF:634277629959462289--></body></html>

				
DOCUMENT INFO
Description: ANY STATE COURT FORMS, ANY LEGAL CATEGORY, ANY CONTRACT, CORPORATE, BUSINESS, TRIAL, COURT DOCUMENTS NEEDS, ALL LAWYER MADE FORMS, ALL LAW FIRMS PREPARED FORMS, CHEAPEST SITE ON THE WEB, ALL PACKAGES ONLY $19.99, ALL SINGLE FORMS ONLY $1.99,