+ Reply to Thread
Results 1 to 3 of 3

Warning of "invalid references"

  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
    615

    Warning of "invalid references"

    Running a worksheet with vba, at the start of the code I turn warnings off and at the very end of the code I turn them back on.

    When the routines complete a warning is raised:
    A formula in this worksheet contains one or more invalid references.
    Verify that your formulas contain a valid path, workbook, range name, and cell reference.
    OK. How? When I run Error Checking everything comes up clean.

    Clicking on "Show Formulas" shows no formulas for there are no formulas on the sheet to show, just a chart, and clicking "Show Formulas" just turns my dates into serial numbers and screws up the display of the two comboboxes, messing the fonts and drop-down arrows, and since closing and reopening didn't revert the comboboxes back to normal I will now have to blow them away and resurrect them. Ahhhhh, and I also see Show Formulas also messed up my command buttons. nice...

    The only way I find to avoid the error is to turn Warnings OFF at the start of the charting routine and NEVER turn it back on. Not a good-feeling solution.

    I made certain that none of my names had any errors in them. Everything looks proper. So what next?

    I fear something will create an error for me now along the lines of Murphy's Law, so I really would like to find it and knock it out before it bites me!!!

    Thanks!

  2. #2
    Registered User
    Join Date
    07-28-2014
    Location
    Milton Keynes
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Warning of "invalid references"

    Only a sample workbook will help really... can you upload one? Go advanced then use the paperclip icon

  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
    615

    Re: Warning of "invalid references"

    I have got to learn how to sterilize these darned things; I build them around actual data, and that data is almost all PI and PII; VERY frustrating when I know I need to provide an example but I have to figure out how not to creak confidentiality...

    I will work on it; I can't ignore the fact that good people like yourself ar out there to help me and this is the one barrier tripping me up.

+ 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. I keep getting an error message: "A formula contains invalid references."
    By Schnauf in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2013, 11:54 AM
  2. Replies: 1
    Last Post: 10-23-2013, 05:20 PM
  3. [SOLVED] get rid of "A formula in this worksheet contains one or more invalid references"
    By Thecyclist in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2013, 11:26 AM
  4. "A formula in this worksheet contains one or more invalid references"
    By Canuckle777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2013, 12:19 PM
  5. [SOLVED] " invalid cell references.
    By Carbob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2006, 10:35 PM

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