{"id":1917,"date":"2025-06-30T21:27:55","date_gmt":"2025-06-30T21:27:55","guid":{"rendered":"https:\/\/xlfxs.com\/?p=1917"},"modified":"2025-06-30T21:27:55","modified_gmt":"2025-06-30T21:27:55","slug":"stale-values-scratched-functions","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1917","title":{"rendered":"Stale values (Scratched functions)"},"content":{"rendered":"\n<p>Excel recently started to show cells with formulas scratched (see screenshot).<\/p>\n\n\n\n<p>Looks like this new feature to tell user that these cells will have new values and they are in the process of getting calculated.<\/p>\n\n\n\n<p>If you want to disable that feature, uncheck &#8220;Show stale values&#8221; in &#8220;Calculation Options&#8221; in &#8220;Formula&#8221; bar (Screenshot)<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"695\" data-id=\"1920\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues2-1024x695.jpg\" alt=\"\" class=\"wp-image-1920\" srcset=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues2-1024x695.jpg 1024w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues2-300x204.jpg 300w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues2-768x521.jpg 768w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues2-1536x1042.jpg 1536w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues2-2048x1390.jpg 2048w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues2-1200x814.jpg 1200w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues2-685x465.jpg 685w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"310\" height=\"315\" data-id=\"1918\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues1.jpg\" alt=\"\" class=\"wp-image-1918\" srcset=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues1.jpg 310w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues1-295x300.jpg 295w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"247\" data-id=\"1919\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues3-1024x247.jpg\" alt=\"\" class=\"wp-image-1919\" srcset=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues3-1024x247.jpg 1024w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues3-300x72.jpg 300w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues3-768x185.jpg 768w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues3-1200x290.jpg 1200w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues3-685x165.jpg 685w, https:\/\/xlfxs.com\/wp-content\/uploads\/2025\/06\/StaleValues3.jpg 1520w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Excel recently started to show cells with formulas scratched (see screenshot). Looks like this new feature to tell user that these cells will have new values and they are in the process of getting calculated. If you want to disable that feature, uncheck &#8220;Show stale values&#8221; in &#8220;Calculation Options&#8221; in &#8220;Formula&#8221; bar (Screenshot)<\/p>\n","protected":false},"author":1,"featured_media":1918,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,27,5,12],"tags":[220,137,168],"class_list":["post-1917","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-user-tips","category-format-cells","category-non-functions","category-worksheet","tag-feature","tag-formula","tag-non-functions"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1917","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=1917"}],"version-history":[{"count":1,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1917\/revisions"}],"predecessor-version":[{"id":1921,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1917\/revisions\/1921"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1918"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}