+ Reply to Thread
Results 1 to 7 of 7

ExcelForum Firewall is blocking my formula?

  1. #1
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,213

    ExcelForum Firewall is blocking my formula?

    this is a test to see if i can post on this thread, another on i'm working on keeps redirecting me to a firewall block with "HTML Content not allowed"
    Last edited by Speshul; 03-27-2017 at 02:47 PM. Reason: better title
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,213

    Re: firewall blocked

    Interesting. apparently what I'm trying to post is causing the error? It does it here too. There's nothing out of the ordinary about it, and i took out all the Bold/Italic/Color codes on the whole post. It's just a choose/vlookup/date manipulation formula

  3. #3
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,213

    Re: firewall blocked

    Looks like it's the formula itself, I can't comment if i include the formula I used to solve the problem someone was having.

    It's a simple VLOOKUP/CHOOSE with date manipulation with a nested array {}'s in the Vlookup (2c 5r size), and is being blocked by the firewall at XF?

  4. #4
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,213

    Re: firewall blocked

    {"COM",1;"Multi-COM",2;"Monthly",3;"Semi-Annual",4;"Annual",5}


    weird. that's the only non-completely-normal part of the formula.

    all other formulas nested are: choose, text, vlookup, if, day, month, year, today


    thoughts? Is there an admin around I can email the formula to directly to take a look at what might be causing it? I can't send it in a PM on here either... admins only...I'd be emailing from work so i'd prefer not to email some random person ;D
    Last edited by Speshul; 03-27-2017 at 02:03 PM.

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,322

    Re: ExcelForum Firewall is blocking my formula?

    I had that problem last week with a "less than" symbol in a formula. I separated it from the preceding and following characters with an extra space and it posted ok.
    Ben Van Johnson

  6. #6
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,213

    Re: ExcelForum Firewall is blocking my formula?

    I do have a less-than in the formula....


    =CHOOSE(TEXT(VLOOKUP(F2,{"COM",1;"Multi-COM",2;"Monthly",3;"Semi-Annual",4;"Annual",5},2,0),"0"),H2,TEXT(IF(DAY(TODAY())<15,DATE(YEAR(TODAY()),MONTH(TODAY()),15),DATE(YEAR(TODAY()),MONTH(TODAY())+1,15)),"m/d/yyyy"),H2,IF(H2_<_TODAY(),DATE(YEAR(H2),MONTH(H2)+6,DAY(H2)),H2),H2)




    Yay! Thanks!


    Interestingly, I only had to change one of them? :o
    Last edited by Speshul; 03-27-2017 at 02:49 PM.

  7. #7
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    ExcelForum (Sucuri ) Firewall is blocking my formula? - HTML Wonk < Poo :(

    Hi Speshul, ( Hi Ben )
    Quote Originally Posted by Speshul View Post
    ....Interestingly, I only had to change one of them?? :o
    There is a few things that that kick in the firewall. The less than sign followed by at least 4 characters ( but not all characters ) is the most common one.
    So like these will not post *anywhere
    <_TOD__<TODA __<TODAYJKG
    But these are OK
    <15,D __ <1,5, __ <TOD __ < hsgfjhgfg __ <T ODAYDGD __ <TOD AY __ <[ODA __ <[ODAYGJHG __ <TOD[
    ( In the first three , ( <_TOD__<TODA __<TODAYJKG ) , to get them to post I use another workaround – the “black character trick”. For details of that and other similar problems and work a rounds see the links below. The usually applied workaround is to add a space after the < ___ < bfdg )
    *Posting in different Sub Forums and things like wrapping in code tags usually make no difference for most of these things.
    _.....
    Alan


    Previous Threads and Posts on this and similar stuff showing the differen problems and solutions ( work a rounds ):
    The first few show the < followed by at least 4 characters ( not all characters ) problem, and work arounds
    http://www.excelforum.com/developmen...ml#post4295092
    http://www.excelforum.com/the-water-...ml#post4283991
    http://www.excelforum.com/suggestion...ml#post4412541
    https://www.excelforum.com/the-water...ml#post4591609
    http://www.excelforum.com/showthread...41#post4412541
    http://www.excelforum.com/the-water-...ml#post4226385
    http://www.excelforum.com/suggestion...-a-thread.html
    http://www.excelforum.com/showthread...t=#post4520072
    http://www.excelforum.com/showthread...t=#post4502342
    Last edited by Doc.AElstein; 04-10-2017 at 03:11 PM. Reason: The ability to Edit is good, to perfect the answer. It needs to be used responsibly. ... Good Morning
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] test post firewall blocking
    By effendrew in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-11-2017, 11:13 AM
  2. Why am I getting a Sucuri Firewall block with this code?
    By delaing in forum Suggestions for Improvement
    Replies: 12
    Last Post: 04-10-2017, 08:02 AM
  3. [SOLVED] My IP Blocked by EF Firewall
    By :) Sixthsense :) in forum Suggestions for Improvement
    Replies: 3
    Last Post: 08-01-2014, 02:01 AM
  4. [SOLVED] Check if port open through firewall
    By swoop99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2012, 07:59 AM
  5. Need help with an Excel function for a Juniper firewall
    By Charon_ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2009, 08:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1