Hi Everyone,
I am using the camera tool to automatically update pivots for country specific data which are kept in their own sheets (USA, Canada, Mexico, Brazil are all in separate sheets). When the monthly data feed is updated, the pivot tables expand and grow in size (rows). The camera tool cuts off the pivot table due to the static range that its referenced to. I would like to set the camera tool range in each sheet to update and expand as the pivot table grows and more rows are added.
I know this requires setting a dynamic range name with offset and I would like to only capture the pivot from the header to the last row. I am still fairly new with camera tool and dynamic range names, especially when pivots are involved. Any help would be appreciated.
Im using excel 2010.
thanks
I am using the camera tool to automatically update pivots for country specific data which are kept in their own sheets (USA, Canada, Mexico, Brazil are all in separate sheets). When the monthly data feed is updated, the pivot tables expand and grow in size (rows). The camera tool cuts off the pivot table due to the static range that its referenced to. I would like to set the camera tool range in each sheet to update and expand as the pivot table grows and more rows are added.
I know this requires setting a dynamic range name with offset and I would like to only capture the pivot from the header to the last row. I am still fairly new with camera tool and dynamic range names, especially when pivots are involved. Any help would be appreciated.
Im using excel 2010.
thanks
