{"id":16363,"date":"2009-10-15T07:00:00","date_gmt":"2009-10-15T07:00:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/oldnewthing\/2009\/10\/15\/dont-use-global-state-to-manage-a-local-problem-practical-exam\/"},"modified":"2009-10-15T07:00:00","modified_gmt":"2009-10-15T07:00:00","slug":"dont-use-global-state-to-manage-a-local-problem-practical-exam","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/oldnewthing\/20091015-00\/?p=16363","title":{"rendered":"Don't use global state to manage a local problem, practical exam"},"content":{"rendered":"

There was much speculation as to how the “Ignore other applications that use Dynamic Data Exchange” setting got set<\/a>. Well, one possibility<\/a> is that somebody used global state to manage a local problem<\/a>.\n “Why on earth does this setting exist?<\/a>” I don’t know, but there appear to be scripts which rely on it.\n The setting is exposed to scripts, and perhaps at some point you ran a script which didn’t want Excel to be interrupted while it was running. The documentation for the Excel Application Object<\/a> does say that it contains application-wide (global) settings.\n I’m not saying that’s why you<\/i> are encountering the problem<\/a>, but it’s just one possibility I ran across while doing some Web searching to learn more about the setting.<\/p>\n

One of those Web searches took me to Susan Bradley (the SBS Diva)<\/a> who gave one reason why somebody would enable this checkbox: It shuts up a different warning<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"

There was much speculation as to how the “Ignore other applications that use Dynamic Data Exchange” setting got set. Well, one possibility is that somebody used global state to manage a local problem. “Why on earth does this setting exist?” I don’t know, but there appear to be scripts which rely on it. The setting […]<\/p>\n","protected":false},"author":1069,"featured_media":111744,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[25,104],"class_list":["post-16363","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oldnewthing","tag-code","tag-tipssupport"],"acf":[],"blog_post_summary":"

There was much speculation as to how the “Ignore other applications that use Dynamic Data Exchange” setting got set. Well, one possibility is that somebody used global state to manage a local problem. “Why on earth does this setting exist?” I don’t know, but there appear to be scripts which rely on it. The setting […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts\/16363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/users\/1069"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/comments?post=16363"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts\/16363\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/media\/111744"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/media?parent=16363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/categories?post=16363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/tags?post=16363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}