I have a lot of year end cycle time statistics (by Region, by Market, by
Vendor, etc.) that I need to produce in a short turn around time. I would
like to set up my spreadsheets in advance with using the Data Analysis Tool.
Once set up, I would like to introduce the final data dump, massage the data
a bit and then cause my statistics to refresh. Is this at all possible? If
so, how?

The results from the Data Analysis tools are static - carved in stone once
generated!.
All of them can be generated using formulas which are dynamic - refresh as
the data is changed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"stips2" wrote in message
...
I have a lot of year end cycle time statistics (by Region, by Market, by
Vendor, etc.) that I need to produce in a short turn around time. I would
like to set up my spreadsheets in advance with using the Data Analysis
Tool.
Once set up, I would like to introduce the final data dump, massage the
data
a bit and then cause my statistics to refresh. Is this at all possible? If
so, how?

Ah ha! That will work. Thank you.
Sue

"Bernard Liengme" wrote:

The results from the Data Analysis tools are static - carved in stone once
generated!.
All of them can be generated using formulas which are dynamic - refresh as
the data is changed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"stips2" wrote in message
...
I have a lot of year end cycle time statistics (by Region, by Market, by
Vendor, etc.) that I need to produce in a short turn around time. I would
like to set up my spreadsheets in advance with using the Data Analysis
Tool.
Once set up, I would like to introduce the final data dump, massage the
data
a bit and then cause my statistics to refresh. Is this at all possible? If
so, how?