+ Reply to Thread
Results 1 to 7 of 7

weird firewall error when I tried to post a formula

  1. #1
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    weird firewall error when I tried to post a formula

    I am unable to post the formula that is in cell D3. It does not matter whether or not I place the formula between FORMULA or CODE tags.


    ??? I got an weird firewall error when I tried to post the formula in cell D3 of attachment ???

    Access Denied - Sucuri Website Firewall
    If you are the site owner (or you manage this site), please whitelist your IP or if you think this block is an error please open a support ticket and make sure to include the block details (displayed in the box below), so we can assist you in troubleshooting the issue.

    Block details:
    Your IP: 82.174.42.250
    URL: http://www.excelforum.com/editpost.p...post&p=5932968
    Your Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36 Edg/122.0.0.0
    Block ID: SQLi17
    Block reason: SQL injection was detected and blocked.
    Time: 2024-03-22 03:30:08
    Server ID: 19015
    Attached Files Attached Files
    Last edited by AliGW; 03-22-2024 at 04:12 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,353

    Re: weird firewall error when I tried to post a formula

    I think we are going to have issues with formulae containing the forward slash, as Sucuri sees it as part of a URL - I am reporting this to the tech team now.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,353

    Re: weird firewall error when I tried to post a formula

    It seems to be the word REPLACE when used as a part of a formula - I have passed this on to the tech team.

  4. #4
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: weird firewall error when I tried to post a formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you place spaces around REPLACE in the formula, the formula can be posted.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,353

    Re: weird firewall error when I tried to post a formula

    Yes, correct.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,657

    Re: weird firewall error when I tried to post a formula

    It's not just the slash. Maybe
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,353

    Re: weird firewall error when I tried to post a formula

    The tech team is on it - there is a whole bunch of reserved words that are going to cause this issue until they are able to fix it (we've had the problem before, a couple of years back). It's going to cause a lot of frustration, so we hope they'll get on top of it soon.

+ 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. Formula.Firewall in Power Query
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-16-2020, 07:27 AM
  2. [SOLVED] IF formula weird error
    By Teddi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2018, 07:00 AM
  3. Sucri website firewall blocks new post
    By Jeff Haas in forum Suggestions for Improvement
    Replies: 0
    Last Post: 02-13-2018, 09:27 PM
  4. [SOLVED] test post firewall blocking
    By effendrew in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-11-2017, 11:13 AM
  5. [SOLVED] ExcelForum Firewall is blocking my formula?
    By Speshul in forum Suggestions for Improvement
    Replies: 6
    Last Post: 03-27-2017, 05:55 PM
  6. [SOLVED] SUCURI Firewall - Unable to Answer Post?
    By AliGW in forum The Water Cooler
    Replies: 4
    Last Post: 04-12-2016, 06:28 AM
  7. [SOLVED] Issue - Posted Five Links In Post - Added in Forum Firewall Automatically
    By :) Sixthsense :) in forum Suggestions for Improvement
    Replies: 13
    Last Post: 04-04-2014, 05:31 AM

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