+ Reply to Thread
Results 1 to 3 of 3

Does anyone know how to find a chart that has #ref errors?

  1. 11-03-2015, 06:32 AM #1
    davidx
    davidx is offline
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Does anyone know how to find a chart that has #ref errors?

    I have hundreds of charts in my file, and I have clearly deleted a row which one of the charts linked to... which causes the Excel file to always shout at me that there is a reference error every five minutes but I dont know how to find which chart has the problem without searching through the source data of hundreds of charts...

    Does anyone have any better ideas?

    Thanks very much,
    Reply With QuoteRegister To Reply
  2. 11-03-2015, 06:56 AM #2
    Special-K
    Special-K is online now
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Does anyone know how to find a chart that has #ref errors?

    Can't you go temporarily load your original chart from your backup and read the line from there?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 11-03-2015, 09:28 AM #3
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Does anyone know how to find a chart that has #ref errors?

    Try the FindLink addin
    http://www.oaltd.co.uk/MVP/Default.htm
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Hiding #DIV/0 errors in Chart
    By milliemoo in forum Excel General
    Replies: 11
    Last Post: 06-07-2022, 05:58 AM
  2. [SOLVED] Pivot Chart Sum Errors
    By Mike-H in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-17-2013, 08:40 AM
  3. How to ignore errors in a bar chart
    By titanium in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-29-2010, 12:43 PM
  4. Ignoring Errors in Chart
    By Hoffhines in forum Excel General
    Replies: 7
    Last Post: 05-09-2008, 10:02 AM
  5. Errors with per Week Chart
    By JohnA in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-11-2006, 01:25 PM
  6. Stopping errors when a find statement doesn't find!
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2006, 10:23 AM
  7. chart errors
    By Rich in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-05-2005, 08:05 AM
  8. Chart Errors
    By Scaccia in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-16-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1