I queried 3 identically laid out files from a folder with PQ; 3 FY GL files. No exotic formulae used in PQ other than =Excel.Workbook([Contents]) and only using the grand totals generated by the pivot table created from the data model; no added formulae. The folder queried only has the three files in it and no sub folders.
Pivot table has three columns with grand totals underneath; all double what they should be.
I am using Excel 2010 64bit with PQ installed and Windows 7.
Thank you,
ernie johnson
Pivot table has three columns with grand totals underneath; all double what they should be.
I am using Excel 2010 64bit with PQ installed and Windows 7.
Thank you,
ernie johnson