Yes but isn´t that available only to office2010? i use office2007 at work i think it´s retro compatible but only in view form right?
Anyway, i have to do a different way now, they decided they what 3 separate files, a database for each report, and my problems now are different, i´m dealing with problems like, not overwriting the data when i put a new month into to pivot, put the month in a certain cell( I use =year(today()) for year, but doing it with month, gives me a stupid error, don´t know why), I have to ask help again, but only when i have my database defined!my ideia now is merging files selecting the file directly(like whem i close a month, i open database, choose month to update and it merges only certain cells to certain cells of the pivot starting from the first blank cell of the pivot ir order not to overwrite files!) i tried it with recording macro, and changing formulas, but it turned out to be a total mess. :) 2011/3/27 Susan <sunni...@gmail.com> > You could try Power Pivot to merge and sort your various files into one > pivot table or chart. > > > > ~Susan > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Jorge Marques > *Sent:* Thursday, March 10, 2011 5:02 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Help on a simple question > > > > I have a doubt dear friends, i have 3 reports i receive each month, so > every month i have to to an overall report of the 3 like a database, but the > format of the data isn´t equal and doesn´t allow to do a pivot table, my > idea was to create 3 pivotreports (by putting in pivot format and linking > them to the original) each with the 12 months and in the final workbook i > can see all information, my difficulty is how when i receive the monthly > report i send the data to the pivot table created for that report to the > respective month, each pivot table has 10.000 lines, if i put each monthly > report in a separate folder and link them tom the pivot, will it be ok?. > > > > Thank you very much, > > Best Regards, > > Jorge Marques > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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
