I am attempting to improve a spreadsheet that is used by many of our suppliers. The spreadsheet requests that Purchase Order Details be entered and the single worksheet will be password protected with only specific cells available for data entry. These cells have validation setup to ensure the correct values are entered.
Unfortunately, these spreadsheets are regularly returned with invalid data as the users have pasted data from other sources into the sheet, thereby bypassing the cell validation. In addition, this pasting results in the cells losing their fonts and colours etc. (which is currently a useful feature as it is immediately clear that they have pasted data and therefore bypassed the validation).
Is it possible to prevent ALL invalid data being entered into a cell, regardless of how it gets there? It seems that the current implementation of validation by Microsoft only does half a job.
Start Free Trial
