Hi Guys.
I have a work book with 10 pages, four of which contain pivots.
I have tried RefreshAll command, and this does not work, seems to only refresh the first pivot.
Any ideas, what might be the issue?
Hi Guys.
I have a work book with 10 pages, four of which contain pivots.
I have tried RefreshAll command, and this does not work, seems to only refresh the first pivot.
Any ideas, what might be the issue?
Do they refresh when you do this manually?
Also, are they all running off the same dataset? If so, can you change the source data so that they all work of the same memory table? (this will also free up memory). You can do this by copy/pasting a pivot instead of creating a new one, or by manually editing the source data. Once done, updating the source data once will automatically update everything.
Remember: it is the second mouse that gets the cheese.....
1 important isssue is that the thread title doesn't reflect the content of your question. Please read the forum rules ! and adapt the thread title.
I cannot see an edit button to change the title to 'Pivot Refresh' :-( apologies. I will take the forum rules on board going forward.
Werafa, its different data per pivot.
you can edit a message in 5 hours only.
PLS DO NOT PM; OPEN A THREAD INSTEAD!!!
1) Posting Code
[CODE]PasteYourCodeHere[/CODE]
(or paste your code, select it, click # button)
2) Uploading File(s)
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) (multiple files can be selected while holding Ctrl key) / Upload Files / Done
Replace company specific / sensitive / confidential data. Include so many rows and sheets etc in the uploaded workbook to enable the helpers visualize the data and table structure. Helpers do not need the entire workbook.
3) Testing the Codes
always back up your files before testing the codes.
4) Marking the Thread as Solved
from Thread Tools (on the top right corner, above the first message)
K.
then what happens when you refresh the pivots manually? do they update when refreshed individually?
I have on occasion used a 'with each pivottable in workbook' approach to step through them individually.
and I have had instances where data formatting has broken the VBA creation of a pivot table.
Remember: it is the second mouse that gets the cheese.....