I'm not a huge expert on Excel so I'm not sure how this can be done.
I'm posting it in the CRM Group as thats where the issue is arising:
When a user runs a custom report, the report adds a header and a
footer. When they print it, each page of the report is printed with
the header and footer. this is fine, thats what they asked for and
thats what they get.
Now, when a user exports to Excel so they can use the data, the Header
and footer are also exported and the data scrolls in between them. I
can't seem to figure out how to make all of the information export to
a single excel sheet without the scrolling. I removed the header and
footer from the report but it still scrolls ...
Any ideas?