<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Calibri Light";
panose-1:2 15 3 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
em
{mso-style-name:"Emphasis\,Emphasis slanted";
mso-style-priority:20;
font-style:normal;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.CodeChar
{mso-style-name:"Code Char";
mso-style-link:"c\,Code\,C";
font-family:Consolas;
mso-fareast-language:EN-CA;}
p.c, li.c, div.c
{mso-style-name:"c\,Code\,C";
mso-style-link:"Code Char";
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:.2in;
mso-add-space:auto;
line-height:115%;
font-size:11.0pt;
font-family:Consolas;
mso-fareast-language:EN-CA;}
p.cCxSpFirst, li.cCxSpFirst, div.cCxSpFirst
{mso-style-name:"c\,Code\,CCxSpFirst";
mso-style-link:"Code Char";
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.2in;
margin-bottom:.0001pt;
mso-add-space:auto;
line-height:115%;
font-size:11.0pt;
font-family:Consolas;
mso-fareast-language:EN-CA;}
p.cCxSpMiddle, li.cCxSpMiddle, div.cCxSpMiddle
{mso-style-name:"c\,Code\,CCxSpMiddle";
mso-style-link:"Code Char";
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.2in;
margin-bottom:.0001pt;
mso-add-space:auto;
line-height:115%;
font-size:11.0pt;
font-family:Consolas;
mso-fareast-language:EN-CA;}
p.cCxSpLast, li.cCxSpLast, div.cCxSpLast
{mso-style-name:"c\,Code\,CCxSpLast";
mso-style-link:"Code Char";
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:.2in;
mso-add-space:auto;
line-height:115%;
font-size:11.0pt;
font-family:Consolas;
mso-fareast-language:EN-CA;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.Non-normativeBracket
{mso-style-name:"Non-normative Bracket\,Example start\/end";
font-style:italic;}
span.Attribute
{mso-style-name:Attribute;
font-family:"Calibri Light",sans-serif;}
span.Type
{mso-style-name:"Type\,XSD Base Type";
mso-style-priority:99;
font-family:"Calibri Light",sans-serif;}
span.Attributevalue
{mso-style-name:"Attribute value";
font-family:Consolas;}
span.EmailStyle27
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> Aarti Nankani [mailto:anankani@microsoft.com] <br><b>Sent:</b> Tuesday, April 11, 2017 2:18 PM<br><b>To:</b> Rex Jaeschke <rex@RexJaeschke.com><br><b>Subject:</b> DR 14-0013<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi Rex,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have updates from the Excel team for discussing tomorrow.<o:p></o:p></p><p class=MsoNormal><u><span style='color:#0563C1'><o:p><span style='text-decoration:none'> </span></o:p></span></u></p><p class=MsoNormal><u><span style='color:#0563C1'><a href="https://onedrive.live.com/view.aspx/Public%20Documents/2014/DR-14-0013.docx?cid=c8ba0861dc5e4adc">DR 14-0013 - SML: definedName attribute localSheetId</a></span></u><o:p></o:p></p><p style='mso-margin-top-alt:5.0pt;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt'>Here’s Excel’s recommendation for this. It’s similar to Rex’s most recent version with changes indicating that localSheetId is a 0-based index into the elements within CT_Sheets and has no connection to the sheetId attribute on the CT_Sheet. Highlighting indicated changes:<o:p></o:p></p><p style='mso-margin-top-alt:5.0pt;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt'><o:p> </o:p></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;border-collapse:collapse'><thead><tr style='page-break-inside:avoid'><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;background:silver;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal align=center style='text-align:center'><b>Attributes<o:p></o:p></b></p></td><td width="80%" valign=top style='width:80.0%;border:solid black 1.0pt;border-left:none;background:silver;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal align=center style='text-align:center'><b>Description<o:p></o:p></b></p></td></tr></thead><tr style='page-break-inside:avoid'><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute>localSheetId</span> (Local Name Sheet Id)<o:p></o:p></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal>Specifies<u><span style='color:blue'> that this defined name is a sheet-scoped reference, and specifies</span></u> <s><span style='color:red'>the </span></s><u><span style='color:blue'>a parent </span></u>sheet<s><span style='color:red'> index in this workbook where data from an external reference is displayed</span></s>.<u><span style='color:blue'> <span style='background:yellow;mso-highlight:yellow'>The localSheetId specifies the 0-based index of the parent sheet within the CT_Sheets element. The combination of </span></span></u><span class=Attribute><u><span style='color:blue;background:yellow;mso-highlight:yellow'>localSheetId</span></u></span><u><span style='color:blue;background:yellow;mso-highlight:yellow'> and </span></u><span class=Attribute><u><span style='color:blue;background:yellow;mso-highlight:yellow'>name</span></u></span><u><span style='color:blue;background:yellow;mso-highlight:yellow'> attributes shall be unique among all defined names.</span></u><o:p></o:p></p><p class=MsoNormal>[<span class=Non-normativeBracket>Example</span>: <s><span style='color:red'>In the following example, the</span></s><u><span style='color:blue'>A</span></u> defined name<u><span style='color:blue'>, </span><s><span style='color:red'>local </span></s><span style='color:blue'>scoped to the sheet </span><s><span style='color:red'>with </span></s></u><span class=Attribute><s><u><span style='color:red'>sheetIdID 1</span></u></s></span><s><u><span style='color:red'> equal to </span></u></s><span class=Attributevalue><s><u><span style='font-size:10.0pt;color:red'>2</span></u></s></span><u><span style='color:blue'>upon which it resides, with its accompanying sheet definition</span><s><span style='color:red'>,</span></s></u><s><span style='color:red'> refers to a range whose data source is an external database called “Northwind_Database”</span></s>:<o:p></o:p></p><p class=c style='margin-bottom:0in;margin-bottom:.0001pt;mso-add-space:auto;line-height:normal'><definedName name="Northwind_Data<s><span style='color:red'>base</span></s>"<br> localSheetId="2">Sheet5!$A$1:$T$47</definedName><u><span style='color:blue'><o:p></o:p></span></u></p><p class=MsoNormal><u><span lang=EN-CA style='color:blue'>…<o:p></o:p></span></u></p><p class=cCxSpFirst style='margin:0in;margin-bottom:.0001pt;mso-add-space:auto;line-height:normal'><u><span lang=EN-GB style='font-size:12.0pt;font-family:"Courier New";color:blue'> </span><span style='color:blue'><sheets><o:p></o:p></span></u></p><p class=cCxSpMiddle style='margin:0in;margin-bottom:.0001pt;mso-add-space:auto;line-height:normal'><u><span style='color:blue'> <span style='background:yellow;mso-highlight:yellow'><sheet name="Sheet1" sheetId="2" r:id="rId1"/><o:p></o:p></span></span></u></p><p class=cCxSpMiddle style='margin:0in;margin-bottom:.0001pt;mso-add-space:auto;line-height:normal'><u><span style='color:blue;background:yellow;mso-highlight:yellow'> <sheet name="Sheet4" sheetId="0" r:id="rId2"/><o:p></o:p></span></u></p><p class=cCxSpMiddle style='margin:0in;margin-bottom:.0001pt;mso-add-space:auto;line-height:normal'><u><span style='color:blue;background:yellow;mso-highlight:yellow'> <sheet name="Sheet5" sheetId="1" r:id="rId3"/></span><span style='color:blue'><o:p></o:p></span></u></p><p class=cCxSpLast style='margin:0in;margin-bottom:.0001pt;mso-add-space:auto;line-height:normal'><u><span style='color:blue'> </sheets><o:p></o:p></span></u></p><p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p><p class=MsoNormal><span class=Non-normativeBracket>end example</span>]<u><span style='color:blue'><o:p></o:p></span></u></p><p class=MsoNormal><u><span style='color:blue'>[</span></u><em><i><span style='color:blue'>Note</span></i></em><u><span style='color:blue'>: Although not a typical use case, a name scoped to one particular sheet may refer to a cell reference in another. <i>End note</i>]<o:p></o:p></span></u></p><p class=MsoNormal><u><span style='color:blue;background:#FFCCCC'>For further information on local defined names, see </span><span style='color:blue'>§<span style='background:#FFCCCC'>L.2.2.11.</span></span></u><span style='background:#FFCCCC'><o:p></o:p></span></p><p class=MsoNormal>The possible values for this attribute are defined by the W3C XML Schema <span class=Type>unsignedInt</span> datatype.<o:p></o:p></p></td></tr></table><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Aarti<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>