Limited help from err message
 

Hi all,

got little help from an error message that I gather (from google) is pretty
ra

External Data Source Failed to Connect.

it happens when I execute this line for the *second* time:

oChart.SetData cChartConstants.chDimCategories, 0, "a2:" & LastRow

It binds the specified constant to a specific set of cells on oChart.

My guess is that the problem stems from rebinding.... but I need to somehow
alter the range of data bound... and I can't figure out how to do this, and
also avoid re-executing the SetData method on chDimCategories in the event
that they are already bound (I guess I need to devise a test).


This is all in relation to Office Web Controls, in case that matters.

Thanks again for your generous help...

Mike