How to refresh data analysis tool results

S

stips2

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?
[email protected]
 
B

Bernard Liengme

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
 
S

stips2

Ah ha! That will work. Thank you.
Sue

Bernard Liengme said:
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
Click to expand...
 
Top