+ Reply to Thread
Results 1 to 4 of 4

Formulat problems moving to Excel 2007

  1. #1
    Registered User
    Join Date
    11-25-2003
    Location
    Decatur, Alabama
    Posts
    94

    Formulat problems moving to Excel 2007

    I have an expense report form that contains formulas. When I open the Excel file in Excel 2007, one formula no longer works.

    Here is the formula: =CountOfCF(G9:G40,1)

    This formula counts the number of red-colored numbers in a block of cells (G9 to G40). The numbers are red because their value happens to be greater than $76.99.

    I receive a NAME? error when I open the report in the 2007 version of Excel.

    Can anyone help?

    Thanks,
    Mike
    Learn to Serve Others. Kindness is far better than the alternative.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    That's a user-defined function from an add-in or the Personal.xls workbook; you need to find it and bring it over.

  3. #3
    Registered User
    Join Date
    11-25-2003
    Location
    Decatur, Alabama
    Posts
    94

    Thanks

    Thank you SHG. I was wondering, though. This form was sent to lots of people by e-mail for use on their own computers and used successfully until 2007 came along. In fact, it was used for years with no trouble. You mentioned the personal.xls and the add-in. What is the best way to make it work for everyone using 2007? I didn't do anything special before.

    Mike

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Easiest IMO would be to create and distribute an add-in, and tell people to stick it in their add-ins directory (which in XP, is the path returned by Application.UserLibraryPath, and usually C:\Documents and Settings\[username]\Application Data\Microsoft\AddIns\), and then install it.

    Or, if the expense report itself is an automated workbook, add it to that and redistribute.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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