Workaround for Excel 2007 Crash

Homepage (2016) v2 XL-Viking Support Forums Announcments & Updates Workaround for Excel 2007 Crash

This topic contains 0 replies, has 1 voice, and was last updated by  Knut 2 years ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #2340 Reply

    Knut
    Moderator

    A Microsoft bug is causing Excel 2007 (used with Windows 7 or XP) to Crash when a sheet is added or re-named. This occurs when a volatile function is present in the workbook.

    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.

    1. Before re-naming or adding a sheet, turn OFF the Automatic Calculation option. I.E set it to manual detailed below.

    – Go to Excel Options – Formulas
    – Change Workbook Calculation From “Automatic” To “Manual”

    2. Re-name or add sheet(s)

    3. Turn Automatic Calculation back on

    Only users with Excel 2007 need to follow the above instructions as this issue was corrected in Excel versions 2010 and 2013.

    Regards

    The XL-Viking Team

Viewing 1 post (of 1 total)
Reply To: Workaround for Excel 2007 Crash
Your information:





<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre> <em> <strong> <del datetime=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width="">