Hi,


If I setup a data table as follows:

A1=0
A2=0
A3=A1+A2


Then in B3 place the formulae A3+1 and copy it along to K3
And in A4 place the formulae A3+1 and copy it down to A13
Finishing off by selecting the range A3:K13 and
choosing Data->Table, Row input cell = A1, Column Input cell = A2
The results in the intersection start from 2 and end at 1.7E+11


Now if I Edit->Copy, PasteValues the formulae in cells B3:K3, and likewise
value the
formulae in A4:A13 the results change twice over, once for each
Copy-PasteValues
sequence.

What's going on ?


Regards


Steve

Think the intersection cell in the data table
cannot be the same cell as the intended output

Try the "Data > Table" set-up this way

With the output cell in A3
> A3: =A1+A2

Put in say, B4: =A3 (a simple point to A3)
List the horiz and vertical figs: 1-10 in C4:L4 / B5:B14,
Select B4:L14, click Data > Table,
Point the row/col inputs at: A1/A2 > OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steven" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
>
> If I setup a data table as follows:
>
> A1=0
> A2=0
> A3=A1+A2
>
>
> Then in B3 place the formulae A3+1 and copy it along to K3
> And in A4 place the formulae A3+1 and copy it down to A13
> Finishing off by selecting the range A3:K13 and
> choosing Data->Table, Row input cell = A1, Column Input cell = A2
> The results in the intersection start from 2 and end at 1.7E+11
>
>
> Now if I Edit->Copy, PasteValues the formulae in cells B3:K3, and likewise
> value the
> formulae in A4:A13 the results change twice over, once for each
> Copy-PasteValues
> sequence.
>
> What's going on ?
>
>
> Regards
>
>
> Steve
>