Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
The named item cannot be displayed RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    When I activate a dynamic filter in my dashboard, one of the 4 Excel reports displays an error:

    "The named item cannot be displayed.

    The named item is either not available in the workbook or was not selected as a named item for viewing when the workbook was published. The named item may be located in a hidden range of cells or in a collapsed outline".

    NB: I checked that this named item is available (the Excel pivot table lost this Parameter several times before, but now it is there). Some others Excel reports in the same dashboard have the same layout, and they display well.

    Any ideas?

    Thanks


    • Edited by WLID1966 Friday, June 29, 2012 12:59 PM
    Friday, June 29, 2012 12:54 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Prasanna,

    The 4 Excel reports are built from the same source: OLAP Cube.

    Today, when I started the machines, every report was working fine... I don't understand what could disturb them before.

    Thanks

    • Marked as answer by WLID1966 Tuesday, July 3, 2012 8:03 AM
    Tuesday, July 3, 2012 8:03 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Is the report built from a different source (for example: 3 from OLAP Cube, and 1 from Templates?)

    Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com

    Friday, June 29, 2012 6:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Prasanna,

    The 4 Excel reports are built from the same source: OLAP Cube.

    Today, when I started the machines, every report was working fine... I don't understand what could disturb them before.

    Thanks

    • Marked as answer by WLID1966 Tuesday, July 3, 2012 8:03 AM
    Tuesday, July 3, 2012 8:03 AM