+ Reply to Thread
Results 1 to 2 of 2

Exotic Bug: Spreadsheet deletes cell content, doesn't refresh calculations

  1. #1
    Registered User
    Join Date
    08-13-2019
    Location
    Austria
    MS-Off Ver
    Office 365
    Posts
    1

    Exotic Bug: Spreadsheet deletes cell content, doesn't refresh calculations

    This is a weird one. I built this worksheet myself from the ground up. It is based on a series of SUMIFS-formulas, but that is largely beside the point.

    Consider worksheet "Input_other".
    - cell D133 used to contain "-25.000". This value somehow got lost. I did not accidentally delete it by tagging more than one worksheet, or by any other means that I am aware of.
    - cell F133 contains a single formula: "=D133/12"
    - since D133 is empty, this should be 0. But it still shows as "-2.083" (which =25.000/12).
    - and the whole spreadsheet calculates based on this false value.

    Manipulations act weirdly, too:
    - set to Manual refresh, and reresh manually (F9) ->Nothing changes
    - refresh D133 (by pressing F2 -> Enter), and the whole worksheet refreshes.
    - refresh F133, and only this cell refreshes, but not cells referring to F133
    - set a filter, and the whole workdsheet refreshes
    - delete or Group a number of rows -> the worksheet refreshes
    - hide rows -> nothing happens

    I was able to reproduce this in a colleagues PC.

    What worries me most is the fact that cell content apparently gets lost for no reason at all. The fact that calculations then don't refresh is weird on top.

    Has anyone seen something like this before? Does anyone know a solution or safeguard?

    Cheers, Ben
    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,495

    Re: Exotic Bug: Spreadsheet deletes cell content, doesn't refresh calculations

    Your workbook/worksheet seems to work OK for me. If I put a value in D133, cell F133 (and the rest) recalculate immediately.
    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


+ 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: 3
    Last Post: 03-20-2018, 03:22 PM
  2. macro deletes content textbox
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2016, 02:22 PM
  3. Worksheet_Change: Not triggered when user deletes a cell's content
    By Klaster in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2014, 01:26 PM
  4. [SOLVED] Highlight a cell if its content doesn't match another cells content
    By noxygen in forum Excel General
    Replies: 4
    Last Post: 04-12-2012, 04:36 AM
  5. Refresh the cell formula calculations using VB
    By vtech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2010, 10:57 AM
  6. [SOLVED] Pivot Table Refresh Deletes Range On Different Sheet
    By TMore in forum Excel General
    Replies: 0
    Last Post: 08-17-2006, 09:00 AM
  7. [SOLVED] Exotic Bets Spreadsheet - Need Help!
    By Kevin in forum Excel General
    Replies: 2
    Last Post: 05-19-2005, 04: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