I'm using Excel 2015 for Mac. I have D17=D4, and D56=D4. It's a very simple formula. So everytime I change D4, D17 and D56 should changed as well. However, if the view is 100%, D56 is not changing. Then I try other zoom level, as long as you need to scroll down. D56 is not changing.
This is very bugging problem, you can get wrong calculation because of this. Can anyone replicate this? I have tried to use new sheet, and it all give me the same bugs. Haven't try to restart the comp though. Here's the file I use: https://www.dropbox.com/s/23pvf7v3vw4a5e6/Workbook1.xlsx?dl=0
FYI I'm using macbook pro 15 retina, the height resoulutin is 900. Anyway, as long as you need to scroll down to see D56, then there will be bugs.
This is very bugging problem, you can get wrong calculation because of this. Can anyone replicate this? I have tried to use new sheet, and it all give me the same bugs. Haven't try to restart the comp though. Here's the file I use: https://www.dropbox.com/s/23pvf7v3vw4a5e6/Workbook1.xlsx?dl=0
FYI I'm using macbook pro 15 retina, the height resoulutin is 900. Anyway, as long as you need to scroll down to see D56, then there will be bugs.