+ Reply to Thread
Results 1 to 3 of 3

Invalid warning?

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    584

    Invalid warning?

    Yesterday I created a few procedures to display charts. They ran fine for the couple hours I was working on them.

    Today when I run the same procedures I keep getting a warning message :


    "Excel found a problem with one or more formula references in this worksheet.
    Check that the cell references, range names, defined names and links to other workbooks in your formulas are all correct."

    And if I simply click on the "OK" everything runs fine. The data on the sheet are all entered as values. No formulas nor references. There were formulas, but I copied and paste special as values, then I create the chart from the data. The warning goes off sporadically, sometimes when I halt the code at the line just prior to creating a chart, sometimes after the chart is being created, sometimes after the entire procedure (Sub) has run. I am regarding this about the same as mosquitoes. The table with the data (it is NOT a formal table as in Insert:Table, just data laid out in rows and columns) is named in VBA code as rngData01, and I checked in the immediate window for rngData01.address which was correct.

    I tried to get rid of the dang message with setting Application.DisplayAlerts to False, but no good.

    Is there a switch to make these things just go away for when I run my charts?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,925

    Re: Invalid warning?

    That happens with a chart when you specify a series of criteria that return nothing. In my case, it happens with wireless devices and error codes. I might be displaying one wireless device with Error Code A and then select another wireless device that doesn't have any records for Error Code A.

    Check to see if the combination you specified actually has an intersection set (it has at least one record to display) and if it doesn't then do some sort of error handling.

    Excel gets kind of funky when you ask it to do something with nothing. This happens with pivot table filters. If you try to set a filter to a value that doesn't exist, it will ask if you want to change the current value to the non-existent value.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    584

    Re: Invalid warning?

    Thank-you!

    I can't identify an instance where this is occurring, but I will try to audit the values for this next time and see what I can find. REAL annoying!

+ 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. IF(AND ....) get invalid message
    By Nomad1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-16-2016, 01:46 PM
  2. Invalid use of null
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2015, 09:02 AM
  3. help with invalid subscript
    By vonanne0 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-25-2014, 07:10 PM
  4. Warning of "invalid references"
    By brucemc777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-29-2014, 08:31 PM
  5. Invalid Email Id
    By hardeep.kanwar in forum Excel General
    Replies: 3
    Last Post: 10-19-2009, 11:53 AM
  6. Invalid property value.
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-15-2005, 08:05 PM
  7. [SOLVED] Invalid qualifer
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2005, 05:05 PM

Tags for this Thread

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