You can use data validation when you type new valuesĬreate or change charts or PivotChart reports
You can sort or filter by number, text, or date, apply built-in filters, and filter by using the Search boxĮxisting conditional formats continue to appear as cell values change, but you can't change these formats or redefine the conditions. I have collect and summarize the items from Excel 2013, Excel 2010, Excel 2007, Excel 2003.Įxcel 2013, Excel 2010, Excel 2007, Excel 2003 In some cases we may ask why we can’t use some features? Because they may be not supported in shared workbook. When they're done, you merge the data from the copy Someone else then copies the shared workbook and adds their data to the copy. The process works like this: You share a workbook, and as part of sharing, you save the workbook. Excel merges changes from one or more copies back into the one that you shared.
When we share a workbook, multiple users can't work on it at the same time.
