Pivot table from outlook

[Luc]

Hi

In excell when we do a pivot table we are ask to choose the data.

How can we link a pivot table so it will take is data fron a outlook folder.

Right now i Highlight my task in outlook and copy them to excell then i make
a pivot table.

I would like to remove the copy/paste create pivot table.

By linking a pivot table so it will automaticly get is data from a outlook
folder, this will save me time and will ensure me that data are uptodate

 

[Milly Staples [MVP - Outlook]]

I don't think that is possible since Outlook data is in a different format
than other Office programs.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Luc asked:

| Hi
|
| In excell when we do a pivot table we are ask to choose the data.
|
| How can we link a pivot table so it will take is data fron a outlook
| folder.
|
| Right now i Highlight my task in outlook and copy them to excell then
| i make a pivot table.
|
| I would like to remove the copy/paste create pivot table.
|
| By linking a pivot table so it will automaticly get is data from a
| outlook folder, this will save me time and will ensure me that data
| are uptodate

 

[Luc]

Thank

I was hoping a better answer but may be we will need to wait until Office
V12 is out.....