QUEST4APPS

Excel and IE Setups for Oracle Web ADI

—

by

Arun Raj
in , ,

There are few setups that you have to do on Microsoft Excel and Internet Explorer to work with Oracle Web ADI.

Excel Setups

1. Open Excel and go to File > Options

Navigation_1

You will see a new window as shown below. Select “Trust Center” on the left navigation pane and then click on “Trust Center Settings“:

Navigation_2

Select “Macro Settings” on the left navigation pane. Under Macro Settings, select “Enable all macros” . Under “Developer Macro Settings“, select “Trust access to the VBA project object model“.  See the image below for more details.

Navigation_3

Next step is to navigate to the “Protected View” option on the left navigation pane. once you are there, un-check all the protected view options as show below:

Navigation_4

Click “Ok” and close Excel.

Internet Explorer Setups

Open IE and navigate to IE > Internet Options and select “Security Tab“. Select zone as “Internet” and click on “Custom Level“:

IE_1

Scroll down and then “Enable” the “Allow status bar updates via script” option.

IE_2

Close and Re-Open IE. Go ahead and try to open Web ADI Documents and it should be working fine.

Thanks for reading and if there are other ways to accomplish this, please share your thoughts. Let me know your comments and suggestions.
If you have any questions, you can leave a comment.

Comments

26 responses to “Excel and IE Setups for Oracle Web ADI”

  1. sapan shah Avatar
    sapan shah

    How to do setup in MS Office 2007???

    Reply
    1. ArunRaj Avatar
      ArunRaj

      Hi Saran,

      We no longer use Office 2007. However, I found this link and seems to be useful.
      Hopefully this helps you: http://www.dartmouth.edu/~control/docs/financialrept/excel2007_setup.pdf

      Thanks,
      Arun

      Reply
  2. Iqra Avatar
    Iqra

    Thanks

    Reply
  3. Pradeep Avatar
    Pradeep

    Thanks.. This IE setting helped to resolve my issue

    Reply
    1. ArunRaj Avatar
      ArunRaj

      Hi Pradeep,

      Glad it helped. Have a good weekend ahead.

      Cheers,
      Arun

      Reply
  4. Sunny Solanki Avatar
    Sunny Solanki

    when uploading getting error 424 object reference required. Excel is 2013

    Reply
    1. ArunRaj Avatar
      ArunRaj

      Hi,

      Do you still have this issue?

      Thanks,
      Arun

      Reply
  5. Natalie Avatar
    Natalie

    Hi! I am trying to open my spreadsheet and all of the options in my oracle tab are greyed out. I have all settings set according to these instructions. Any ideas?

    Reply
    1. ArunRaj Avatar
      ArunRaj

      Hi Natalie,

      Did you get it working. Sometimes you will have make changes to the Excel settings. Let me know if you still need help.

      ~Arun

      Reply
  6. KyleF Avatar
    KyleF

    This was working for me at one point, but now in Windows 10 this is no longer the case. The page that usually comes after attempting the download of the Excel sheet appears, but nothing ever downloads. Eventually I get the following message on the screen:

    Your document could not be created.

    Please contact your support representative.

    Any ideas?
    Thanks,
    Kyle

    Reply
    1. ArunRaj Avatar
      ArunRaj

      Hi Kyle,

      Is this fixed?

      Reply
  7. lajkartalsadf Avatar
    lajkartalsadf

    thanks bhai

    Reply
  8. RS Avatar
    RS

    Did you try using Webadi using Office 365 and MAC ? Has anybody found a workaround to use WebADI with MAC ?

    Reply
    1. Arun Raj Avatar
      Arun Raj

      I have not tried it in MAC

      Reply
  9. Jeyakumar TM Avatar
    Jeyakumar TM

    I am getting “The connection to the server is unavailable” while opening the EXCEL WebADI file.

    I am using Windows 7 and Excel 2007.

    Can anyone have the solution to overcome above error and work the EXCEL WenADI file

    Reply
  10. Harihara Murugan Avatar
    Harihara Murugan

    i follow u r instruction, excel file is downloaded but the close window click on it the excel file also close pls help me

    Reply
    1. Arun Raj Avatar
      Arun Raj

      Not clear about the question. Are you saying the excel file is downloaded and when you close the web browser the excel file closes?

      Reply
      1. Joey McDogal Avatar
        Joey McDogal

        Tring to test out wed adi on eam assets using 12.2.9 and i’m using windows 10 and excel 2016 and when I click on create document system opens blank page with nothing there…. can’t seem to find the excel addin as well.. any suggestions?

        Reply
  11. Ramesh Avatar
    Ramesh

    Sir windows 7 os webad1 supprot pannuma

    Reply
    1. Arun Raj Avatar
      Arun Raj

      It should. I don’t use Windows 7 any more so cannot test it.

      Reply
  12. Chaithanya Swaroop Avatar
    Chaithanya Swaroop

    Hi All,

    I have downloaded the excel template using webadi. Excel is blank and getting below message excel.

    tracelevel
    5

    host
    https://xxcustom:4443/OA_HTML/

    viewerxmlservice
    BneViewerXMLService

    applicationservice
    BneApplicationService

    viewerticket
    hAxyOqVK0HO8hcogXM803kUEa6

    viewerparameters

    bne:documentId
    M3XVAO02C1RDE9OAX924M8K78R5MZ9HPL3UQ8QSQ
    WWDX6DIMHYTYKF3S4UJWXUUY04VPA0JZKBJN3E9P

    errormessagebody
    The connection to the server is unavailable.

    errormessageaction
    Please contact your support representative.

    errormessageclose
    Close

    errormessagehead
    Error

    Can you please help to resolve the issue

    Reply
  13. Sivanandham Ponnusamy Avatar
    Sivanandham Ponnusamy

    Hi Arun Raj,

    Good Evening!!!

    This blog helped to resolve the WebADI file download issue but it’s works only once and from next time I am getting like this “2% of WebADI.xls downloaded” and I am trying to download Webadi using Office 365.
    Could you please help me to resolve the issue.

    Regards,
    Sivanandham

    Reply
    1. Sivanandham Ponnusamy Avatar
      Sivanandham Ponnusamy

      FYI.. this is my excel version ( Microsoft Excel for Microsoft 365 MSO(16.013328.20262) 32-bit )

      Reply
  14. velu Avatar
    velu

    This was working for me at one point, but now in Windows 10 this is no longer the case. The page that usually comes after attempting the download of the Excel sheet appears, but nothing ever downloads. Eventually I get the following message on the screen:
    o document created and excel sheet opening hanging

    Please contact your support representative.

    Any ideas?
    Thanks,
    Velu k EX- ……

    Reply
  15. Dhavish Puddoo Avatar
    Dhavish Puddoo

    Hello .Anyone encountering A scripting error while using webadi?

    It is a Member not found error and although it allows navigating up to the point of upload by saying to to the repeated message. The upload never actually completes.

    Will be great if someone can shed some light on this

    Reply
  16. dhamodharan Avatar
    dhamodharan

    vert nice

    Reply

Questions? Comments? Suggestions? Let us know!! Like / Subscribe / Follow for more updates.

Latest Posts

Check out these latest posts that you may be interested in.