{"id":15966,"date":"2023-07-10T19:57:34","date_gmt":"2023-07-10T19:57:34","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=15966"},"modified":"2024-03-26T12:57:23","modified_gmt":"2024-03-26T12:57:23","slug":"excel-file-size-unexpectedly-large","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/","title":{"rendered":"File Size Unexpectedly Large in Excel"},"content":{"rendered":"\n
Sometimes, it might happen that your Excel file is too large for no apparent reason. There are multiple occasions and scenarios when this can happen.<\/p>\n\n\n\n
In the example below, we will explain why this might happen.<\/p>\n\n\n\n
Excel File Unexpectedly Large<\/h2>\n\n\n\n
Some of the reasons for files being too large are:<\/p>\n\n\n\n
\n
Hidden Worksheets<\/strong><\/li>\n<\/ol>\n\n\n\n
The hide option in Excel actually has three possible states: 1) Unhidden; 2) Hidden and; 3) VeryHidden.<\/strong> <\/p>\n\n\n\n
Usually, people are familiar with the first two options, and they are pretty easy to find. If we create another sheet in our Workbook<\/strong>, we can easily hide the second sheet by right-clicking on it, and then choosing Hide as an option<\/strong>: <\/p>\n\n\n\n<\/figure>\n\n\n\n
When we see the list of sheets now, we will not be able to see the sheet, which might mean that we have some hidden data from us, making our file larger. <\/p>\n\n\n\n
We can also make our sheets very hidden, and we can only do that through Visual Basic<\/strong>. First, we will create another sheet<\/strong>. Then we will open the VBA by clicking ALT + F11<\/strong> on our keyboard. This will open the window in which we can access the properties of our sheet, and change the visibility to xlSheetVeryHidden<\/strong>:<\/p>\n\n\n\n<\/figure>\n\n\n\n
When we return to the Workbook again, we will not be able to Unhide the sheet<\/strong> by clicking on any of the visible ones and then right-clicking on it:<\/p>\n\n\n\n<\/figure>\n\n\n\n
As seen in the picture above, only Sheet 2 is visible<\/strong>. The only way to make Sheet 3 visible<\/strong> again is to open the VBA and choose xlSheetVisible<\/strong> for this sheet. <\/p>\n\n\n\n\n
Formulas and Data<\/strong>. If we have a very big amount of data and various formulas in our file this can affect the file sizing. We can continually optimize the formulas or remove something that is not entirely necessary. Circular references<\/strong> can affect this, as well as some formulas that might be complex<\/strong> to calculate large groups of data, such as VLOOKUP<\/strong>. To inspect any possible errors we always use error checking. To do this, we will go to the Formulas tab<\/strong>, to Formulas auditing<\/strong>, and then to Error Checking<\/strong>: <\/li>\n<\/ol>\n\n\n\n<\/figure>\n\n\n\n
In this dropdown, we have Circular References<\/strong> as well, and they can be traced and inspected in this field.<\/p>\n\n\n\n\n
Formatting<\/strong>. If we use formatting often, for example, conditional formatting or styles<\/strong>, this can increase the size of our files. To reduce the file size, we can use the formatting less often.<\/li>\n\n\n\n
Embedded objects<\/strong>. If we have a lot of embedded objects, such as charts, images, or some other documents, this can increase the size of the file. To avoid this, we can always use external objects<\/strong>, not embedded objects<\/strong>. <\/li>\n\n\n\n
Unused worksheets<\/strong>. In addition to having the hidden sheets, we can have some sheets that are not being used or contain unnecessary data<\/strong>. These sheets should be deleted or removed<\/strong>.<\/li>\n\n\n\n
File format<\/strong>. Out of all the Excel formats, older ones (such as .xls<\/strong>) are larger in size in comparison with the new ones. If you go to File >> Save<\/strong> as you can inspect all possible saving options: <\/li>\n<\/ol>\n\n\n\n<\/figure>\n\n\n\n\n
If you cannot resize the file with any of these options mentioned above, you can always resize the file by compressing it. For this purpose, we have applications such as WinRar or 7Zip<\/strong>. To do this, we will save the file<\/strong>, go to its location, right-click on it<\/strong>, and choose Add to archive: Bottom of Form:<\/strong><\/li>\n<\/ol>\n\n\n\n<\/figure>\n","protected":false},"excerpt":{"rendered":"
Sometimes, it might happen that your Excel file is too large for no apparent reason. There are multiple occasions and scenarios when this…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"\n
File Size Unexpectedly Large in Excel<\/title>\n<meta name=\"description\" content=\"Discover why your Excel file may be unexpectedly large. Learn about hidden worksheets and how formulas and data can affect file size.\" \/>\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-file-size-unexpectedly-large\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"File Size Unexpectedly Large in Excel\" \/>\n<meta property=\"og:description\" content=\"Discover why your Excel file may be unexpectedly large. Learn about hidden worksheets and how formulas and data can affect file size.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T19:57:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T12:57:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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-file-size-unexpectedly-large\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"File Size Unexpectedly Large in Excel\",\"datePublished\":\"2023-07-10T19:57:34+00:00\",\"dateModified\":\"2024-03-26T12:57:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/\"},\"wordCount\":575,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/\",\"name\":\"File Size Unexpectedly Large in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png\",\"datePublished\":\"2023-07-10T19:57:34+00:00\",\"dateModified\":\"2024-03-26T12:57:23+00:00\",\"description\":\"Discover why your Excel file may be unexpectedly large. Learn about hidden worksheets and how formulas and data can affect file size.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png\",\"width\":424,\"height\":434},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"File Size Unexpectedly Large 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.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"File Size Unexpectedly Large in Excel","description":"Discover why your Excel file may be unexpectedly large. Learn about hidden worksheets and how formulas and data can affect file size.","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-file-size-unexpectedly-large\/","og_locale":"en_US","og_type":"article","og_title":"File Size Unexpectedly Large in Excel","og_description":"Discover why your Excel file may be unexpectedly large. Learn about hidden worksheets and how formulas and data can affect file size.","og_url":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/","article_published_time":"2023-07-10T19:57:34+00:00","article_modified_time":"2024-03-26T12:57:23+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"File Size Unexpectedly Large in Excel","datePublished":"2023-07-10T19:57:34+00:00","dateModified":"2024-03-26T12:57:23+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/"},"wordCount":575,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/","url":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/","name":"File Size Unexpectedly Large in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png","datePublished":"2023-07-10T19:57:34+00:00","dateModified":"2024-03-26T12:57:23+00:00","description":"Discover why your Excel file may be unexpectedly large. Learn about hidden worksheets and how formulas and data can affect file size.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png","width":424,"height":434},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/excel-file-size-unexpectedly-large\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"File Size Unexpectedly Large 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."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15966"}],"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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=15966"}],"version-history":[{"count":2,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15966\/revisions"}],"predecessor-version":[{"id":17290,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15966\/revisions\/17290"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=15966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=15966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=15966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-1.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-2.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-3.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-4.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-5.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-15966-6.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"