web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / FRx 6.0 exporting to e...
Microsoft Dynamics GP (Archived)

FRx 6.0 exporting to excel

(0) ShareShare
ReportReport
Posted on by getcarter 100

this might be a bit of a long shot but... I've come across an old system using FRx 6.0 and Excel 2000, which was working fine. They then upgraded Office to 2010 and now FRx is unable to export the reports to Excel (using Excel via OLE) - no errors, it just can't create the file. It can export a flat file but not a file with multiple worksheets. I put this down to either some security setting in Excel or the versions simply not being compatible. Can anyone say for definite if this is a compatibility issue?

thanks

*This post is locked for comments

I have the same question (0)
  • Josh P Profile Picture
    Josh P 2,895 on at

    32-bit to 64-bit conversion probably the culprit. Unfortunately, this is not just an FRx issue. I came across the same problem with Management Reporter trying to use the Outlook connector between 32 and 64 bit setups. Management Reporter does not have a 32-bit option that I know of, but you may be able to get around the problem by trying the Office 32-bit version of 2010.

    Regards,

    Joshua Pelkola

  • getcarter Profile Picture
    getcarter 100 on at

    hi, thanks for the reply. Unfortunately both Office and Windows (XP) are the 32-bit versions so I don't think that this is the issue

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Do you have the old install media for Excel 2000? I believe you can have both versions installed at the same time.I would try to install the old version or upgrade FRx 6.0 to FRx 6.7 SP12. Make sure you export out the entire spec set before doing anything. That way you can import them back if they fail to upgrade. What version of GP are they using?

  • getcarter Profile Picture
    getcarter 100 on at

    Thanks Richard, I think I will try installing Excel 2000 alongside 2010 and see if that works.

    (its gp 10)

  • Keith Vogt Profile Picture
    Keith Vogt on at

    Hello,

    Thanks for the good input from the community!

    Are there any errors in the Event Viewer?

    FRx 6.0 hasn't been supported for several years, so it's likely something with the incompatible versions with Office / Excel. I'd agree that using an older version of Excel may be the best route... or upgrading to FRx 6.7 as suggested earlier.

  • getcarter Profile Picture
    getcarter 100 on at

    thanks for the good advice, everyone.  I did check Event Viewer but there are no errors in there relating to this. I'll update the thread when it gets resolved

    thanks

  • getcarter Profile Picture
    getcarter 100 on at

    ok, as expected reverting back to the older version of Excel has resolved the problem.

    thanks for the advice

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans