D
David
A shared excel sheet gets a daily addition by each of the shared users.
After the information is added, the sheet is sorted. Can the excel sheet be
locked so that if someone sorts the sheet and accidentally does not include a
column, it will not sort the sheet until all columns are included in the sort.
Example: Columns A-E and Rows 1-10 are used, but when sorted, user did not
include all Columns and only sorted with B-E, now Column A does not line up
with correct rows after sort.
After the information is added, the sheet is sorted. Can the excel sheet be
locked so that if someone sorts the sheet and accidentally does not include a
column, it will not sort the sheet until all columns are included in the sort.
Example: Columns A-E and Rows 1-10 are used, but when sorted, user did not
include all Columns and only sorted with B-E, now Column A does not line up
with correct rows after sort.