I'm working in excel 2013 for windows. I've set up a pivot table that works well. I now need to import the raw data that feeds the pivot table with updated information that has a different number of rows. I can't seem to find where I can update the data source.
Any pointers?
If you click on the pivot table, and then at the top click analyze->change data source. If you want it to change automatically, you'll need to use a dynamic range. If you google that, there are lots of tutorials on it.
1. Include a sample workbook with an example of the result you want
2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks