Home

Hyperlinks - how much do they change the size of a file

%3CLINGO-SUB%20id%3D%22lingo-sub-175850%22%20slang%3D%22en-US%22%3EHyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175850%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20new%20to%20the%20community%20but%20have%20been%20working%20with%20Excel%20for%20a%20long%20time.%26nbsp%3B%20The%20one%20thing%20that%20I%20am%20not%20sure%20of%20is%20if%20I%20am%20using%20hyperlinks%20just%20how%20much%20they%20add%20to%20the%20size%20of%20the%20file.%26nbsp%3B%20I%20have%20an%20already%20very%20large%20file%20and%20we%20just%20started%20hyperlinking%20in%20it%20this%20year%20so%20that%20is%20of%20concern%20as%20we%20already%20have%20issues%20due%20to%20the%20size%20and%20number%20of%20formula%20that%20we%20have.%26nbsp%3B%20Would%20appreciate%20any%20help.%26nbsp%3B%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-175850%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20File%20Size%20with%20Hyperlinks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-177243%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-177243%22%20slang%3D%22en-US%22%3EHi%20Julie%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20suggest%20that%20if%20hyperlinking%20adds%20benefit%20to%20your%20operations%20then%20it%20may%20outweight%20any%20negatives%20from%20whatever%20file%20size%20increases%20you%20experience.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20wishes.%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3EDamien%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-177233%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-177233%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jamil%2C%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3EIn%20some%20cases%2C%20the%20size%20will%20vary%20slightly%20and%20this%20difference%20will%20not%20have%20a%20significant%20impact%20even%20if%20the%20number%20of%20links%20increases.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3ET%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%3Ehis%20is%20%3CSPAN%20class%3D%22short_text%22%3Ein%20case%20if%20the%20link%20is%20external!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EPlease%20see%20the%20attached%20files.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EIt%20may%20also%20be%20different%20if%20these%20links%20are%20duplicate%20and%20external%20as%20in%20the%20case%20I%20mentioned%20earlier%2C%20and%20how%20the%20links%20in%20the%20HYPERLINK%20function%20have%20increased%20the%20size%20of%20the%20workbook%20by%20about%2030%20KB.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThis%20may%20be%20thanks%20to%20the%20%3CSTRONG%3EsharedStrings.xml%3C%2FSTRONG%3Ewhich%20is%20has%20the%20responsibility%20of%20reducing%20the%20size%20of%20the%20hyperlinks%20strings.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22short_text%22%3ENot%20always%20the%20hyperlinks%20in%20HYPERLINK%20function%20are%26nbsp%3Blower%20in%20size!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-177041%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-177041%22%20slang%3D%22en-US%22%3EHi%20Julie%2C%3CBR%20%2F%3E%3CBR%20%2F%3EHyperlinks%20aren't%20any%20different%20in%20size%20to%20the%20texts%20that%20created%20them%20and%20although%20it%20will%20increase%20the%20file%20size%20by%201%20or%202%20times%20compared%20to%20its%20visible%20text.%20So%2C%20I%20wouldn't%20worry%20about%20the%20file%20size%20increased%20if%20it%20is%20increases%20only%20using%20%3DHyperlink(%20%2C%20)%20function.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20some%20folks%20are%20usually%20mistaken%20between%20pasted%20hyperlinks%20and%20hyperlinks%20using%20Hyperlink%20function.%20If%20user%20has%20numerous%20hyperlinks%20using%20pasted%20links%20then%20that%20for%20sure%20increases%20the%20size%20of%20workbook%20significantly%20and%20plz%20allow%20me%20to%20demonstrate%20here%3A%3CBR%20%2F%3E%3CBR%20%2F%3EOpen%20an%20empty%20Excel%20file%20and%20enter%20a%20text%20e.g.%20Myfolder%20there%20and%20then%20right%20click%20and%20click%20hyperlink%20and%20then%20select%20a%20folder%20as%20the%20address%20of%20the%20hyperlink%20C%3A%5CUsers%5CJulie%5CDownloads%5C%20and%20then%20save%20the%20workbook%20somewhere%20%3CBR%20%2F%3Ethen%20open%20a%20new%20workbook%20and%20type%20this%20somewhere%20%3DHyperlink(%22C%3A%5CUsers%5CJulie%5CDownloads%5C%22%2C%22Myfolder%22)%20and%20save%20in%20the%20same%20folder%20as%20the%20first%20workbook.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20check%20the%20size%20of%20the%20above%20two%20workbooks%2C%20you%20will%20see%20that%20the%20second%20workbook%20is%20smaller%20in%20size%20than%20the%20first%20one.%20This%20was%20just%20one%20hyperlink%2C%20if%20you%20have%20many%20hyperlinks%20the%20difference%20of%20size%20will%20be%20significant.%3CBR%20%2F%3E%3CBR%20%2F%3EWhenever%20linking%20cells%20either%20with%20a%20folder%20or%20file%2C%20instead%20of%20copy%20and%20Paste%20(control%20%2B%20v%20)%20use%20paste-values%20only%20and%20create%20link%20using%20hyperlink()%20function%20and%20this%20way%20it%20will%20open%20quickly%20and%20will%20not%20increase%20file%20size.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-177000%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-177000%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%20I%20know%20where%20the%20file%20sheet1.xml%20came%20from!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20not%20an%20XML%20language%20expert%20and%20how%20it%20is%20used%20in%20Excel%20files%2C%20but%20after%20reading%20this%20%3CA%20href%3D%22http%3A%2F%2Fprofessor-excel.com%2Fxml-zip-excel-file-structure%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Earticle%3C%2FA%3E%2C%20I%20admit%20that%20the%20code%20I%20mentioned%20before%20doesn't%20represent%20the%20actual%20structure%20of%20the%20Excel%20file.%3C%2FP%3E%0A%3CP%3EWhat%20described%20in%20this%20article%20is%20actually%20the%20structure%20of%20the%20Excel%20file%20and%20what%20happened%20behind%20the%20scenes!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20however%2C%20the%20subject%20is%20not%20as%20you%20think!%3C%2FP%3E%0A%3CP%3EWhat%20I%20did%20in%20the%20Before%20file%20was%20holding%20the%20fill%20handle%20in%20the%20first%20cell%20and%20then%20dragging%20it%20until%20I%20reached%20the%20cell%20A10000.%3CBR%20%2F%3EThis%20is%20why%20the%20definition%20is%20uniform%20across%20the%20range.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EBut%20this%20definition%20may%20differ%20depending%20on%20how%20you%20create%20the%20links.%3CBR%20%2F%3EIf%20you%20enter%20the%20links%20in%20the%20cells%20(cell%20after%20cell)%20without%20using%20the%20fill%20handle%2C%20the%20definition%20will%20appear%20as%20follows%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F31120iEA110DF20517638F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Hyperlinks%20XML%20Code.png%22%20title%3D%22Hyperlinks%20XML%20Code.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ENOTE%3A%20You%20will%20find%20this%20code%20spreads%20horizontally%20in%20the%20single%20line.%20(For%20clarification%2C%20I've%20moved%20each%20hyperlink%20in%20a%20separate%20line)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20will%20notice%20that%20the%20link%20is%20the%20same%20in%20the%20workbook%2C%20but%20after%20you%20unzip%20it%20you%20will%20find%20it%20defined%2015%20times%2C%20and%20it's%20not%20visible%20here%2C%20it%20appears%20to%20be%20encrypted%20on%20every%20line%2C%20and%20has%20a%20unique%20ID!%3CBR%20%2F%3EThis%20is%20because%20I%20entered%20the%20links%20manually%20without%20using%20the%20fill%20handle!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20the%20interesting%20fact%20is%20that%20each%20link%20in%20the%20range%20A1%3AA15%20is%20an%20instance%20of%20the%20parent%20link%20which%20is%20located%20in%20a%20separate%20file%20called%3CSTRONG%3EsharedStrings.xml%3C%2FSTRONG%3Eand%20the%20link%20is%20counted%20%3CSTRONG%3E15%20times%3C%2FSTRONG%3Ein%20this%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F31118iAFF4E1FC4515F0F0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22sharedStrings.png%22%20title%3D%22sharedStrings.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20do%20you%20think%20of%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESome%20people%20may%20think%20that%20this%20subject%20has%20taken%20up%20more%20%3CSPAN%3Ediscussion%3C%2FSPAN%3Ethan%20it%20deserves!%3CBR%20%2F%3EIn%20fact%2C%20it%20is%20fun%20to%20dive%20into%20the%20Excel%20to%20this%20extent%20and%20learn%20all%20these%20stuff!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%3CBR%20%2F%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-176683%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-176683%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Haytham%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20looks%20strange%20for%20me.%20If%20unzip%20your%20Before%20file%20its%20structure%20as%20in%20attaches%20before.txt%20file.%20Biggest%20file%20here%20which%20describes%20the%20sheet%20is%20sheet1.xml.%20If%20open%20it%2C%20all%20what%20defines%20the%20content%20with%20hyperlinks%20is%20at%20very%20bottom%20of%20the%20file%3C%2FP%3E%0A%3CPRE%3E%26lt%3Bhyperlinks%26gt%3B%26lt%3Bhyperlink%20ref%3D%22A1%22%20r%3Aid%3D%22rId1%22%20xr%3Auid%3D%22%7BB7B34BD7-8C51-483C-B6EE-3A89EFD0E69A%7D%22%2F%26gt%3B%0A%26lt%3Bhyperlink%20ref%3D%22A2%3AA10000%22%20r%3Aid%3D%22rId2%22%20display%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xr%3Auid%3D%22%7B8583AAC1-002D-49A8-B3C5-A3CEE3F36A01%7D%22%2F%26gt%3B%26lt%3B%2Fhyperlinks%26gt%3B%0A%3C%2FPRE%3E%0A%3CP%3EValue%20of%20each%20row%20is%20the%20reference%20on%20resource%20defined%20in%20tiny%20resource%20file%20(between%20%3CV%3E%20and%20%3C%2FV%3E)%20and%20looks%20like%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%26lt%3Brow%20r%3D%2210000%22%20spans%3D%221%3A1%22%20x14ac%3AdyDescent%3D%220.35%22%26gt%3B%26lt%3Bc%20r%3D%22A10000%22%20s%3D%221%22%20t%3D%22s%22%26gt%3B%26lt%3Bv%26gt%3B0%26lt%3B%2Fv%26gt%3B%26lt%3B%2Fc%26gt%3B%26lt%3B%2Frow%26gt%3B%0A%3C%2FPRE%3E%0A%3CP%3EFile%20After%20is%20exactly%20the%20same%20except%20small%20block%20with%20hyperlinks%20at%20the%20bottom%20of%20the%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20compare%2C%20I%20generated%20another%20file%20with%203%20different%20hyperlinks%20repeat%20in%2010%20cells%20each.%20Entire%20block%20which%20describes%20them%20is%3C%2FP%3E%0A%3CPRE%3E%26lt%3Bhyperlinks%26gt%3B%26lt%3Bhyperlink%20ref%3D%22A1%22%20r%3Aid%3D%22rId1%22%20xr%3Auid%3D%22%7B65A09A39-A823-4B29-831D-35135F8B94C8%7D%22%2F%26gt%3B%0A%26lt%3Bhyperlink%20ref%3D%22A2%3AA10%22%20r%3Aid%3D%22rId2%22%20display%3D%22http%3A%2F%2Ftechcommunity.microsoft.com%22%20xr%3Auid%3D%22%7B445541D1-C4DC-4651-A162-47AE45477BCF%7D%22%2F%26gt%3B%0A%26lt%3Bhyperlink%20ref%3D%22A11%22%20r%3Aid%3D%22rId3%22%20xr%3Auid%3D%22%7BED775096-F6A1-4801-9196-FE06349F96F8%7D%22%2F%26gt%3B%0A%26lt%3Bhyperlink%20ref%3D%22A12%3AA20%22%20r%3Aid%3D%22rId4%22%20display%3D%22www.microsoft.com%22%20xr%3Auid%3D%22%7BE07D5B65-8D06-4F4F-B908-19ADD0C32BEA%7D%22%2F%26gt%3B%0A%26lt%3Bhyperlink%20ref%3D%22A21%22%20r%3Aid%3D%22rId5%22%20xr%3Auid%3D%22%7BD978AABC-E1CD-4864-811E-4A8DC1F21E56%7D%22%2F%26gt%3B%26lt%3Bhyperlink%20ref%3D%22A22%3AA30%22%20r%3Aid%3D%22rId6%22%20display%3D%22https%3A%2F%2Fvivaldi.com%2F%22%20xr%3Auid%3D%22%7BA75F23EE-CA26-477D-839C-A9B8857EE103%7D%22%2F%26gt%3B%26lt%3B%2Fhyperlinks%26gt%3B%3C%2FPRE%3E%0A%3CP%3EThis%20block%20is%203%20times%20bigger%20since%20we%20have%203%20different%20hyperlinks%20instead%20of%20only%20one.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOops%2C%20txt%20files%20are%20not%20allowed%20to%20attach.%20Zipped.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-176196%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-176196%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22g-unit%22%20id%3D%22gt-res-c%22%3E%0A%3CDIV%20id%3D%22gt-res-p%22%3E%0A%3CDIV%20id%3D%22gt-res-data%22%3E%0A%3CDIV%20id%3D%22gt-res-wrap%22%3E%0A%3CDIV%20id%3D%22gt-res-content%22%3E%0A%3CDIV%20class%3D%22trans-verified-button-large%22%20dir%3D%22ltr%22%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3ESergei%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%20class%3D%22trans-verified-button-large%22%20dir%3D%22ltr%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20class%3D%22trans-verified-button-large%22%20id%3D%22gt-res-dir-ctr%22%20dir%3D%22ltr%22%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3EYour%20last%20reply%20is%20unclear%20or%20vague!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EAgain%2C%20the%20code%20above%20is%20part%20of%20the%20structure%20of%20the%20workbook%20%22before%22%20that%20I%20previously%20attached!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22g-unit%22%20id%3D%22gt-res-c%22%3E%0A%3CDIV%20id%3D%22gt-res-p%22%3E%0A%3CDIV%20id%3D%22gt-res-data%22%3E%0A%3CDIV%20id%3D%22gt-res-wrap%22%3E%0A%3CDIV%20id%3D%22gt-res-content%22%3E%0A%3CDIV%20class%3D%22trans-verified-button-large%22%20id%3D%22gt-res-dir-ctr%22%20dir%3D%22ltr%22%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3EIt's%20what's%20going%20on%20behind%20the%20scenes!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EYou%20said%20before%3A%20%22If%20you%20have%20only%20one%20URL%2C%20doesn't%20matter%20how%20many%20time%20you%20use%20it%2C%20it'll%20be%20only%20one%20description.%20If%2010%20thousand%20different%20URL%3As%26nbsp%3B-%20ten%20thousand%20such%20descriptions%20and%20ID%3As.%22%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%20code%20proved%20that%20this%20is%20wrong!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI%20will%20not%20discuss%20more%20because%20it%20has%20become%20useless.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-176102%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-176102%22%20slang%3D%22en-US%22%3E%3CP%3EHaytham%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20which%20exactly%20XML%20file%20is%20the%20above%20code%3F%20The%20biggest%20one%20is%20sheet1.xml%20and%20it%20looks%20differently.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-176040%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-176040%22%20slang%3D%22en-US%22%3E%3CP%3ESergei%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20note%20that%20the%20Excel%20file%20in%20XLSX%26nbsp%3Bextension%20is%20an%20XML-based%20format.%3C%2FP%3E%0A%3CP%3EXML%20is%20a%20markup%20language%20and%20it's%20responsible%20for%20the%20Excel%20file%20structure.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20code%20that%20you%20saw%20before%20is%20really%20what%20is%20going%20on%20inside%20the%20Excel%20file!%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EEven%20with%20other%20extensions%2C%20you'll%20see%20the%20same%20thing%20but%20in%20a%20different%20syntax!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-176018%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-176018%22%20slang%3D%22en-US%22%3E%3CP%3EI%20mean%20not%20conversion%20to%20XML%20but%20internal%20Excel%20file%20structure%20if%20you%20unzip%26nbsp%3Bit.%20Here%20each%20resource%20(URL%20text)%20is%20defined%20only%20once%20and%20cell%20value%20is%20referencing%20on%20it.%20Text%20of%20the%20URL%20is%20not%20repeated%20for%20each%20cell%20definition.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-176011%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-176011%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20XML%20each%20cell%20has%20an%20independent%20tag%20since%20it%20has%20an%20independent%20entity!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20converted%20the%20workbook%20to%20an%20XML%20file%2C%20and%20get%20access%20to%20its%20source%20code%2C%20and%20the%20below%20code%20is%20a%20part%20of%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EPlease%20take%20a%20deep%20look%20at%20this%20code%20and%20you'll%20see%20how%20each%20cell%20has%20an%20independent%20tag%20that%20includes%20all%20its%20contents!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EYou%20will%20notice%20how%26nbsp%3B%3CSTRONG%3Ehref%3D%22%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2F%3C%2FA%3E%22%3C%2FSTRONG%3Ewill%20repeat%20in%20each%20tag.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%26lt%3Btable%3Atable%20table%3Aname%3D%22Sheet1%22%20table%3Astyle-name%3D%22ta1%22%26gt%3B%0A%20%20%20%20%26lt%3Boffice%3Aforms%20form%3Aautomatic-focus%3D%22false%22%20form%3Aapply-design-mode%3D%22false%22%2F%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-column%20table%3Astyle-name%3D%22co1%22%20table%3Adefault-cell-style-name%3D%22Default%22%2F%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-column%20table%3Astyle-name%3D%22co2%22%20table%3Anumber-columns-repeated%3D%221023%22%20table%3Adefault-cell-style-name%3D%22Default%22%2F%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%0A%20%20%20%20%26lt%3B%2Ftable%3Atable-row%26gt%3B%0A%20%20%20%20%26lt%3Btable%3Atable-row%20table%3Astyle-name%3D%22ro1%22%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Astyle-name%3D%22ce1%22%20office%3Avalue-type%3D%22string%22%20calcext%3Avalue-type%3D%22string%22%26gt%3B%26lt%3Btext%3Ap%26gt%3B%26lt%3Btext%3Aa%20xlink%3Ahref%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20xlink%3Atype%3D%22simple%22%26gt%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2F%26lt%3B%2Ftext%3Aa%26gt%3B%26lt%3B%2Ftext%3Ap%26gt%3B%0A%20%20%20%20%20%26lt%3B%2Ftable%3Atable-cell%26gt%3B%0A%20%20%20%20%20%26lt%3Btable%3Atable-cell%20table%3Anumber-columns-repeated%3D%221023%22%2F%26gt%3B%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175960%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175960%22%20slang%3D%22en-US%22%3E%3CP%3EHaytham%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20each%20unique%20URL%20into%20XML%20of%20Excel%20file%20will%20be%20added%20XML%20description%20of%20such%20with%20reference%20on%20ID%20for%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20only%20one%20URL%2C%20doesn't%20matter%20how%20many%20time%20you%20use%20it%2C%20it'll%20be%20only%20one%20description.%20If%2010%20thousand%20different%20URL%3As%26nbsp%3B-%20ten%20thousand%20such%20descriptions%20and%20ID%3As.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnyway%2C%20that's%20not%20something%20what%20increases%20the%20size%20significantly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175956%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175956%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20this%20good%20point!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EBut%20each%20hyperlink%20has%20an%20independent%20entity%20in%20an%20independent%20cell%20even%20if%20it%20is%20the%20same!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%20process%20of%20directing%20you%20to%20the%20link%20address%20in%20the%20browser%20is%20only%20a%20functionality%20and%20does%20not%20affect%20the%20size.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20fact%2C%20w%3CSPAN%3Ehen%20you%20remove%20the%20hyperlinks%20you%20actually%20remove%20the%20URL%20formats%20which%20is%20blue%20font%20color%20and%20underlined%20text!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22short_text%22%3EConclusion%3CBR%20%2F%3EThe%20difference%20between%20the%20plain%20text%20and%20the%20hyperlink%3C%2FSPAN%3Eis%20just%20the%20format!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%20specific%20format%20of%20the%20%3CSPAN%20class%3D%22short_text%22%3Ehyperlink%20is%20associated%20with%20an%20event%20to%20directing%20you%26nbsp%3Bthe%20to%20link%20address%20in%20the%20browser%2C%20and%20this%20is%20just%20a%20functionality%20and%20does%20not%20affect%20the%20size.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22short_text%22%3EWith%20regards%20to%20HYPERLINK%20function%2C%20it%20increases%20the%20size%20by%20~30%20KB%20as%20the%20attached%20file%2C%20and%20this%20is%20not%20a%20big%20difference!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175930%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175930%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Haytham%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20if%20you%20have%20exactly%20the%20same%20hyperlink%20repeated%2010%20thousand%20times.%20Is%20it%20hyperlink%20or%20not%20-%20adds%20practically%20nothing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20all%20hyperlinks%20are%20different%20I%20guess%20it'll%20be%20added%20about%20few%20hundreds%20bytes%20on%20the%20top%20for%20each%20hyperlink.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20another%20story%20if%20use%20HYPERLINK()%20function%2C%20it%20shall%20add%20less.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20any%20case%20that's%20not%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175926%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175926%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIf%20so%2C%20I%20would%20recommend%20you%20to%20send%20my%20previous%20reply%20to%20them%20via%20email!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F30943i04B3F297BF1A3043%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Reply.png%22%20title%3D%22Reply.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGood%20luck%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175921%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175921%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you.%26nbsp%3B%20I%20did%20the%20test%20too%2C%20but%20I%20think%20there%20were%20skeptics%20working%20with%20me%20and%20wanted%20a%20second%20opinion.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175916%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20-%20how%20much%20do%20they%20change%20the%20size%20of%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175916%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Julie%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDon't%20worry%20about%20it!%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI've%20done%20a%20simple%20test%20and%20you%20may%20be%20surprised%20when%20you%20know%20its%20result!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI%20created%20a%20workbook%20and%20copied%20the%20link%20of%20this%20community%20ten%20thousand%20times%20(10%2C000)%20in%20the%20range%20A1%3AA10000%20of%20the%20Sheet1%2C%20then%20I%20made%20a%20copy%20of%20this%20worksheet%20in%20a%20separate%20workbook%20and%20deleted%20the%20links%20from%20it!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThen%20I%20compared%20the%20difference%20in%20size%20between%20the%20two%20workbooks%2C%20which%20is%20less%20than%201%20KB!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EBefore%3A%2062.1%20KB%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EAfter%3A%2061.5%26nbsp%3BKB%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EPlease%20find%20them%20in%20the%20attachments!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Julie Carson
New Contributor

