Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formats and Data validations changes are not sticking
Hi All,
I updated data validations in one of my workbook(5000 rows have been using in that particulat sheet with validation rules for all the cells in this range) which is already contains data validations. earlier it pointing to allow values =0 now i updated it allow values =0 and <=1 (0, 0.1, 0.2, ....1). and i copied this for every 13 rows in the 5000 rows range. During save I ecountered with the following error Excel could not save all the data and formaiting you recently added. 1. To return to your workbook without saving click cancel 2. If you want to continue saving changes without reparing the problem, Click OK. When I clicked on OK then I knew that No row having validation rule from row no 656 to 5000 (earlier each cell in this range holds a validation) Please help me out how can I resolve this. For your reference: This file is not holding any VBA Macro Regards, Vinod |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Data Validations Q | Excel Worksheet Functions | |||
Multiple Data Validations | Excel Discussion (Misc queries) | |||
two data validations for same cell | Excel Discussion (Misc queries) | |||
data validations | Excel Discussion (Misc queries) | |||
3 data validations | Excel Worksheet Functions |