Excel 2007 Not Working With Jet 2009

Put your best Excel related tips and tricks here.
Forum rules
This is the place to put all of your Excel Tips & Tricks.
Posts: 3
Joined: Thu Nov 26, 2009 5:37 pm

Excel 2007 Not Working With Jet 2009

Postby mathewlow » Thu Jun 10, 2010 10:00 am

I have just recently upgraded my Excel from 2003 to 2007. Now when I try to set up or run any Jet reports I receive an overflow error message & I cannot use Jet at all.

I have upgraded to version 9.2.10131.0 today but this has not fixed my issue. I appears to be a jet issue rather than an excel issue.

Please help.


Allan Fischer
Posts: 1
Joined: Tue May 19, 2009 12:16 am

Re: Excel 2007 Not Working With Jet 2009

Postby Allan Fischer » Thu Aug 19, 2010 2:00 am

Have you tried changing the date? My dates was originally 010110..310110. My reports didnt work with Jet 2009? I then changed it to 01.01.10...31.01.10, and now all reports works -again.

Hope it helps.

BR, Allan

User avatar
Posts: 248
Joined: Thu Jan 31, 2008 9:01 am

Re: Excel 2007 Not Working With Jet 2009

Postby pdxsam » Thu Oct 14, 2010 4:18 pm

Hi Matthew,

If it is still not working, I would highly recommend submitting a support request at http://support.jetreports.com. Jet Reports 2010 is also now available!

Best Regards,

Posts: 19
Joined: Tue Sep 10, 2013 4:00 am

Re: Excel 2007 Not Working With Jet 2009

Postby Kemad06 » Mon Oct 07, 2013 5:57 am

Hi guys,

I am just borrowing this topic since it is relevant for me, instead of making a new :)

I have a client who is about to upgrade to Office 2013 instead of an old version. At the same time they naturally want the newest version of JET installed, so they can use the table builder etc.

is there anything in particular I need to be wary of here? Or do I just need to download the newest version of JET, install, put their license file in the JET folder and activate!?

Best regards
Kenneth Madsen

User avatar
Posts: 1457
Joined: Fri Dec 14, 2007 4:43 pm

Re: Excel 2007 Not Working With Jet 2009

Postby fhilton » Mon Oct 07, 2013 8:56 am


Since this topic related to a problem someone had in Jet 2009 with Excel 2007 and you're asking about upgrade requirements for Excel 2013 and Jet 2013, I don't think this is actually relevant to what you're asking. In future, please create a new topic for a question like this.

Jet licensing has changed in Jet 2013 to an activation type model, so there are no longer Jet license files to put on client machines. Instead, the client will get an activation code which they will need to use to activate Jet. Also, if they are upgrading from Excel 2007 or earlier, they will have a choice in Excel 2013 to use either 32-bit or 64-bit Excel (before Excel 2010, there was only 32-bit Excel). Which one they choose depends on their reporting needs. Whichever one they choose, they will have to install the corresponding version of Jet (there are 32-bit and 64-bit versions of Jet which correspond to the Excel version NOT the Windows version).

If they use a lot of very large reports which can run out of memory, I would recommend 64-bit Excel since it can address a lot more system memory. However, you should know that if they are using a NAV data source for NAV 2009 R2 or earlier, 64-bit Excel will cause Jet reporting to run a bit slower. So if they do not have many very large reports, especially if they are using NAV 2009 R2 or earlier, I would recommend they install 32-bit Excel.

Hopefully this clarifies things a bit. If you run into problems upgrading them and need more specific help, I would recommend creating a ticket with Jet Reports Support.


Return to “Excel Tips & Tricks”

Who is online

Users browsing this forum: No registered users and 2 guests