Hey Community,
Yet another question. I am currently working on a budgetmodel for my Employer. He wants several prerequisite sheets, so there are a lot of sheets in this workbook, but they are pure Excel code.
Now, on the first sheets i have a NL("rows";"G/L Account") with a few NF lookups. I realise by using the Webservice connection, I am not helping the cause, but my reports have run fine before. But this won't even make my G/L account list. I have a serious hunch that JET checks ALL sheets for code before doing anything. Is there a way to say "ignore this sheet" in JET? So it only checks the first sheet and hopefully runs a bit faster.
It used to work fine, but after I made som 'collected' sheets with a ton references, it constantly breaks :S
All ideas are welcome.
/Kemad
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello -
You are correct. In order for Jet Professional to perform some of its capabilities, it must examine each sheet in a workbook to determine if there are any Jet functions present on those sheets.
Currently, there is no way to tell the Jet add-in to ignore a sheet. (great suggestion, though!) -
Jet Reports Historic Posts Thank you, I think so too.
I have actually written a mail to the Danish JET support office with the same proposal - a possibility to add +Exclude in A1 instead of Auto to exclude the check.
I'm sure with your support in passing it along, it might actually come at some point, if you would do the honours ;)
/Kenneth -
Jet Reports Historic Posts Hi,
Hello -
Currently, there is no way to tell the Jet add-in to ignore a sheet. (great suggestion, though!)
Yes I would second that suggestion.
And if they look into it would be great if they could find a way to tell JR to ignore an Excel workbook at all.
If you work a lot with JR reports on the one hand and Excel sheets mit macros especially with buttons on the sheet on the other hand it may happen quite often you hit the JR refresh button instead of the macro button. If you now save the file at the wrong time the macro file could be damaged because of the move of the content from row 1 and column a from JR.
Perhaps a "ignorewholeworkbook" in A1 in one of the sheets :?:
Cheers,
André
Please sign in to leave a comment.