I've searched the forum for this issue but could not find a topic about it, I can't image that I am the only one with this annoying behaviour:
Sometimes when I load a report (.xlsx) directly by double clicking the file it opens the report but not the Jet Reports tab within Excel. (other users have it more frequently)
I first thought the Jet add-in was disabled but it's not.
De-activate/activate Jet Reports only helps for a short period of time or does not help at all, after a reboot the same thing happens all over again.
However, if I first open Excel with a new empty workbook/worksheet and then open the report things are looking better, the Jet tab shows up.
This is applicable on Jet 7 and Jet 2009 (currently testing Jet 2011, so I don't know if it has the same issue)
Is there anybody else who has encountered the same issue?
Date
Votes
11 comments
-
Jet Reports Historic Posts http://community.jetreports.com/viewtopic.php?f=6&t=1610
My reported problem with dissappearing Jet tab. I find it more useful to open excel first and then open an excel file using excel's menu. Moreover, sometimes when I double-click an excel file when excel is not open, I occasionaly get a message "could not load file" or something like that.
I'm using latest Jet Essentials build. -
Jet Reports Historic Posts Thanks for the other topic Jackies, however I'm not reading any fixes for my particular problem.
Opening Excel first and then the report is not always an option because we open files directly using SharePoint and other DMS.
I'm not using multiple data sources in my reports either.
If there aren't very much people who encounter this I'll have to open a Jet Ticket I guess, but my first thought was: let's try the community first :)
I'll wait for some more replies before opening a ticket though. -
Jet Reports Historic Posts Hi,
I think I've seen this before when opening Excel files from non-trusted locations or files that were downloaded from the internet. Generally you get the little security warning right under the Excel address bar with an option to "Enable content" or something like that. Sometimes there are several security things to click through before it re-enables everything. Some people don't notice the Excel warning and thus the Jet add-in does not get enabled. Possibly something like this is happening to you when you open the files from SharePoint?
Regards,
Hughes -
Jet Reports Historic Posts Hughes, that sounds plausible, but if that was the case then it should happen all the time.
I have an installation where the person can open the same document 3 times within one minute from sharepoint and he gets: 1 - jet tab not loaded, 2 - jet tab loaded, 3 - jet tab not loaded. (he's on jet2009 btw)
It's not consistent, wich why it is hard to troubleshoot, besides it's not always with files from SharePoint, it also happens with files from the desktop etc.
Looks like it's completely random, yes or no jet tab.
I'm planning to upgrade the whole company to Jet 2011 soon, wich seems to load the jet tab just fine, but until that time it would be nice to fix this issue, or at least know the cause. -
Jet Reports Historic Posts Hmmm, I would love to know the cause to that myself. I've never heard of it randomly not appearing like that. I'll be interested to know if installing Jet 2011 actually fixes it. I'm not sure how that could possibly fix the problem, but then again I'm not sure what the real cause is. If I were to guess, I'd say it's Excel itself being flaky and "losing" the Jet add-in. Some people experience this when using the Jet Scheduler: periodically Excel will just lose its reference to the Jet add-in so reports will come back with all #VALUEs. In that case, the problem is not related to Jet itself; it could happen to any add-in. It's a bug in Excel itself.
Regards,
Hughes -
Jet Reports Historic Posts I tried to open an excel file and got the messages attached.
Using latest Jet Essentials build with Excel 2007 -
Jet Reports Historic Posts Jackies,
Please don't hijack someone else's topic by posting something like this as a reply when it has nothing to do with the original topic. You should post something like this as a new topic. Actually in this case, you should create a ticket with Jet Reports Support and have them look at the problem since it is an unexpected error message. The community site is more for questions on how to create reports and how to use Jet.
Regards,
Hughes -
Jet Reports Historic Posts Sorry… :oops:
-
Jet Reports Historic Posts For what its worth, we have several users who routinely experience this bug using Jet 2011. We're currently on Version 11.1.11322.0.
I've seen it on most of the various versions I've run over the past few years. I have no idea what causes it. It happens sporadically, and on files opened from the desktop, outlook, or shared server.
I wish there was a permanent solution instead of disabling and enabling the add-in. -
Jet Reports Historic Posts Glad to hear there are other people with the same issue, I just installed Jet Essentials 11.1.11356.0 on a virtual machine and the same old issue appears.
Opening an Excel file directly from the harddisk and no Jet tab appears, when starting excel (empty worksheet, without any file loaded) no problems, Jet tab appears!
I'm currently using Office 2007 SP2, will soon upgrade to Office 2010, let's hope it helps. -
Jet Reports Historic Posts I had the same issue with a user, and found that if i add both the folder locations of where the add-in (jetreports.xlam) is located as well as the folder location of where the jet reports are stored (usually network share) into the 'trusted locations' within excel, it sovled the problem. See steps below;
Default location for jet reports add-in (jetreports.xlam) is in either one of the below folders, depending on whether the user has a 64-bit machine or not. (#2 is for 64-bit machine, #1 is for regular machines)
1. C:\program files\JetReports
2. C:\program files (x86)\Jet reports
Steps to add above location in excel’s ‘trusted location’
1. Open Excel
2. Click on ‘File’
3. Click on ‘Options’
4. Click on ‘Trust Center’
5. Click on ‘Trust Center Settings’ (on right hand side)
6. In the new dialog box that opens, click on ‘Trusted Locations’ on the left
7. Click on ‘Add new location’ button at the bottom
8. Enter the appropriate path (from above)
9. Click ‘Ok’ – until you are back to your work book.
Please sign in to leave a comment.