Protected sheet don’t update screen

poulmax

New Member
Joined
Apr 19, 2017
Messages
6
Hi
I have a sheet for Work In Progress stocktaking. The sheet is protected except for cells in which order number are typed.
Using ENTER or TAB brings you down to the next cell for typing, in between typing cells are 10 rows with lots of lookup (Index,Match).
Problem is reaching bottom row on screen, rows that are not on screen and rolled up when doing a ENTER, showing no data until a PAGE UP and PAGE DOWN are done.
Hope it’s possible to understand.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
After nearly pulling the rest of my hair, it seems to be connected to 'Freeze Panes'.
Releasing or unfreeze makes the problem disappear - strange.:eek:
 
Upvote 0

Forum statistics

Threads
1,215,516
Messages
6,125,285
Members
449,218
Latest member
Excel Master

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top