Hi, I am new to the community but have been working with Excel for a long time.  The one thing that I am not sure of is if I am using hyperlinks just how much they add to the size of the file.  I have an already very large file and we just started hyperlinking in it this year so that is of concern as we already have issues due to the size and number of formula that we have.  Would appreciate any help.  Thank you

16 Replies

Hi Julie,

 

Don't worry about it!

I've done a simple test and you may be surprised when you know its result!

 

I created a workbook and copied the link of this community ten thousand times (10,000) in the range A1:A10000 of the Sheet1, then I made a copy of this worksheet in a separate workbook and deleted the links from it!

Then I compared the difference in size between the two workbooks, which is less than 1 KB!

 

Before: 62.1 KB

After: 61.5 KB

 

Please find them in the attachments!

Thank you.  I did the test too, but I think there were skeptics working with me and wanted a second opinion.

If so, I would recommend you to send my previous reply to them via email!

 

Reply.png

 

Good luck

Hi Haytham,

 

That's if you have exactly the same hyperlink repeated 10 thousand times. Is it hyperlink or not - adds practically nothing.

 

If all hyperlinks are different I guess it'll be added about few hundreds bytes on the top for each hyperlink.

 

And another story if use HYPERLINK() function, it shall add less.

 

In any case that's not a lot.

