ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table (https://www.excelbanter.com/excel-programming/407727-pivot-table.html)

Hamido Azab

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

Sean Timmons

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


Debra Dalgleish

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