Hi,
I am sending excel statistics from then the planner to my salespeople. The latter wishes that the file already arrives with the positioned filters and the first row of the fixed table. This not to redo the layout every time, how to do? Because when I click refresh everything is removed.
Thank you
Date
Votes
1 comment
-
Jet Reports Historic Posts For freezing the panes, that can be done in the design mode, just be sure that you freeze the rows that you want to have visible (any hidden rows will still hide and just bump the freeze panes up).
As for setting the filters automatically, there is an option in your Jet Application Settings that will allow a report to run with column filters already in place (under Excel, "always remove Excel AutoFilters"), but that does not seem to produce the best results for me (significantly slowing my report).
I generally freeze the panes in design mode, but wait until after the report runs to set column filters.
If your reports are running from the scheduler, I know the freeze panes will stay in place.
Please sign in to leave a comment.