![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com