V
Vinod
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
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