This document is a web archive file excel

If possible, remove password encryption from the file. To do that, go to the Review tab. If Protect Workbook is highlighted, click it to turn off protection. Enter the password if prompted. If possible, remove restricted access. Step 3: Make sure everyone uses a version that supports co-authoring. Note: Excel does not support co-authoring.

Windows: If possible, remove password encryption or restricted access from the file. Mac: If possible, remove password encryption from the file. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Add a comment. Active Oldest Votes. This is a great solution! I wonder if there is a way to assign tab names to the names in the list.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. You can reduce your file size by saving your spreadsheet as a binary workbook. The default format is XML based, which is important if you're using your data with third-party programs because XML is an open standard. However, for most purposes, the binary format is sufficient and saves to a smaller file.

This option sets binary format as the default. If you want to keep the default to Excel Workbook. If this is the case, you can save a copy to your local drive, save that copy as a binary, and then replace the original file with the new binary. If you have worksheets with data that you're not using—and that don't contain any formulas you're using—delete them from the spreadsheet.

The more data points you have in your workbook, the larger your file size will be. Removing unused data will reduce your file size. Select Discard editing data. This option removes stored data that's used to restore the image to its original state after it's been edited.

Note that if you discard the editing data, you won't be able to restore the image. In the Default resolution list, select a resolution of ppi or lower. In most cases, you won't need the resolution to be higher than that. Select a picture in your document. The Picture Format tab appears on the ribbon.