Has anyone come across this weird scenario?

After a few minutes of using/working in a sheet, excel stops displaying a performed action, but still applies it.

Example: You paste content in a cell - after you've done that, Excel executes the action, but it is not visible. From a simple screen view perspective, it seems, that the cell is still empty, though it is not. What is shown on the screen and the true content of the cell differ. To view the pasted content in the cell, it seems that excel needs an additional trigger - one such trigger is to change the display percentage, e.g. from 100% to 90%. After this is done, the value in the cell is now visible.

You then either work for a few minutes again perfectly fine, until the error reappears or this error stays on directly for any amount of time further ...

Thank you for any insights!

i don't think i've had this specifically occur but i've had something similar when doing massive sheets with tons of calculations on my ultrabook

the issue i have is with ram usage making it unable to perform all those simultaneous calculations ie you enter some data into a new cell and all the unrelated formulas fire off again each time even though there's no reason for this so it grinds to a halt, displays things awkwardly, or even gives me the excel black screen of death

a good way to mitigate this is to dig through the settings and get it to only perform calculations manually - you can do this by going to options at home screen and then on the formulas tab

another quick fix i've found is to simply reboot my laptop

again, i don't think your problem is the same as mine but seems plausible could stem from same issue of ram constraints so worth a shot

hmm, didn't think this thread was quite as dead as it was in 2022. i have a question. here's the data i need to manipulate:



the top table is the output. the cells highlighted in yellow will always be blank. the data cells (for which there are 10 in row 1, 9 in row 2 etc) will usually be completed, but not necessarily. i need a macro to convert to the bottom format. the number of rows/columns of months will be the same, but the actual count of them will differ. so basically i need something that will:

- count the number of rows we need to run a loop from (i.e. look for the last cell in column A and remove one), call that variable x
- then for n = 1 to x, delete n-1 cells from row (2+n-1) starting in column b, shifting left

it's been ages since i've used vba, i forget most of the syntax and was never much good at dynamic ranges anyway, tia

I want to keep a spreadsheet for trading cryptocurrency that has a ton of zeroes and is too annoying to enter into a calculator. Here is the problem I am having: I enter the Price Per Coin in cell B, and the Trade Cost in cell D. In cell C50, I am entering the formula =sum(D50/B50). I want it to calculate the number of coins I can buy for the price and cost I have entered. However, it returns a different amount than my crypto exchange, which also coincides with the calculator.

What am I doing wrong?

The exchange shows 476,667,143.00 coins.

There might be more digits in the exchange price than shows, which would give a higher # of coins

this, also the exchange doesn't always trade by the listed price but rather a market maker price and could include their fees into the trade

there could be a significant spread for a low volume sh*tcoin

I received 23K more coins than the formula showed. I'm not concerned about the spread because I make limit orders. Maybe one day it will go back down to 0.0000002997, but today it's 0.00000093. Daily volume around $93M. This memecoin is called PEPE

Congrats! Looks like it worked out for you