Hi All:
I have done a jet report and a pivot table based on it (two different Excel sheets in the same file) but I only would like to email the pivot table (in PDF or Excel) without the data sheet thru Jet Scheduler daily. However, the scheduler emails everything, including the data, filter, pivot table Excel sheets, though, again, I only need to distribute the pivot table. How could I do that? I am on Nav 2009, Jet Essentials 2012 R2, Excel 2010.
Thank you
Date
Votes
2 comments
-
Jet Reports Historic Posts By their very nature - Pivot Tables require a connection to the background data - so I don't think that the scheduler can disconnect that for you.
Now for your filter sheet, you can make that go away by putting +HIDESHEET at the end of the commands in cell A1 for that sheet.
So A1 would read something like AUTO+HIDE+HIDESHEET
HIDESHEET does exactly what it sounds like, it hides the sheet, and when the scheduler runs the hidden sheet is removed
I suggest that your data sheet use AUTO+HIDE+VALUES in cell A1
VALUES makes sure that your data is converted to VALUES and does not leave any JET formulas in that area.
One caution - if you have any non-jet formulas referencing anything on a tab that you have put HIDESHEET on - such as =FILTER!C4 - you need to change that to an NP("EVAL" formula like this: =NP("EVAL",""=FILTER!C4") -
Jet Reports Historic Posts Heather, thank you very much. I will try.
Please sign in to leave a comment.