can you make 1 pivot table using 2 spreadsheets?
R Roger Govier Oct 17, 2006 #3 Hi Yes you can, but the results may appear a little different to what you might expect. Take a look at Debra Dalgleish's site for more information http://www.contextures.com/xlPivot08.html
Hi Yes you can, but the results may appear a little different to what you might expect. Take a look at Debra Dalgleish's site for more information http://www.contextures.com/xlPivot08.html
