View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ramzi ramzi is offline
external usenet poster
 
Posts: 24
Default data in formula and how to use pivot table

Dear All,

My data in formula . How i'm going to use pivot table b'cos pivot table
doesn't recognize my value (results form formula) , he only take as a formula.

e.g.
=[purchase_entry.xls]sale!$B893 and the results is Jan

the pivot table cannot recognise the particular cell as Jan.