Hi Every Body,
I need code to refresh pivot table data when i move between sheets
thanks
Sayed
Hi Every Body,
I need code to refresh pivot table data when i move between sheets
thanks
Sayed
This would go through all sheets and if there is a pivot table on the sheet it would be refreshed.
Please Login or Register to view this content.
Last edited by Avinash Beepath; 12-15-2010 at 04:33 PM. Reason: Explanation
Dear Mr Avinash,
Many Thanks for your reply . but i tried this code and Data not Updated
thanks sayed
Are you updating your datasource range before running this code?
If you want the code to run automatically as you move between sheets you can use either a workbook level Workbook_SheetActivate event or just for specific sheet(s) a worksheet level Worksheet_Activate event to kick the code off.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks