Quick Question

I have a workbook that is basically made up of 2 worksheets, a importing data sheet and a chart. Everything works great, timely refreshes and its rather simple. The problem I have is this: The chart is basically a seating chart and does not change at all(static). The 2nd worksheet continuosly updates the chart and will sometimes add new values(dynamic). Well, my formulas that I have for each cell points to the dynamic sheet and the values will change on occasion, unpredictablely. How can I write the formulas pointing to certain values in the data sheet(dynamic) and lock the cells. Then any new data populated in the data sheet will just go under the locked data which will not affect my cell references for the chart. If this is really unclear I can try again. Thank in advance!!!

Hmmm...not very clear. Are you using dynamic named ranges? something
like this?

Series1 = Offset($A$1,0,0,counta($A:$A),1)

I think you need to expand on 'lock the cells'. Do you mean a static
range which never changes?

I'm sure we can help but try to rewrite this bit...

How can I write the formulas pointing to certain
values <--do yu mean staic cells or a given value that might appear
anywhere?

in the data sheet(dynamic) and lock the cells <-what do you mean?
.. Then any new data
populated in the data sheet will just go under the locked data which
will not affect my cell references for the chart.

O