Aug 14, 2014 · As far as I know, there is no such limit for shared workbook. How did you shared the workbook to the users? Please try to disable the sharing and then share it again using the steps below: 1. Open the workbook that you want to make available to share. 2. On the Review tab, in the Changes group, click Share Workbook. 3.

If you have set unused rows and columns size to zero, you can CTRL + A(twice in 2003) to select all. Click on Format>Column>Width and type in 8.43 for standard width. Same for row height of 12. To return the sheet name in a cell, use the CELL, FIND and the MID function in Excel. There's no built-in function in Excel that can get the sheet name. 1. The CELL function below returns the complete path, workbook name and current worksheet name. Note: instead of using A1, you can refer to any ...