Friday, October 19, 2012

How to Make My Excel Spreadsheet Interactive


Use the 'Share Workbook' Command
1. Open the Excel file.
2. Click the 'Review' tab on the command Ribbon.
3. Click 'Share Workbook' in the 'Changes' group. A 'Share Workbook' dialog box appears.
4. Click the 'Editing' tab on the 'Share Workbook' dialog box.
5. Click to select the check box for 'Allow changes by more than one user at the same time. This also allows workbook merging.'
6. Click the 'Advanced' tab in the 'Share Workbook' dialog box.
7. Select the radio buttons for options, such as 'Track changes' and 'Conflicting changes between users.'
8. Click 'OK.'
9. Click 'Save' on the 'File' tab. If this workbook is a new file, the 'Save As' dialog window appears. Type the file name in the 'File name' text box. Click the location where the file should save, such as the Desktop or a named folder. Click 'Save.'
Use 'Windows Live SkyDrive'
10. Sign in to your 'Windows Live' account. A 'Hotmail' screen appears.
11. Click the 'SkyDrive' button at the top of the screen. A list of documents appears. If you do not see your Excel file, type the file name in the 'Search documents' text box.
12. Click the Excel file. The workbook appears on the 'Excel Web App' dialog window.
13. Click the preferred buttons, such as 'Edit in Browser' or 'Share.' The 'Edit in Browser' link brings up the command Ribbons with the 'Home', 'Insert' and 'View' tabs and commands.
14. Edit the worksheet. The workbook saves automatically.
15. Click the 'Share' button. A list of options appears.
16. Click 'Permissions.' The 'Edit Permissions' window appears.
17. Click the slider button on the 'Who can access this' slider. The choices range from 'Me' to 'Everyone (public).'
18. Select the 'Can edit' option in the text box.
19. Type a contact name or email address in the text box.
20. Click 'Save.' The Excel file is emailed to your recipient.
21. Close this application. The 'Documents' list appears. The Excel file includes an updated 'Date modified.' The 'Shared with' column also updates.

Blogger news