Hi all,
In a report I placed the following formula to replicate sheets for each month between a start- and enddate:
=NL("Sheets";NP("Dates";$L$10;$L$11;"Month";))
where L10 contains the value 01-10-2012 and L11 contains the value 30-09-2013.
When refreshing the report, for each replicated sheet the following message is shown:
The only external reference is the Jet-addin itself. So I don't understand why these questions/messages appear.
The reports runs on a database using the universal connector and the users on this database are not authorized to use Navision. This is why I am not using the Dates-table in Navision.
Any help is appreciated!
Best regards,
Gerard
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Just to close this issue. The problem was caused by a third party addin. Disabling this addin solved the problem for me.
Thanks to Jet Support for pointing me in the right direction. -
Jet Reports Historic Posts Hi Gerard,
That is very strange behavior. I wouldn't expect the NL(Sheets) function to do this. Can you attach the report itself?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Sorry it took a while to reply!
Please find the report in the attachment.
On sheet "1-10-2012" in cell K12 you can find the sheet-replicator. There are two issues regarding this cell:
- Per replicated sheet the message is shown as mentioned in my first mail
- I would like to change the sheetnames from the first date in the selected period "1-10-2012" to "Oct-2012".
I really hope I made a mistake (should be easier to solve I think). Thanks in advance for your help!!!
Best regards,
Gerard -
Jet Reports Historic Posts Gerard,
So I can't actually replicate the message you're getting. I had to change a few formulas to get the sheets to replicate since I don't have your database, but I don't expect that would make much of a difference with that message. Typically you see that message when you move a report to a new location, either over the internet or to a new network location or something like that. Typically, you just have to just choose not to update links and then save the report afterwards and everything is okay from then on. I'm guessing it could be something to do with Excel security settings as well, although I don't really know that; you might check yours. I'm thinking it's not possible to change the actual sheet names in this case. Sorry I can't be more helpful.
Regards,
Hughes -
Jet Reports Historic Posts Hughes,
Thanks for you reply.
I already tried to not update the links and save the workbook, close it and open it again. Refreshing results in the same message unfortunately.
The Excel security settings are correct.
Perhaps I should create a ticket for Jet Support.
Again, thanks for trying to help me out!
Best regards,
Gerard
Please sign in to leave a comment.