Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Location
    Montreal, Canada
    Posts
    4

    Unhappy Unanswered: Impromptu export to Excel limit

    I had a major crash on a Win2000 PC with Cognos 6.0.371.0 R99A Impromptu installed, had to re-install Win2000 and all apps.

    Before the crash, I was able to export 41000+records to be Excel 97, now I get the records cut off at 16384.

    I am aware of the work arounds to this, i.e. (csv not so good as addresses often contain commas) or export in DB and re-import in Excel, etc, but I must perform this operation very often.

    Is there a .ini file or any info in the registry file that can be modified to accept 65536 records as in past.

    The only thing I think was done different on this re-install was Cognos Impromptu was installed BEFORE Excel97.

    Any ideas on a fix.

    TKS, BrianJ

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You have put this in the wrong forum, please move to

    http://www.dbforums.com/forumdisplay.php?f=243
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Aug 2006
    Location
    Montreal, Canada
    Posts
    4
    I am not sure it is an Excel issue.

    It is an impromptu issue. I do not even need excel installed.

    I was sucessful, without Excel installed prior to this, I simply saved on server in Excel format and open on pc which has Excel installed.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >It is an impromptu issue.
    Ok, but this is an Oracle forum; not a Cognos or Impromptu forum; so why are you posting here, again?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •