Solve these problems

 

Using Excel Shared Workbooks

Excel Online allows multiple editors by default, but it’s missing a great deal of functionality. The service isn’t much of a contender for anything but the simplest tasks. Although the Shared Workbooks feature looks like it should do the job, it’s full of restrictions. For example, you can’t create a table or delete a block of cells if the workbook is shared.

 Excel Data Validation

Errors can creep into data within any computer system: people mistype words or transpose digits in numbers with monotonous regularity. If your data doesn’t get checked as it’s entered, you’re going to have problems.

By default, Excel accepts whatever the user types. It is possible to set up validation on look-up lists, but they are difficult to maintain, mainly if the same field gets used in more than one place. If users have to enter document ID numbers or customer reference numbers without any checks, it’s easy to tie the wrong records together without realizing it. The data integrity of the system becomes fatally compromised, and any analysis of the data is suspect.