help on pivot, if possible??
 

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..

help on pivot, if possible??
 

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..

help on pivot, if possible??
 

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..

help on pivot, if possible??
 

This can only be done if the data source is external.

"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..

help on pivot, if possible??
 

thanks anyway
--
*****
birds of the same feather flock together..



"Nick Lyttle" wrote:

This can only be done if the data source is external.

"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..