Monday, May 13, 2013

Web ADI - Excel 'Run-time error 91' Error

Error: Run-time error '91′
          Object variable or with block variable not set




Probable Solution: We need to alter some Microsoft Excel settings.

Please check your Excel setting with the screenshots attached below and change accordingly.

1>  Open MS Excel
       File > Options > "Trust Center" > "Trust Center Settings..."

A> "Trusted Location"
        >> "Add new location..."
               >> Add a location where you save your Web ADI Templates
                      >> EX: C:\ADI Templates



B> "Trusted Document"


C> "Add-ins"






D> "ActiveX Settings"





E> "Macro Setting"





F> "Protected View"





G> "File Block Setting"



Close all the open Excel sessions and try again, it should work.



2> If this won't resolve the problem, check your Web Browser 'Setting' Options and add your Oracle Application URL as a Trusted/Secured Site.




Posted by at
Labels:

33 comments:

  1. AnonymousSeptember 5, 2013 at 3:31 AM

    This is really awesome, I tried this and it resolved the issue. Thanks for this valuable information.

    ReplyDelete
    Replies
    1. this isMarch 11, 2021 at 10:01 PM

      Great Article IoT Projects for Students

      Deep Learning Projects for Final Year

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. AnonymousOctober 17, 2013 at 1:05 PM

    Very helpful. Solved the entire set of latest problems I was having!

    ReplyDelete
  3. UnknownApril 22, 2014 at 2:55 AM

    Thanks for this informative web page which helps me to fix runtime error 91. I am very happy because now I am free from this problem so again thanks.

    ReplyDelete
  4. AnonymousJuly 29, 2014 at 4:30 AM

    It's perfect time to make some plans for the future and it is time to be happy.
    I'velearn this publish and if I mayy just I wieh to recommend you some attention-grabbing things
    or tips. Maybe yoou caan write subsequent arfticles relating too this article.
    I wish to rad more things approximately it!

    Here is my blog ... need for speed world hack

    ReplyDelete
  5. AnonymousAugust 1, 2014 at 11:45 AM

    Thank you! This was very helpful.

    ReplyDelete
  6. SheshSeptember 25, 2014 at 4:03 PM

    This was awesome... Thank you

    ReplyDelete
  7. AnonymousDecember 15, 2014 at 9:12 PM

    really appreciate the solution. it works. Thank you

    ReplyDelete
  8. AnonymousJanuary 7, 2015 at 1:25 AM

    Very helpful, Thank you very much

    ReplyDelete
  9. Avinash PatelMarch 16, 2015 at 12:27 AM

    Thanks for this post. This has helped me many times - http://MyCityMyChoice.com

    ReplyDelete
  10. AnonymousMarch 25, 2015 at 10:45 PM

    Thank you so much...

    ReplyDelete
  11. AnonymousJune 25, 2015 at 12:33 AM

    saved webadi do not work giving message
    'navCanceColntainer' not defined.
    Kindly suggest the solution.

    ReplyDelete
    Replies
    1. Abhay KumarJune 25, 2015 at 8:22 AM

      Dear Anonymous,

      Please elaborate your issue, what is 'navCanceColntainer' ?

      Delete
  12. UnknownFebruary 11, 2016 at 12:27 AM

    Thank you. This resolved my issue.

    ReplyDelete
  13. UnknownDecember 5, 2016 at 8:41 AM

    Resolved my issue. Very good information. thank you

    ReplyDelete
  14. UnknownDecember 8, 2016 at 1:20 AM

    It works. THanks

    ReplyDelete
  15. TuralMay 14, 2018 at 5:00 AM

    it works. Thanks.

    ReplyDelete
  16. UnknownJune 11, 2018 at 3:47 AM

    Thank you very much!

    ReplyDelete
  17. AnonymousOctober 11, 2019 at 9:39 AM

    thank you. Solved mine too.

    ReplyDelete
  18. senthilJanuary 20, 2020 at 9:04 AM

    thank u

    ReplyDelete
  19. AnonymousFebruary 10, 2020 at 11:30 PM

    it works but the datas are not downloaded. comes as 0 document downloaded and automatically gets closed.

    ReplyDelete
  20. AnonymousFebruary 10, 2020 at 11:47 PM

    it works but the datas are not downloaded. comes as 0 document downloaded and automatically gets closed.

    ReplyDelete
  21. muthuganesanFebruary 20, 2020 at 9:41 AM

    'navCanceColntainer'

    ReplyDelete
  22. UnknownMarch 17, 2020 at 11:39 PM

    Thank you very much. It works.

    ReplyDelete
  23. HarshaApril 21, 2020 at 5:24 AM

    This article has fixed my issue 100%%%%%%%%%%%%

    ReplyDelete
  24. LameaApril 30, 2020 at 9:43 AM

    It really worked, i tried today...Thanks a ton for the detailed information dear...God bless u...

    ReplyDelete
  25. Ravi PasapulaSeptember 18, 2020 at 10:57 AM

    Thank you. This worked

    ReplyDelete
  26. wnDecember 1, 2020 at 4:32 AM

    My spouse and I love your blog and find almost all of your posts to be just what I’m looking for. Appreciating the persistence you put into your blog and the detailed information you provide. I found another one blog like you Oracle Cloud Infrastructure .Actually I was looking for the same information on internet for Oracle Cloud Infrastructure and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  27. BillcarsonDecember 10, 2020 at 10:46 PM

    My spouse and I love your blog and find almost all of your posts to be just what I’m looking for. Appreciating the persistence you put into your blog and the detailed information you provide. I found another one blog like you Oracle ADF.Actually I was looking for the same information on internet for Oracle Application Development Framework and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  28. HarshaDecember 16, 2020 at 4:28 AM

    Superrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr

    ReplyDelete
  29. AnonymousApril 23, 2021 at 5:43 PM

    On behalf of all malicious Excel files, we thank you for basically removing any and all security Excel has to protect users.

    ReplyDelete
  30. bloger001June 16, 2021 at 12:37 AM

    Super!!!!
    Thanks for this post it helped me fix my vba runtime error.

    ReplyDelete
  31. William C. CoombesNovember 3, 2021 at 10:17 AM

    This fixed the issue for us. Many thanks.

    ReplyDelete

Subscribe to: Post Comments (Atom)