SAP Library - Find your answers

Thanks a lot. I was struggling for a solution for quite sometime.
On Wed, Jul 29, 2009 at 6:04 PM, Melissa Ocepek via sap-acct <
sap-acct@groups.ittoolbox.com> wrote:
>
>
> Hi raghavendra,
> When you go into EXCEL view, you need to click on the TOOLS and then on
> Options. Once there, click on the security Tab and click on Macro Security.
> Make sure your security level is either Medium or Low and then click on
> Trusted Publishers Tab and make sure that Trust Access to Visual Basic
> Project is checked.
> Once you have done this, run your report again and when you click on the
> excel button, you should see your information. The problem that I am having
> is that I do not get all the lines of the report in this view. Let me know
> if you figure out how to fix this.
> Thanks
> Melissa Ocepek
> Manager of Financial Analysis
> YourTravelBiz.com, Inc.
> 1901 E. Edwardsville
> Wood River, IL 62095
> ' 618-216-4647 7 618-216-4747
> * mocepek@ytb.com<mailto:mocepek@ytb.com>
> P please don't print this e-mail unless it's really necessary!
> The information contained in this e-mail message is intended only for the
> personal and confidential use of the recipient(s) named above. If the reader
> of this message is not the intended recipient or an agent responsible for
> delivering it to the intended recipient, you are hereby notified that you
> have received this message and any attachments in error and that any review,
> dissemination, distribution, copying or alteration of this message and/or
> its attachments is strictly prohibited. If you have received this message in
> error, please notify the sender immediately by electronic mail, and delete
> the original message.
> ________________________________
> From: USER_1620233 via sap-acct [mailto:sap-acct@Groups.ITtoolbox.com]
> Sent: Tuesday, July 28, 2009 10:51 PM
> To: Melissa Ocepek
> Subject: Re: [sap-acct] Report RFBILA00 not showing all report lines when
> in EXCEL view.
> [http://userimages.toolbox.com/user/b_1593555.jpg]
> HI
> Thanks a lot Melissa. In my case when I click on the excel button the view
> gets changed to EXCEL with several sheets open. But all the sheets will be
> blank. Can you help me where I need to change settings to get the data in
> EXCEL view.
> regds
> raghavendra
> On Tue, Jul 28, 2009 at 8:08 PM, Melissa Ocepek via sap-acct <
> sap-acct@groups.ittoolbox.com> wrote:
> >
> >
> > Dear gurus,
> > We are using report RFBILA00 for our TB. It works great. If we run the
> > report with ALV grid control as our list output, it looks great on
> screen.
> > We then click on the EXCEl button and it puts the report in EXCEL but
> only
> > includes through line 689 when the report is actually 780 lines long. We
> can
> > export the report to excel and get the whole report but that does not
> > include the header information. We would like to be able to get the
> header
> > information included to help with the different versions of the TB that
> we
> > do on a quarterly basis. If anyone can tell me the settings I need to
> look
> > at in order to get all 780 lines to show in the EXCEL view, I would
> greatly
> > appreciate it. I have tried searching the site and could not find an
> answer.
> > I have already changed the macro security settings but that is not quite
> > enough.
> > Thank you for your time.
> > Melissa __.____._