I recorded a macro to create a pivot table. Everything is ok if the data file has the same number of lines as the original files. If the data files has less lines, the pivot table returns incorrect info. Every time the data file updated, It has different numbers of lines. How could record a macro to overcome this issue?
Post the code so we can see what you have presently (remember to encase within CODE tags)
I can't determine if you're constantly creating new Pivots or you want to resize an existing Pivot - either way you can do what you want but we need to better understand the process.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks