{"id":309,"date":"2008-04-11T17:07:26","date_gmt":"2008-04-11T22:07:26","guid":{"rendered":"http:\/\/alsplace.aldenbaker.com\/alsplace\/microsoft\/ms-office\/ms-excel\/309\/tell-excel-to-leave-you-alone\/"},"modified":"2008-04-11T17:07:26","modified_gmt":"2008-04-11T22:07:26","slug":"tell-excel-to-leave-you-alone","status":"publish","type":"post","link":"https:\/\/alsplace.info\/?p=309","title":{"rendered":"Tell Excel to Leave You Alone!"},"content":{"rendered":"\n<!-- ALL ADSENSE ADS DISABLED -->\n<p align=\"justify\"><font>Yesterday&#39;s topic of formulas linked one workbook to another and as you may recall, in the end, MS Excel kept asking if you wanted to update the information. That&#39;s not necessarily a bad thing, but if you control both workbooks and you know there&#39;s no security problem, it can get somewhat annoying. <\/font><\/p>\n<p align=\"justify\"><font>So, you must be asking, &quot;Can I get Excel to stop asking and just go ahead with the update automatically?&quot;<\/font><\/p>\n<p align=\"justify\"><font>That&#39;s definitely a good question, so let&#39;s get right down to it. Should you decide that updating is always the right thing to do and you want Excel to stop asking and just do it, simply follow these easy steps. <\/font><\/p>\n<p align=\"justify\"><font>If you&#39;re using <strong>Excel 2003 or older<\/strong>:<\/font><\/p>\n<ul>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>Go to the <strong>Tools<\/strong> menu, <strong>Options<\/strong> choice.<\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>Under the <strong>Edit<\/strong> tab, <strong>uncheck<\/strong> the &quot;<strong>Ask to Update Automatic Links<\/strong>&quot; checkbox.<\/p>\n<p> <img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/imgsrv.worldstart.com\/mso-images\/old-excel-stop-asking-updat.gif\" border=\"1\" width=\"400\" height=\"304\" \/><\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>Click <strong>OK<\/strong>. <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<\/ul>\n<div align=\"justify\">\n<p><font>If you use <strong>Excel 2007<\/strong>:<\/font><\/p>\n<\/p><\/div>\n<ul>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>You need to start with the <strong>Office Button <\/strong>and then <strong>click on the Excel Options button<\/strong> found there.<\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>Once you&#39;re in the Excel Options dialogue window, you need to go to the <strong>Advanced Options<\/strong>, &quot;<strong>When calculating this workbook<\/strong>&quot; section.<\/p>\n<p> <img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/imgsrv.worldstart.com\/mso-images\/excel-07-stop-asking-update.gif\" border=\"1\" width=\"400\" height=\"196\" \/><\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font><strong>Uncheck<\/strong> the &quot;<strong>Update links to other documents<\/strong>&quot; choice.<br <a href=\"http:\/\/www.neighborhoodrealtyonline.com\/\">overnight viagra<\/a>  \/> <br \/> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>Click <strong>OK<\/strong>.<\/font><\/div>\n<\/p><\/div>\n<\/li>\n<\/ul>\n<div align=\"justify\">\n<p><font>Now, you&#39;re all set. Automatic updates without a second thought! <\/font><\/p>\n<\/p><\/div>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d309').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d309\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d309').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d309').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"excerpt":{"rendered":"<p>Yesterday&#39;s topic of formulas linked one workbook to another and as you may recall, in the end, MS Excel kept asking if you wanted to update the information. That&#39;s not necessarily a bad thing, but if you control both workbooks and you know there&#39;s no security problem, it can get somewhat annoying. So, you must [&hellip;]<\/p>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d309').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d309\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d309').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d309').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[32],"tags":[],"_links":{"self":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/309"}],"collection":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=309"}],"version-history":[{"count":0,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/309\/revisions"}],"wp:attachment":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}