I have written a report which has hidden rows in it, when sub-totalinng/totaling the values in all rows on the report I have used the sub total 109 function which ignores hidden values.
I would like now to take my values from the report in to a pivot table in excel & also ignore the hidden rows/values but can't get this to work. The pivot table then looks at the data in the jet report & can be refreshed each time the jet report is run to update the pivot table.
Any help advice is appriciated.
Date
Votes
2 comments
-
Jet Reports Historic Posts Not sure if this will be useful, but you can copy the rows including the hidden rows then use the paste special and "Skip Blanks"
-
Jet Reports Historic Posts Hi GavWood,
I guess my question would be, why are you hiding rows and is there a possibility that you can get the same data without hiding any rows (perhaps with Link= functionality or something like that)? If you can explain what you are hiding, then maybe those rows can just be filtered out in the Jet functions rather than hidden.
Regards,
Hughes
Please sign in to leave a comment.