Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
I have a pivot and I need to refresh data every same time, but I haven't to
select the refresh every check box, because it's hide |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
Not sure if you want it to refresh every time you open the workbook or not.
If so, right click on the pivot table, select "Table Options", then select "Refresh on Open" "Hamido Azab" wrote: I have a pivot and I need to refresh data every same time, but I haven't to select the refresh every check box, because it's hide |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
The Refresh Every x Minutes option is only available when the pivot
table is based on external data. If your pivot table is based on a table in Excel, you can refresh the pivot table manually, or use programming to refresh it when the data changes. Hamido Azab wrote: I have a pivot and I need to refresh data every same time, but I haven't to select the refresh every check box, because it's hide -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |