In Excel 2002-2003 it was possible to use the FUNCTION CREATE.TABLE(A1;B1) to
make a pivot table based on the 2 inputvalues ex. A1 and B1.
The result on A1 and B1 was displayed in the pivot table based on the tabels
row and column headers.

Now this function sems gone in Excel2007 and I can't find any new way to
make the pivot table on the same facts

Allt the help functions talk about is how to make a pivottable based on
tables, not on just 2 inputvalues and the result of that !!

Please help me ... getting pretty desperat here !!!

--
regards
Patrik S -swe-

Hi Patrik

That was not the method of creating a Pivot Table in any version of
Excel.

What you are looking for is the facility from XL2003 found under
DataTable
This can be found in XL2007 on the Data TabWhat If Analysis 3rd item
Data Table

--
Regards

Roger Govier


"Patrik S" wrote in message
...
In Excel 2002-2003 it was possible to use the FUNCTION
CREATE.TABLE(A1;B1) to
make a pivot table based on the 2 inputvalues ex. A1 and B1.
The result on A1 and B1 was displayed in the pivot table based on the
tabels
row and column headers.

Now this function sems gone in Excel2007 and I can't find any new way
to
make the pivot table on the same facts

Allt the help functions talk about is how to make a pivottable based
on
tables, not on just 2 inputvalues and the result of that !!

Please help me ... getting pretty desperat here !!!

--
regards
Patrik S -swe-

Hey ... many thanks Roger ... this solved everything.

--
regards
Patrik S -swe-


"Roger Govier" skrev:

Hi Patrik

That was not the method of creating a Pivot Table in any version of
Excel.

What you are looking for is the facility from XL2003 found under
DataTable
This can be found in XL2007 on the Data TabWhat If Analysis 3rd item
Data Table

--
Regards

Roger Govier


"Patrik S" wrote in message
...
In Excel 2002-2003 it was possible to use the FUNCTION
CREATE.TABLE(A1;B1) to
make a pivot table based on the 2 inputvalues ex. A1 and B1.
The result on A1 and B1 was displayed in the pivot table based on the
tabels
row and column headers.

Now this function sems gone in Excel2007 and I can't find any new way
to
make the pivot table on the same facts

Allt the help functions talk about is how to make a pivottable based
on
tables, not on just 2 inputvalues and the result of that !!

Please help me ... getting pretty desperat here !!!

--
regards
Patrik S -swe-