Re: #value in excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

I think I've seen this before that the value is too large for the column in
the pivot table.
I could be wrong.
Have you tried the MDX sample app to see what it displays from the same
machine as you are running the Excel?

David

"Tarpan" <tarpan@xxxxxxxxx> wrote in message
news:1113921671.935215.101970@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Is the actual value "#VALUE" or is that just what is being displayed?
> If the latter, what is the actual value of the cell?
>


.

Relevant Pages

  • Re: Excel 2003 view formula within pivot table
    ... I don't know of anyway to show what the actual formula for a cell ... Anyway a Pivot table is a builtin generated report. ... My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Formating Cells in Excel
    ... "David" wrote: ... > Can I format a cell to automatically show a value in red if the value is a ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Extracting data from pivot tables
    ... I am creating a chart using data from various pivot tables. ... the pivot table cell that I want. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Formula Help
    ... btw - in my ... a subtotal or pivot table would not have worked as I ... David ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Address Function
    ... I'm trying to return the address of a cell in the format "A1" but the code ... David ... Prev by Date: ...
    (microsoft.public.excel.programming)