none
The named item cannot be displayed RRS feed

  • Question

  • 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

  • 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

  • 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
    Moderator
  • 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