GO OFFICE Excel Issue: some pages grayed out and wont import

[WPM-CTMA]

Hello,
      First timer here, was scouring the boards looking for the answer to my question but I'm not seeing anyone else with similar problems as me.  I am a Cognos 8 user, writing and editing reports for the most part.  My boss recently introduced me to the Go Office aspect of it where you can import parts of a report into excel.  This could be very helpful to me, as I have a report I run many pages analyzing different departments cycle times.  The data is then referenced on a few main tabs that summarize and compare the data over time against goals.
      So the problem happens when I try to import content from my report.  My report has I believe 14 pages, each has a simple list tied to a different query.  When I go to import the data, for some reason, a number of my pages appear grayed out and un-checked.  If I click twice, I can get a check mark there, but then when I finish, any of those grayed out pages do not have data imported, but those that show up in dark text with a checkmark, they import just fine.
     I have read that trying to import report pages with prompts often doesn't work, but I dont have any prompts.  My pages are all quite similar, and some of the smaller ones (not many columns in the list) are those that I cannot import.  Can't find any reason anywhere for this to happen so if you have any input please give me it.

thanks in advance for any help
Wes

[MFGF]

Hello,
      First timer here, was scouring the boards looking for the answer to my question but I'm not seeing anyone else with similar problems as me.  I am a Cognos 8 user, writing and editing reports for the most part.  My boss recently introduced me to the Go Office aspect of it where you can import parts of a report into excel.  This could be very helpful to me, as I have a report I run many pages analyzing different departments cycle times.  The data is then referenced on a few main tabs that summarize and compare the data over time against goals.
      So the problem happens when I try to import content from my report.  My report has I believe 14 pages, each has a simple list tied to a different query.  When I go to import the data, for some reason, a number of my pages appear grayed out and un-checked.  If I click twice, I can get a check mark there, but then when I finish, any of those grayed out pages do not have data imported, but those that show up in dark text with a checkmark, they import just fine.
     I have read that trying to import report pages with prompts often doesn't work, but I dont have any prompts.  My pages are all quite similar, and some of the smaller ones (not many columns in the list) are those that I cannot import.  Can't find any reason anywhere for this to happen so if you have any input please give me it.

thanks in advance for any help
Wes

Hmmm - interesting. In theory any reporting object (list/crosstab/chart/map etc) tied to a query should be recognised as an object that is available for import. Is there anything common to the pages that are greyed out - eg are the objects embedded in tables or blocks perhaps? I can't honestly say I've seen this issue before. Does the version of Cognos for MS Office you are using match the version of Cognos BI installed on your server?

MF.

[WPM-CTMA]

Felt I should chime in, problem was solved, basically some of my lists were named "list1" "list7", etc. and others were not.  I could use the lists that were named but not those that weren't.

I have no idea how they got named, since I don't believe I named any, let alone some and not others, but basically you need to name the list for it to be used in Go Office, weird rule

[MFGF]

Felt I should chime in, problem was solved, basically some of my lists were named "list1" "list7", etc. and others were not.  I could use the lists that were named but not those that weren't.

I have no idea how they got named, since I don't believe I named any, let alone some and not others, but basically you need to name the list for it to be used in Go Office, weird rule

I thought objects like lists were automatically named when using a standard template to create a report? I suspect either someone removed the names, or else you have a customised template somewhere that contains an un-named list object? But yes - objects need a name to be used in GO Office (and in Cognos Workspace in Cognos 10).

Thanks for the update.

Cheers!

MF.