Hi Sergei,

 

Thanks for this good point!

 

But each hyperlink has an independent entity in an independent cell even if it is the same!

The process of directing you to the link address in the browser is only a functionality and does not affect the size.

 

In fact, when you remove the hyperlinks you actually remove the URL formats which is blue font color and underlined text!

 

Conclusion
The difference between the plain text and the hyperlink
is just the format!

The specific format of the hyperlink is associated with an event to directing you the to link address in the browser, and this is just a functionality and does not affect the size.

 

With regards to HYPERLINK function, it increases the size by ~30 KB as the attached file, and this is not a big difference!

Haytham,

 

For each unique URL into XML of Excel file will be added XML description of such with reference on ID for it.

 

If you have only one URL, doesn't matter how many time you use it, it'll be only one description. If 10 thousand different URL:s - ten thousand such descriptions and ID:s.

 

Anyway, that's not something what increases the size significantly.

Hi Sergei,

 

In XML each cell has an independent tag since it has an independent entity!

 

I've converted the workbook to an XML file, and get access to its source code, and the below code is a part of it.

 

Please take a deep look at this code and you'll see how each cell has an independent tag that includes all its contents!

 

You will notice how href="https://techcommunity.microsoft.com/" will repeat in each tag.

 

 

<table:table table:name="Sheet1" table:style-name="ta1">
    <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
    <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
    <table:table-column table:style-name="co2" table:number-columns-repeated="1023" table:default-cell-style-name="Default"/>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>
    </table:table-row>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce1" office:value-type="string" calcext:value-type="string"><text:p><text:a xlink:href="https://techcommunity.microsoft.com/" xlink:type="simple">https://techcommunity.microsoft.com/</text:a></text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="1023"/>

 

 

