Strange text box appeared on all worksheets, and always shows most recent typed data

%3CLINGO-SUB%20id%3D%22lingo-sub-2941124%22%20slang%3D%22en-US%22%3EStrange%20text%20box%20appeared%20on%20all%20worksheets%2C%20and%20always%20shows%20most%20recent%20typed%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2941124%22%20slang%3D%22en-US%22%3E%3CP%3EAn%20Excel%20file%20that%20I%20have%20used%20and%20updated%20for%205%2B%20years%2C%20all%20of%20a%20sudden%20has%20this%20strange%20box%2C%20that%20I%20can%20not%20click%20on%2C%20but%20always%20shows%20the%20most%20recent%20typed%20data%20in%20it.%26nbsp%3B%20It%20is%20across%20all%20my%20worksheets%20in%20this%20book%20(11%20tabs)%2C%20and%20I%20can%20not%20figure%20what%20I%20did%20to%20create%20it.%26nbsp%3B%26nbsp%3B%20I%20have%20tried%20to%20click%2C%20it%20and%20cannot.%26nbsp%3B%20See%20around%20cell%20K17%20the%20%2211%2F01%2F2021%22%20it%20is%20there%20because%20I%20typed%20in%20the%2011%2F1%20in%20cell%20F3.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Lisap5_0-1636410230285.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325362iFC6A9F6C6273C76F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Lisap5_0-1636410230285.png%22%20alt%3D%22Lisap5_0-1636410230285.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20I%20open%20a%20separate%20sheet%2C%20there%20is%20that%20same%20date%2C%20but%20now%20column%20F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Lisap5_1-1636410318131.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325363i5FF05383F1D76D43%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Lisap5_1-1636410318131.png%22%20alt%3D%22Lisap5_1-1636410318131.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20driving%20me%20crazy%2C%20I%20keeps%20getting%20in%20my%20way%2C%20as%20if%20I%20filter%2C%20it%20stays%20in%20that%20same%20spot%2C%20but%20the%20columns%20are%20changed.%26nbsp%3B%20It%20shrinks%20the%20data%20to%20fit%20in%20the%20cell%2C%20and%20looks%20like%20a%20jumbled%20mess.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Lisap5_2-1636410456753.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325364iC7E860E2480A5D8C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Lisap5_2-1636410456753.png%22%20alt%3D%22Lisap5_2-1636410456753.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAny%20suggestions!%26nbsp%3B%20Except%20to%20recreate%20the%20file%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2941124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2965732%22%20slang%3D%22en-US%22%3ERe%3A%20Strange%20text%20box%20appeared%20on%20all%20worksheets%2C%20and%20always%20shows%20most%20recent%20typed%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2965732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1211834%22%20target%3D%22_blank%22%3E%40Lisap5%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20the%20same%20thing%20happen%20to%20me%20today.%20I%20have%20had%20this%20spreadsheet%20for%20years.%26nbsp%3B%20The%20phantom%20box%20shows%20on%20each%20worksheet%20in%20the%20spreadsheet%20showing%20the%20last%20information%20entered.%20I%20agree%20it%20is%20very%20hard%20to%20work%20around.%26nbsp%3B%20I%20did%20do%20a%20recent%20Windows%20upgrade.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

An Excel file that I have used and updated for 5+ years, all of a sudden has this strange box, that I can not click on, but always shows the most recent typed data in it.  It is across all my worksheets in this book (11 tabs), and I can not figure what I did to create it.   I have tried to click, it and cannot.  See around cell K17 the "11/01/2021" it is there because I typed in the 11/1 in cell F3. 

Lisap5_0-1636410230285.png

If I open a separate sheet, there is that same date, but now column F

Lisap5_1-1636410318131.png

This is driving me crazy, I keeps getting in my way, as if I filter, it stays in that same spot, but the columns are changed.  It shrinks the data to fit in the cell, and looks like a jumbled mess.

Lisap5_2-1636410456753.png

Any suggestions!  Except to recreate the file?

 

1 Reply

@Lisap5 

 

I had the same thing happen to me today. I have had this spreadsheet for years.  The phantom box shows on each worksheet in the spreadsheet showing the last information entered. I agree it is very hard to work around.  I did do a recent Windows upgrade.