A Microsoft bug is causing Excel 2007 (when used with Windows 7 or XP) to Crash when a sheet is added or re-named.<\/p>\n

This occurs when a volatile function is present in the workbook.<\/p>\n

Since the XL-Viking Variables Functions xlv and xlvu are volatile by their nature, the XL-Viking Team suggest using the following work-around whenever one of these functions are used and a sheet is renamed or added:<\/p>\n

1.<\/strong> Before re-naming or adding a sheet, turn OFF the Automatic Calculation option. I.E set it to manual as shown below.<\/strong><\/p>\n

 <\/p>\n

<\/a><\/p>\n

 <\/p>\n

2.<\/strong> Re-name or add sheet(s)<\/strong><\/p>\n

3. Turn Automatic Calculation back on<\/strong><\/p>\n

 <\/p>\n

Only users with Excel 2007 need to follow the above instructions as this issue was corrected in Excel versions 2010 and 2013.<\/p>\n

 <\/p>\n

Regards<\/p>\n

The XL-Viking Team<\/p>\n","protected":false},"excerpt":{"rendered":"A Microsoft bug is causing Excel 2007 (when used with Windows 7 or XP) to Crash when a sheet is added or re-named.","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/posts\/2327"}],"collection":[{"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/comments?post=2327"}],"version-history":[{"count":5,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/posts\/2327\/revisions"}],"predecessor-version":[{"id":2344,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/posts\/2327\/revisions\/2344"}],"wp:attachment":[{"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/media?parent=2327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/categories?post=2327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xl-viking.com\/wp-json\/wp\/v2\/tags?post=2327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}