Hi thanks for the reply
i am using Excel 2003 Sp2, i open up the pivot table options yet the refresh
[tick box] __every minutes" is dimmed, dont know how to activate it...
please reply if u have more suggestions
-- dribler2 the driller
*****
birds of the same feather flock together..



"Nick Lyttle" wrote:

Hi,

Depending on version you are running and if you are linking from source
outside one workbook there is an option in the Pivot Table Options to choose
time frame for auto -refresh down to 1 minute, not quite what you want but
may offer some functionality.

"dribler2" wrote:

Hello,
i need to make an AUTOmatic Refresh of all my Pivot tables and all my charts
located in one active workbook.

i need , if possible to set such as an imbedded action when i change a value
of a single cell address [CHOOSE!A1]

thanks in advance
driller
--
*****
birds of the same feather flock together..