View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ted Urban[_2_] Ted Urban[_2_] is offline
external usenet poster
 
Posts: 1
Default Tying to extract all data from a pivot pulling from external d

I tried formatting the souce data as text and as number and got the smae
result either the number or alphanumeric dropped off and left me with a blank
pivot field with the total value for all records that were dropped under that
"blank" pivot field...Thanks

"Frank Pytel" wrote:

Are you formatting the columns or the pivot table results as text. Seems like
if the columns are formatted as text, it should treat them as entitys instead
of combining or dropping them.

God Bless

Frank Pytel

"Ted Urban" wrote:

I am trying to pull all values through a pivot referencing an external data
source (another excel sheet). The problem I have it the column has order
numbers that are both numberic and alphanumeric. (some are 123456 and others
are AB654321). When I get the pivot only the numerical records appear and
the alphanumeric records are left blank and I get a subtotal. This goes both
ways depending if I format as a number or as text...Any suggestions