Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |