Forum Discussion
DATA REFRESH CONNECTION NO LONGER WORKING
I have a continuing document in excel that I work on daily. I am trying to refresh my pivot table and when I hit Refresh All the data that I would like updated and refreshed is not working. I hope I am asking my quetion correctly. Thank you.
Hello evandern
Your message is possibly in the wrong thread, space and community. You should ask this question at the Excel community in the appropriate space. First check if anyone else has experienced the same problem you have. If not, then start a new conversation.
However, one thing you can check is your data source of the Pivot Table. For example, if the data source is from A1 to D100 and you add more information below row 100, the refresh will not work because the data is excluded from your pivot table data source. Just check the options in the ribbon while you are active in the Pivot Table, one of them should refer to the data souce, check that and expand it if necessary.
Next time you can ask your question in the Excel community. :-)