+ Reply to Thread
Results 1 to 4 of 4

Remove Line Through Uncalculated Cells

Hybrid View

  1. #1
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2505
    Posts
    2,792

    Remove Line Through Uncalculated Cells

    I resorted to setting my Excel defaults to calculate manually several months back due to a large workbook which takes a while to calculate on my slow pc.
    I've noticed now that when I make changes my formula cells now have a strike through line in them until I manually calculate the workbook.
    I don't know how this started but it's new and I can't figure out where to turn this off.
    I'm hoping it's not a new Microsoft feature that can't be bypassed because I find it very annoying.
    Any help would be greatly appreciated.
    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    02-12-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    208

    Re: Remove Line Through Uncalculated Cells

    Have a look here;

    https://answers.microsoft.com/en-us/...3-34bbebbabb2a

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2505
    Posts
    2,792

    Re: Remove Line Through Uncalculated Cells

    That appears to be the issue, I have no idea how that option even got checked.
    Thanks for your help, rep added.

  4. #4
    Forum Contributor
    Join Date
    02-12-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    208

    Re: Remove Line Through Uncalculated Cells

    No problems. Thanks for the feedback/rep.

+ 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. Replies: 4
    Last Post: 10-14-2021, 06:00 PM
  2. Remove Specific Drop Line on a Line Graph
    By dinonuggets01 in forum Excel General
    Replies: 13
    Last Post: 09-13-2019, 06:48 PM
  3. Macro to insert line or remove line depending on cell in column A.
    By cscott109 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2018, 05:02 PM
  4. Replies: 0
    Last Post: 12-14-2018, 08:20 AM
  5. [SOLVED] MultiLine Textbox to auto remove blank line, count line, remove duplicate
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-24-2015, 09:28 PM
  6. Using Max() on uncalculated totals
    By hektisk in forum Excel General
    Replies: 5
    Last Post: 10-26-2011, 12:23 PM
  7. How do I remove repeating line in Excell - Top line on each page..
    By keepon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-23-2005, 08:06 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