+ Reply to Thread
Results 1 to 4 of 4

Formula suddenly stopped working

  1. #1
    Forum Contributor keith740's Avatar
    Join Date
    04-24-2015
    Location
    Racine, Ohio
    MS-Off Ver
    MS365
    Posts
    241

    Formula suddenly stopped working

    Column H ( I think column I,J,etc is not functioning as well), sheet "WV Taxes"... this has worked for years and suddenly it is not... any help is greatly appreciated!
    Attached Files Attached Files

  2. #2
    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
    44,428

    Re: Formula suddenly stopped working

    When open the file, it says there are circular references.

    See: https://www.ablebits.com/office-addi...ference-excel/
    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


  3. #3
    Forum Contributor keith740's Avatar
    Join Date
    04-24-2015
    Location
    Racine, Ohio
    MS-Off Ver
    MS365
    Posts
    241

    Re: Formula suddenly stopped working

    I have went to the formulas tab>error checking... circular reference is not highlighted for me to click...

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Formula suddenly stopped working

    I believe that the problem is in column A of the Sales Tax WV sheet.
    Paste the following into cell A3 and then copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    To test change the date in cell C8 on the Revenue sheet to 7/18/22.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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 (INDIRECT & Array) suddenly stopped working
    By FrankieG in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-14-2021, 08:29 AM
  2. [SOLVED] Array formula suddenly stopped working
    By stock11r in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-09-2016, 06:13 PM
  3. [SOLVED] Formula Suddenly Stopped Working?
    By nesbensen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2015, 02:28 PM
  4. [SOLVED] Vlookup function suddenly stopped working!!!!!
    By danmack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2013, 10:39 AM
  5. Replies: 3
    Last Post: 05-03-2013, 02:05 PM
  6. Code suddenly stopped working
    By bibleguy125 in forum Excel General
    Replies: 1
    Last Post: 02-15-2012, 01:00 PM
  7. Beforeclose sub suddenly stopped working
    By cuewoz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2010, 12:29 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