I mean not conversion to XML but internal Excel file structure if you unzip it. Here each resource (URL text) is defined only once and cell value is referencing on it. Text of the URL is not repeated for each cell definition.

 

Sergei,

 

Please note that the Excel file in XLSX extension is an XML-based format.

XML is a markup language and it's responsible for the Excel file structure.

 

The code that you saw before is really what is going on inside the Excel file!

Even with other extensions, you'll see the same thing but in a different syntax!

Haytham,

 

In which exactly XML file is the above code? The biggest one is sheet1.xml and it looks differently.

Sergei,
 
Your last reply is unclear or vague!

 

Again, the code above is part of the structure of the workbook "before" that I previously attached!

It's what's going on behind the scenes!

 

You said before: "If you have only one URL, doesn't matter how many time you use it, it'll be only one description. If 10 thousand different URL:s - ten thousand such descriptions and ID:s."

 

The code proved that this is wrong!

 

I will not discuss more because it has become useless.

Hi Haytham,

 

It looks strange for me. If unzip your Before file its structure as in attaches before.txt file. Biggest file here which describes the sheet is sheet1.xml. If open it, all what defines the content with hyperlinks is at very bottom of the file

<hyperlinks><hyperlink ref="A1" r:id="rId1" xr:uid="{B7B34BD7-8C51-483C-B6EE-3A89EFD0E69A}"/>
<hyperlink ref="A2:A10000" r:id="rId2" display="https://techcommunity.microsoft.com/" xr:uid="{8583AAC1-002D-49A8-B3C5-A3CEE3F36A01}"/></hyperlinks>

