LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Sumproduct Formula with Pivot Table Data Rose Excel Worksheet Functions 4 September 9th 08 09:18 PM
How to convert OLAP data (PIVOT Table) to formula Apinya Excel Discussion (Misc queries) 0 July 5th 07 03:40 AM
Get Pivot Table Data Formula Wozzle Excel Discussion (Misc queries) 2 September 12th 05 10:35 AM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Need Formula to display pivot table source data Don S Excel Worksheet Functions 3 February 23rd 05 10:13 PM


All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"