Thank you. You may laugh at the Microsoft post. but it was exactly what I needed to solve my issue.

Now I know it is a bug in 2007, I can program around it. It was killing me that when I edited a the data series & changed it to an identical value the error went away.

SO now I can modify the chart to point to a range I'm not deleting. Then delete the rows the chart was using. Then point the chart back to its original position.
& Bingo 1 workaround.

(I'm unsure if this is fixed in Excel 2010, but as I want my app to work on 2003, 2007 & 2010 it doesn't really matter.

Thanks again

On Tuesday, July 08, 2008 2:06 AM Mark Stephens wrote:

Hi,

Every now and then my worekbook throws up a dialogue box with the following
warning message:

'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'


Short of ploughing through every page and searching every cell containing
formula, does anyone know an easier way of locating the culprit formula?

Thanks and regards, Mark


On Tuesday, July 08, 2008 5:19 AM Peter T wrote:

I would start by looking for whatever is the most likely cause of that
message.

Eg, if invalid cell references are suspect, search (ie Edit Find) cells
containing #REF! with "Look in: Formulas" checked. After sorting out those
repeat with "Look in: Values" That error occurs when a cell ref is entirely
deleted with delete rows/columns, or a sheet is deleted. Range names can be
similarly affected.

Regards,
Peter T


"Mark Stephens" wrote in message
...
following


On Tuesday, July 08, 2008 5:37 AM Mark Stephens wrote:

Thanks Peter, unfortunately did not come up with anything, any other ideas?

regards, Mark


On Tuesday, July 08, 2008 6:25 AM Peter T wrote:

So you are saying there are no #REF! errors in cell references or in Defined
Names.

Any broken links perhaps. Look in Edit / Links

Regards,
Peter T

those
and
containing
formula?


On Tuesday, July 08, 2008 8:43 AM Charli wrote:

Try This

Sub FindBadCells()

Dim Sheet As Worksheet
Dim Cell As Range

For Each Sheet In ThisWorkbook.Worksheets
For Each Cell In Sheet.UsedRange
If IsError(Cell) Then MsgBox Sheet.Name & ", " & Cell.Address(0, 0)
Next Cell
Next Sheet

End Sub


"Mark Stephens" wrote:


On Tuesday, July 08, 2008 9:26 AM Mark Stephens wrote:

Thanks Charlie, got them all very efficiently, thankuverymuch, kind regards,
Mark:)


On Tuesday, July 08, 2008 9:48 AM Peter T wrote:

Curiosity, when you say "got them all" what sort of error cells did you find
that was triggering your message.

FWIW you could use the SpecialCells to find error cells, manually or
programmatically.

Regards,
Peter T


"Mark Stephens" wrote in message
...
regards,
and
containing
formula?


On Tuesday, July 08, 2008 9:59 AM Mark Stephens wrote:

Hi Charlie,

They were links to a workbook I deleted and all resided in the same kind of
sheets in the same place, but because they were out on a limb (column 35 or
something, I couldn't begin to locate them manually, thanks again, regards,
Mark


"Peter T" <peter_t@discussions wrote in message
...


On Tuesday, July 15, 2008 3:26 PM sam anco wrote:

Hows this for a Microsoft answer!

SYMPTOMS
When you delete an item from a table that is bound to a chart in
Microsoft Office Excel 2007, you may receive the following error
message:
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.
After you correct the references that are not valid in the table, you
may continue to receive this error message.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products
that are listed in the "Applies to" section.

------------------------------------------------------------------------
--------

APPLIES TO
? Microsoft Office Excel 2007

Back to the top

Keywords: kberrmsg kbtshoot kbchart kbprb kbexpertisebeginner KB931389


Todate they have no solution, if anyone can fix this then I would be
grateful




*** Sent via Developersdex http://www.developersdex.com ***


On Monday, September 22, 2008 8:31 AM BarbReinhard wrote:

I'm seeing this problem when I run a macro which copies data from the
workbook but so far, am unable to reproduce it. I should be able to figure
out which worksheet/s are affected, but how do I get it to show up again.
Select the rows and copy? It's not clear from your last response.

Thanks,
Barb Reinhardt




"richardp" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Assemblies in Folder Debug Build Checker
http://www.eggheadcafe.com/tutorials...d-checker.aspx