Found the solution by testing and using Excel help, thank you very though 2011/4/7 Jorge Marques <leote.w...@gmail.com>
> Hi guys i did a pivot table with a macro where i have to put the info each > month, in order to the pivot to refresh i did Ctrl + T to "table" the pivot > with headers in order when i put info it puts the new data, when i do fill > again the dynamic stops at row 128 when it should stop in 155, and if i run > it again it gives the error as you can see from cells, As you can see i have > a lot of if formulas and vlookups, if anyone has any sugestion to lighten > the excel i appreciate, i annex the excels in order to feel free to use if > gives any use! :), the source file is source monthly and destination the > report. > > Fil the excel a little to test, a 1000 thanks :) > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel