nishpearl123
Board Regular
- Joined
- Jun 14, 2010
- Messages
- 96
Hi,
I have used several pivot based on one data range.
Suddenly, i have found that i am unable to refresh any of the pivots. All pivot are in different sheet & none of pivot in any of the sheet is getting refreshed.
It gives the message "a pivot cannot overlap another pivot table". I have tried deleting rows surrounding the pivotm but didn't help.
Kindly help.
Regards,
ni****h
I have used several pivot based on one data range.
Suddenly, i have found that i am unable to refresh any of the pivots. All pivot are in different sheet & none of pivot in any of the sheet is getting refreshed.
It gives the message "a pivot cannot overlap another pivot table". I have tried deleting rows surrounding the pivotm but didn't help.
Kindly help.
Regards,
ni****h