View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
tmagdy tmagdy is offline
external usenet poster
 
Posts: 1
Default How to get data from pivot table with multiple column fields?


I believe you will have to add single quotes to the fields that hav
more than 1 word. e.g. "'Field 1' 'Field 2'

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com