+ Reply to Thread
Results 1 to 2 of 2

Optimizing compatibility of excel file [with older versions]

  1. #1
    Forum Contributor
    Join Date
    08-12-2019
    Location
    NYC
    MS-Off Ver
    2019
    Posts
    155

    Optimizing compatibility of excel file [with older versions]

    Hi,

    I'm trying to optimize the compatibility of my excel file with older versions of excel (2010 and above) that other users may be using. I have currently 3 significant losses of functionality that I dont know how to correct:

    1. The first two refer to "One or more cells in this workbook contain a formula that has spilled or may spill in the future. These formulas will be converted into legacy array formulas and will not spill or change dimension in order versions of excel".
    This alert refers to cells with the following formulas:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    I don't really understand which part of the formula is related to the spilling? And what should I do to avoid any compatibility issue?

    2. The third error refers to "One or more cells in this workbook contain a data bar rule that uses a "Negative Value" setting. These bars will not be supported in earlier versions of Excel". Here, i'm not sure to understand what it means exactly as the cells have formulas that return positive values. Is there an option to change / check somewhere?

    3. After checking the compatibility of excel's formulas, formatting, etc, is there a way to also automatically identify if some vba code in my workbook is not compatible with earlier versions?

    Appreciate any help on that

    Thanks a lot!
    Last edited by 6StringJazzer; 05-31-2020 at 10:18 PM. Reason: clarified title

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Optimizing compatibility of excel file

    I'm not sure about #1. I have not using spilling formulas yet, but I think they would apply only to array formulas. Your formula does not look like it returns an array. Have you entered it as an array formula?

    #2. It is talking about a conditional formatting rule, not the formula in the cell.

    #3. I know of no automatic way to check this; maybe there is a third-party tool. However, VBA is pretty stable across versions and the main way to introduce a problem is to use worksheet functions that are not backwards-compatible, either with Application.WorksheetFunction or inserting them in formulas.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 97 Compatibility Mode Problem with Accessing File
    By John Vieren in forum Excel General
    Replies: 6
    Last Post: 06-04-2020, 10:14 AM
  2. Excel file Compatibility Error
    By Dnyan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2019, 06:06 AM
  3. vba excel - optimizing code
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-22-2018, 12:48 PM
  4. Optimizing excel formula
    By a.hudrea in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-31-2014, 02:31 AM
  5. Optimizing Portfolio in Excel
    By NFS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-08-2012, 01:22 PM
  6. [SOLVED] Populating Master File - Using Excel 2003 (with 2007 compatibility package)
    By psuie13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2012, 11:40 AM
  7. Replies: 3
    Last Post: 09-08-2011, 04:31 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1