Limitation of Excel shared workbook 2013 VS 2010 Vs 2007

We all try share work in multiple workplaces. hence, we share wokbook while workingh for multiple purpose like summarization in context of data. To reorganize work among the group of people, To count the total number of work item worked or average number of people worked on data

hence below are some major limitations will may help you to understand the limitation of shared workbook and allow changes by more than one user to do.

Feature Limiation	Maximum limit
Users who can open the file at the same time	256
Personal views in the workbook	Limited by available memory
Days that change history is maintained	32,767 (default is 30 days)
Workbooks that can be merged at one time	Limited by available memory
Cells that can be highlighted	32767
Colors used to identify changes made by different users when change highlighting is turned on	32 (each user is identified by a separate color; changes made by the current user are highlighted with navy blue)
Excel tables in the workbook	0 (zero)

If the Allow changes by more than one user.setting is on for a workbook, then the following information applies. This setting is accessible by clicking the Review tab 

Share Workbook. 

Note that in newer versions of Excel, the Share Workbook button has been hidden. 

1. To unhide it, click File 
2. navigate to Options 
3. click on Quick Access Toolbar. 
4. Open the list under Choose commands from and select All Commands. 
5. Scroll down that list until you see Share Workbook (Legacy). 
6. Select that item and click Add. Click OK. 
7. The Share Workbook button is now at the top of the Excel window.