Value of each row is the reference on resource defined in tiny resource file (between <v> and </v>) and looks like 

<row r="10000" spans="1:1" x14ac:dyDescent="0.35"><c r="A10000" s="1" t="s"><v>0</v></c></row>

File After is exactly the same except small block with hyperlinks at the bottom of the file.

 

To compare, I generated another file with 3 different hyperlinks repeat in 10 cells each. Entire block which describes them is

<hyperlinks><hyperlink ref="A1" r:id="rId1" xr:uid="{65A09A39-A823-4B29-831D-35135F8B94C8}"/>
<hyperlink ref="A2:A10" r:id="rId2" display="http://techcommunity.microsoft.com" xr:uid="{445541D1-C4DC-4651-A162-47AE45477BCF}"/>
<hyperlink ref="A11" r:id="rId3" xr:uid="{ED775096-F6A1-4801-9196-FE06349F96F8}"/>
<hyperlink ref="A12:A20" r:id="rId4" display="www.microsoft.com" xr:uid="{E07D5B65-8D06-4F4F-B908-19ADD0C32BEA}"/>
<hyperlink ref="A21" r:id="rId5" xr:uid="{D978AABC-E1CD-4864-811E-4A8DC1F21E56}"/><hyperlink ref="A22:A30" r:id="rId6" display="https://vivaldi.com/" xr:uid="{A75F23EE-CA26-477D-839C-A9B8857EE103}"/></hyperlinks>

