{"id":3318,"date":"2018-11-10T10:07:48","date_gmt":"2018-11-10T10:07:48","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3318"},"modified":"2024-03-26T13:07:48","modified_gmt":"2024-03-26T13:07:48","slug":"excel-icon-exclamation-mark","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/","title":{"rendered":"Icon Exclamation Mark in Excel"},"content":{"rendered":"\n<p>Excel and many other programs use icons to visualize the file extension. If you see an icon with an exclamation mark on it, you may wonder whether the file contains an error or it\u2019s corrupted, but you don&#8217;t have to worry, it just means that this is a macro-enabled Excel file.<\/p>\n\n\n\n<p>If you want to write some VBA code, you should use this format. This type of format was introduced in Office 2007 and is continued since then.<\/p>\n\n\n\n<p>Here, you have three types of files inside the Windows File Explorer.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"250\" height=\"80\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png\" alt=\"\" class=\"wp-image-3321\"\/><\/figure>\n\n\n\n<p>Each of them has a different icon. But you don\u2019t know what extension they have.<\/p>\n\n\n\n<p>You can change that (in Windows File Explorer) by going to <strong>View &gt;&gt; Show\/hide <\/strong>and checking the<strong> File Name Extensions<\/strong> option.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"147\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/file-name-extensions.png\" alt=\"\" class=\"wp-image-3323\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/file-name-extensions.png 479w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/file-name-extensions-300x92.png 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/figure>\n\n\n\n<p>This will display both the file name and its extension.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"250\" height=\"80\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons-with-extensions.png\" alt=\"\" class=\"wp-image-3322\"\/><\/figure>\n\n\n\n<p>Now, you can see that the first file is the pre-Excel 2007 version of Excel. The third format was created after the Excel 2007 version, and the file between them is a macro-enabled file.<\/p>\n\n\n\n<p>If you create some VBA code and try to save it as an <strong>xlsx<\/strong> file, you are going to get the following error.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"620\" height=\"173\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/vba-save-warning.png\" alt=\"\" class=\"wp-image-3320\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/vba-save-warning.png 620w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/vba-save-warning-300x84.png 300w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to remove the exclamation mark from the Excel icon<\/h2>\n\n\n\n<p>If you want to get rid of the exclamation mark, you can just <a href=\"https:\/\/officetuts.net\/excel\/training\/saving-files\/\">save the files<\/a> as normal xlsx files. Be aware that it will get rid of all macros inside this file, so any function written in VBA will be gone. But if you don\u2019t have any important code or any code at all, you can go to <strong>File &gt;&gt; Save As &gt;&gt; Browse<\/strong> and choose the following settings.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"551\" height=\"478\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/save-xlsx.png\" alt=\"\" class=\"wp-image-3319\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/save-xlsx.png 551w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/save-xlsx-300x260.png 300w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Excel and many other programs use icons to visualize the file extension. If you see an icon with an exclamation mark on it,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Icon Exclamation Mark in Excel<\/title>\n<meta name=\"description\" content=\"Interpret Excel icons with this guide on file extensions. Discover the difference between file formats and how to write VBA code in macro-enabled files.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Icon Exclamation Mark in Excel\" \/>\n<meta property=\"og:description\" content=\"Interpret Excel icons with this guide on file extensions. Discover the difference between file formats and how to write VBA code in macro-enabled files.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-10T10:07:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T13:07:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Icon Exclamation Mark in Excel\",\"datePublished\":\"2018-11-10T10:07:48+00:00\",\"dateModified\":\"2024-03-26T13:07:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/\"},\"wordCount\":283,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/\",\"name\":\"Icon Exclamation Mark in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png\",\"datePublished\":\"2018-11-10T10:07:48+00:00\",\"dateModified\":\"2024-03-26T13:07:48+00:00\",\"description\":\"Interpret Excel icons with this guide on file extensions. Discover the difference between file formats and how to write VBA code in macro-enabled files.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Icon Exclamation Mark in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Icon Exclamation Mark in Excel","description":"Interpret Excel icons with this guide on file extensions. Discover the difference between file formats and how to write VBA code in macro-enabled files.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/","og_locale":"en_US","og_type":"article","og_title":"Icon Exclamation Mark in Excel","og_description":"Interpret Excel icons with this guide on file extensions. Discover the difference between file formats and how to write VBA code in macro-enabled files.","og_url":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/","article_published_time":"2018-11-10T10:07:48+00:00","article_modified_time":"2024-03-26T13:07:48+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Icon Exclamation Mark in Excel","datePublished":"2018-11-10T10:07:48+00:00","dateModified":"2024-03-26T13:07:48+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/"},"wordCount":283,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/","url":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/","name":"Icon Exclamation Mark in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png","datePublished":"2018-11-10T10:07:48+00:00","dateModified":"2024-03-26T13:07:48+00:00","description":"Interpret Excel icons with this guide on file extensions. Discover the difference between file formats and how to write VBA code in macro-enabled files.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-icons.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/excel-icon-exclamation-mark\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Icon Exclamation Mark in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3318"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3318"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3318\/revisions"}],"predecessor-version":[{"id":17291,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3318\/revisions\/17291"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}