| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent invalid data when pasting from Word directly onto cell?
I have a spreadsheet that a customer uses to provide me with catalog data for
our application. Despite direction, he consistently provides data that exceeds maximum field lenghts for our database. I have tried conditional formatting and restricting the data based on max length but he is often copying the text from Work and just pasting it idirectly nto the Excel cell (not using the text bar). Neither formatting or restricting work in this scenario. Any ideas on how to prevent him from being able to paste in invalid data? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent changes to cell references when copying and pasting | Excel Discussion (Misc queries) | |||
| Pasting delimited text from clipboard directly into Excel Spreadsh | New Users to Excel | |||
| Is there a way to prevent pasting data into an Excel worksheet? | Excel Worksheet Functions | |||
| Pasting Excel data into Word doc. | Excel Worksheet Functions | |||
| Prevent Row Height from increasing when Pasting lenghthy text into Cell. | Excel Worksheet Functions | |||
Threaded Mode
