title: Pivot table from multiple spreadsheets
body: <p>I am using excel 2010.  I am trying to create pivot table between two worksheets 'Summary' and 'Summary2'. I have identical row of data ranging from cells B5 to F5 in row 5 in both worksheets. Data in the two worksheets looks like this:</p>
  
  <p>Summary worksheet: Issues,20,3,4,5
  Summary2 worksheet: Issues,10,0,3,9</p>
  
  <p>Worksheet referes to issues from location 1 and worksheet referes to issues from location 2. Col B has title 'issues', Col C refers to issues of customer 1, Col D refers to issues of  customer 2, Col E refers to issues of  customer 3, Col F refers to issues of customer 4</p>
  
  <p>I go to a third worksheet and start pivot table and in the table range I give this: 'Summary:Summary2'!$B$5:$F$5. Then I Say OK. Gives error "data reference source is not valid". Can someone tell me how to select the row from two different worksheet in pivot table?</p>
  
  <p>Also I want to be able to add issues of customers between two locations and get % completion for each locaiton.</p>
  
  <p>Can someone please help?</p>