Hi Everyone!
I have a pivot table that is a rolling 6 weeks of how many people me and my colleague hire weekly. When I press refresh all the page refreshes but the data does not change. I have attached a picture. I am a amateur when it comes to Excel so please bare with me. I wanted to be able to refresh weekly(I know I have to manually refresh it) When I press refresh(both ways, by right clicking inside the table and by using the pivottable analyze refresh all) it does not give me an error, it just wont refresh.
I have a pivot table that is a rolling 6 weeks of how many people me and my colleague hire weekly. When I press refresh all the page refreshes but the data does not change. I have attached a picture. I am a amateur when it comes to Excel so please bare with me. I wanted to be able to refresh weekly(I know I have to manually refresh it) When I press refresh(both ways, by right clicking inside the table and by using the pivottable analyze refresh all) it does not give me an error, it just wont refresh.