This block is 3 times bigger since we have 3 different hyperlinks instead of only one.

 

Oops, txt files are not allowed to attach. Zipped.

Hi Sergei,

 

Now I know where the file sheet1.xml came from!

 

I'm not an XML language expert and how it is used in Excel files, but after reading this article, I admit that the code I mentioned before doesn't represent the actual structure of the Excel file.

What described in this article is actually the structure of the Excel file and what happened behind the scenes!

 

But however, the subject is not as you think!

What I did in the Before file was holding the fill handle in the first cell and then dragging it until I reached the cell A10000.
This is why the definition is uniform across the range.


But this definition may differ depending on how you create the links.
If you enter the links in the cells (cell after cell) without using the fill handle, the definition will appear as follows:

 Hyperlinks XML Code.pngNOTE: You will find this code spreads horizontally in the single line. (For clarification, I've moved each hyperlink in a separate line)

 

You will notice that the link is the same in the workbook, but after you unzip it you will find it defined 15 times, and it's not visible here, it appears to be encrypted on every line, and has a unique ID!
This is because I entered the links manually without using the fill handle!

 

But the interesting fact is that each link in the range A1:A15 is an instance of the parent link which is located in a separate file called sharedStrings.xml and the link is counted 15 times in this file.

 

sharedStrings.png

 

What do you think of this?

 

Some people may think that this subject has taken up more discussion than it deserves!
In fact, it is fun to dive into the Excel to this extent and learn all these stuff!

 

Thank you
Regards

Hi Julie,

Hyperlinks aren't any different in size to the texts that created them and although it will increase the file size by 1 or 2 times compared to its visible text. So, I wouldn't worry about the file size increased if it is increases only using =Hyperlink( , ) function.

However, some folks are usually mistaken between pasted hyperlinks and hyperlinks using Hyperlink function. If user has numerous hyperlinks using pasted links then that for sure increases the size of workbook significantly and plz allow me to demonstrate here:

Open an empty Excel file and enter a text e.g. Myfolder there and then right click and click hyperlink and then select a folder as the address of the hyperlink C:\Users\Julie\Downloads\ and then save the workbook somewhere
then open a new workbook and type this somewhere =Hyperlink("C:\Users\Julie\Downloads\","Myfolder") and save in the same folder as the first workbook.

If you check the size of the above two workbooks, you will see that the second workbook is smaller in size than the first one. This was just one hyperlink, if you have many hyperlinks the difference of size will be significant.

Whenever linking cells either with a folder or file, instead of copy and Paste (control + v ) use paste-values only and create link using hyperlink() function and this way it will open quickly and will not increase file size.
Highlighted

Hi Jamil,

 

In some cases, the size will vary slightly and this difference will not have a significant impact even if the number of links increases.

This is in case if the link is external!

Please see the attached files.

 

It may also be different if these links are duplicate and external as in the case I mentioned earlier, and how the links in the HYPERLINK function have increased the size of the workbook by about 30 KB.

This may be thanks to the sharedStrings.xml which is has the responsibility of reducing the size of the hyperlinks strings.

 

Not always the hyperlinks in HYPERLINK function are lower in size!

Hi Julie

I would suggest that if hyperlinking adds benefit to your operations then it may outweight any negatives from whatever file size increases you experience.

Best wishes.

Cheers
Damien
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
33 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies