{"id":1798,"date":"2022-10-25T09:15:33","date_gmt":"2022-10-25T14:15:33","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1798"},"modified":"2022-10-25T09:15:33","modified_gmt":"2022-10-25T14:15:33","slug":"spreadsheet-compare-application","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1798","title":{"rendered":"Spreadsheet Compare application"},"content":{"rendered":"\n<p>This is only available in Microsoft 365 Enterprise version, an application that can compare two workbooks in all objects.<\/p>\n\n\n\n<p>This includes cells (values or formulas) in all sheets, VBA objects and macros.<\/p>\n\n\n\n<p><strong>Bug<\/strong>: I noticed that even if VBE project in a workbook is protected, it will still open it and show you all macros, a bug I reported a while back to Microsoft.<\/p>\n\n\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-large\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/10\/SpreadsheetCompare-1.jpg\"><img decoding=\"async\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/10\/SpreadsheetCompare-1-621x1024.jpg\" alt=\"\" class=\"wp-image-1800\"\/><\/a><\/figure><\/div>\n\n\n<p>Spreadsheet compare application in Office 365 Enterprise channel<\/p>\n\n\n\n<p>Icon:<br><code>%ProgramFiles%\\Microsoft Office\\Root\\VFS\\Windows\\Installer{90160000-000F-0000-1000-0000000FF1CE}\\sscicons.exe,3<\/code><\/p>\n\n\n\n<p>Application location and command:<br><code>\"C:\\Program Files\\Microsoft Office\\root\\Client\\AppVLP.exe\" \"C:\\Program Files (x86)\\Microsoft Office\\Office16\\DCF\\SPREADSHEETCOMPARE.EXE\"<\/code><\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>More details on official link here &#8230;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/overview-of-spreadsheet-compare-13fafa61-62aa-451b-8674-242ce5f2c986\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2023\/01\/SpreadsheetCompare-1-1024x829.jpg\" alt=\"\" class=\"wp-image-1838\"\/><\/a><\/figure>\n\n\n\n<p><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/overview-of-spreadsheet-compare-13fafa61-62aa-451b-8674-242ce5f2c986\">https:\/\/support.microsoft.com\/en-us\/office\/overview-of-spreadsheet-compare-13fafa61-62aa-451b-8674-242ce5f2c986<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is only available in Microsoft 365 Enterprise version, an application that can compare two workbooks in all objects. This includes cells (values or formulas) in all sheets, VBA objects and macros. Bug: I noticed that even if VBE project in a workbook is protected, it will still open it and show you all macros,&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=1798\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Spreadsheet Compare application&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1799,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,5,12],"tags":[114,189,205],"class_list":["post-1798","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-user-tips","category-non-functions","category-worksheet","tag-compare","tag-spreadsheet","tag-vbe"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1798"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1798\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1799"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}