Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cannot Export Reports to Word or Excel (2000 SP1a)

    I have a report that I run and then choose "Anaylze it with MS Excel" to have it export the data to a spreadsheet where I can reformat it to a nicer layout.

    Suddenly, this function has stopped working for me. When I click the export toolbar function, I get a dialog box flash on screeen and then disapear, but there is no spreadsheet produced. SImilar thing happens I try the export to Word function. I think what is happening is that whatever controls the export function is not finding any records (although it dsplays and prints fine).

    I've re-installed, tried different stations, I've tried Office 2003 , different reports, queries,tables and even completely new databases. Nothing seems to help.

    I'm at a bit of a loss here, and I would apreciate any suggestions.

    Jim Helfer
    WTW Architects

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    Do you have Office 2003 beta on the same machine? If so, installing that may have stripped the gears on your Office 2000 installation.
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    I'm seeing this poblem on all machines. (we install from an administrative install point on the network).

    Jim

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    That may be the problem. Does the administrative install actually install the wizards? If so, is it possible that the location they used in on a network drive that isn't always available?
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    Charlotte,

    I've made sure that all the wizards are installed (and re-installed) , and besides the problem is still evident in local installations of Office sp3. It seems like no matter how many variables I change, this function (which used to work consistently), just doesn't work.

    <sigh>
    Jim

  6. #6
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    One thing that might be worth a check is that in Excell as not been set to "Ignore other aplications" in options on the General tab.

    HTH

    Peter

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    No, that's not it. Besides, it occurs when I try to export to Word as well. I'm going to apply SP3 to the admin install, and update my workstation install and see if that helps.

    Of course, my assistant already installed a local SP3 version of office, and he still gets the same problem .

    <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15>

    Thanks, though.

    Jim

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    If you have this on two different machines from two different installations, it sounds like a different problem. You never mentioned what operating system you're running. I know I ran into weird problems with A2k on Windows NT with SP4 or lower.
    Charlotte

  9. #9
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    Did you try to use the feature in another application yet and didn't it work there either?
    Just to be sure it's no file corruption issue (or whatever other 'thing' which struck your application).

  10. #10
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot Export Reports to Word or Excel (2000 SP1a)

    Turns out that upgrading the administrative install to SP3, and then upgrading my workstation to Office sP3 solved the problem. Turned out to be another "Microsoft Mysterious Mangled File Issue." No fix, just keep reinstalling closer to the metal until sutff starts to work again.

    <sigh> What a way to run a rodeo.

    Thanks everyone for your help

    Jim Helfer
    Pittsbugh PA

Posting Permissions

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