This is a well-known problem though I couldn't find a solution here or anywhere. When a protected sheet has cells which are not locked, but have formatting and data validation, a simple copy/paste into those cells from another sheet loses the formatting and validation in the target cells. Anyone know why this is, and if there's a workaroud?
On its face, ths issue seems like its a major drawback for anyone who builds excel models for others. Why there isn't a way to permanently lock the formatting/data validation is a mystery. Anyone help?
On its face, ths issue seems like its a major drawback for anyone who builds excel models for others. Why there isn't a way to permanently lock the formatting/data validation is a mystery. Anyone help?