Hello - i'm encountering something weird. when i run one of my reports i built it tells me i have to "update" or "don't update" links to external workbooks. Then when i look at what workbook it's linked to by clicking "edit links" it is a .xlam file in the program files/x86/jet reports folder on my C: drive.
Sometimes i have click update multiple times and it is becoming frustrating for users.
I was wondering if anyone has encountered this issue and knew a workaround.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
The Jet add-in file is located in "C:\Program Files (x86)\JetReports\JetReports.xlam" (or .xla if you are using Excel 2003). The Jet ribbon and all the custom Jet functions in Excel come from that add-in file. So since your workbook contains Jet functions, it contains a link to the Jet add-in file. This is just how Jet works.
Generally, if you are opening and closing reports on the same machine, you wouldn't get the message about updating the add-in file. The only exception might be if you are saving and opening files in a location Excel does not consider "safe" or "trusted". Some network shares might be this way; it depends I think. If you go to your Excel Options to the Trust Center and then Trust Center Settings, there is an option for Trusted Locations that you could try adding network locations to if Excel if having problems with those. There is also an "External Content" area where you can choose "Disable automatic update of workbook links", which may help as well.
Now it changes if you are transferring reports around between users or opening the same file from a network share on different computers. If one user has a 64-bit machine, so the Jet add-in is in C:\Program Files (x86), but another user has a 32-bit machine, so their Jet add-in is in C:\Program Files, then Excel might indicate the need to update the link to the add-in because it's not in the same folder. Also, if a report is downloaded from the internet Excel may mark it as unsafe and so content will have to be enabled the add-in connection may have to be updated before it can be used.
Generally, when Excel prompts you to update the connection to the add-in for whatever reason, you can just click cancel. The connection to the add-in should be automatically updated by Jet itself for the Jet functions, so you don't have to manually browse to the Jet add-in. Hopefully, some of this info helps!
Regards,
Hughes
Please sign in to leave a comment.