+ Reply to Thread
Results 1 to 2 of 2

I keep getting an error message: "A formula contains invalid references."

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Connecticut
    MS-Off Ver
    Excel 2003
    Posts
    1

    I keep getting an error message: "A formula contains invalid references."

    So the issue is that this error message keeps popping up, but there isn't an error. I've run into it before so I have a general idea of why it occurs. The problem this time is I have the formulas in question isolated. I have 20 named ranges that I am using to dynamically fill multiple charts on an ongoing basis. Essentially, I don't want to have to select a new range every time I update the chart. The named ranges are fine and the charts using them are fine. I get the error message randomly whether it be creating a new pivot table in the same workbook or even opening another excel workbook. Once the error pops up, the data in the charts has disappeared, but the named ranges are still intact. The references within the charts are still there, but the data just isn't showing. The weird thing is that if I just save or undo, everything goes back to working perfectly. Wondering if anyone has seen this before/has any idea how to prevent the error message.

  2. #2
    Registered User
    Join Date
    06-14-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Excel 2013
    Posts
    48

    Re: I keep getting an error message: "A formula contains invalid references."

    I can't be sure without seeing the file you're working on but are you including a sheet name in the chart when using the named range?

    E.g. for the chart data range this might work:

    Please Login or Register  to view this content.
    but this might not

    Please Login or Register  to view this content.
    <--- Please click the star to say thank you

+ 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. [SOLVED] Remove "FALSE" error message from this formula please?
    By CatSqueezer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2013, 03:39 PM
  2. [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
  3. "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
  4. [SOLVED] Clear Form results in INCORRECT "Invalid Property" message....
    By B in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2006, 01:30 PM
  5. [SOLVED] Error message "formula is too long"
    By Who be dat? in forum Excel General
    Replies: 2
    Last Post: 03-01-2006, 09:35 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