When I export an order to excell, it won't open automatically

[Former Member]

When exporting from SAP to excel gives me the option to save the file, but after saving it does not open automatically.

I go to the folder where you saved the file and open it manually.

How I can fix this? so that when exporting to excel document is opened automatically.

Follow these steps did not work:

- AutoOpen It replaced the one that worked.

- Added permission to the folder ExcelDocs the Terminal server and also added to the file permissions autoOpen.Xls

- He entered the terminal with the user network administrator.

- SAP was run as administrator

- We verified the macros, you can: Disable all macros with notification

- The path is correct in SAP:

\ \ SERVER NAME \ b1_shr \ sap business one \ ExcelDocs

- They lowered the security level of the computer and reboot.

- We are working with the root of the database.

[alfax20]

Having the same issue at a client.  When you hit the Excel export button, you get the option to save rather than excel opening automatically.  However PDF does open automatically.

[former_member325312]

Hi Johannys Ceballos

This is one of the Disadvantage we are having with Sap B1 .When you export a query or Order it will not open directly .So We need to Open It Manually as there is no Other chance.

Regards

Jenny

[KennedyT21]

Hi Johannys Ceballos

To remedy this problem you should deselect the following :
"Ignore Other Applications" and "Protection from Macro Viruses" options in the Excel program.

For Microsoft Office 2000
in order to de-select the tick-box "Ignore Other Application" :

1. 1. On your desktop go To: "Start -> Programs -> Microsoft Office -> Microsof Excel
2. 2. In Excel go to:"Tools –> Options –> General" Tab.
3. De-select the tick-box "Ignore Other Applications"

In order to de-select the "Portection from Macro Viruses"

1. In Excel go to:"Tools -> Macro -> Security"

2. Set the security level to "Medium".

For Microsoft Office97:

1. 1. In Excel go to: "Tools –> Options –> General" tab.
2. 2. De-select the tick-box "Protection from Macro Viruses".

Also refer

http://scn.sap.com/docs/DOC-41572

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

Please check with below SAP notes:

542663 - Excel AutoOpen exported file does not open
automatically

Hope helpful.

Thanks & Regards,

Nagarajan