Hi can anyone help me, my pivots are not refreshing new data entered, im sure its to do with the fact that the formula is div/o due to the fact there is no data on certain dates, but this needs to be the case as they dont work every day
i thought i could go in a select refresh all and all my pivits would update but at the moment i have to go into total effectiveness and tick the new dats to update pivot
i have atttached a small example
Thanks
Hi,
Use the sheet activate event procedure for tab sheet name sheet3 to force an update every time you go to the sheet.
Wrap your column L:M formulae in an =IFERROR() function
Please Login or Register to view this content.
e.g.
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
go to pivot > right click > select pivot table option >go to data tab > select right click on Refresh data.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thank you both for your quick reply
Avk is the easier option so I will go with this
Ty Both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks