Use shared workbooks with different versions of Excel – Office | Microsoft Learn

If this is the first time you’re installing Office you may have some setup steps to do first. Expand the learn more section below. However, if you’re reinstalling Office, and you’ve already redeemed a product key and have an account associated with Office, then go to the section sign in and install Office on your PC or Mac.

Some Office and Office products come with a product key. If yours did, before installing Office for the first time, sign in with an existing or new Microsoft account and enter your product key at office. Redeeming your key is what links your account with Office so you only have to do this once. Already did this? Select the tab below for the version you’re trying to install.

If Office originally came pre-installed and you need to reinstall on it on the same device or a new device, you should already have a Microsoft account associated with your copy of Office.

This is the account you’ll use to install Office following the steps below. Volume license versions : If you work in an organization that manages your installations, you might need to talk to your IT department. Some organizations have different methods to install Office on multiple devices.

Third-party seller : You bought Office from a third-party and you’re having problems with the product key. Go to your Microsoft account dashboard and if you’re not already signed in, select Sign in. Forgot your account details? See I forgot the account I use with Office. From the top of the page, select Services and subscriptions and on that page find the Office product you want to install and select Install. To install Office in a different language, or to install the bit version , select the link Other options.

Choose the language and bit version you want, and then select Install. You’re now ready to install Office. Remember a one-time purchase version of Office is licensed for one install only. If you see the User Account Control prompt that says, Do you want to allow this app to make changes to your device? Your install is finished when you see the phrase, “You’re all set! Office is installed now” and an animation plays to show you where to find Office applications on your computer.

Select Close. Follow the instructions in the window to find your Office apps. For example depending on your version of Windows, select Start and then scroll to find the app you want to open such as Excel or Word, or type the name of the app in the search box. If you’re unable to install Office see Troubleshoot installing Office for more help. Start using an Office application right away by opening any app such as Word or Excel. Can’t find Office after installing? In most cases, Office is activated once you start an application and after you agree to the License terms by selecting Accept.

Office might activate automatically. However, depending on your product you might see the Microsoft Office Activation Wizard. If so, follow the prompts to activate Office. If you need activation help, see Activate Office. Upgrade to Microsoft to work anywhere from any device and continue to receive support. If you’re stuck at the Verifying…. On the first installation screen, select Continue to begin the installation process. Review the software license agreement, and then click Continue.

Select Agree to agree to the terms of the software license agreement. Review the disk space requirements or change your install location, and then click Install. Note: If you want to only install specific Office apps and not the entire suite, click the Customize button and uncheck the programs you don’t want.

Enter your Mac login password, if prompted, and then click Install Software. This is the password that you use to log in to your Mac. The software begins to install. Click Close when the installation is finished. If Office installation fails, see What to try if you can’t install or activate Office for Mac. Click the Launchpad icon in the Dock to display all of your apps. The What’s New window opens automatically when you launch Word. Click Get Started to start activating.

If you need help activating Office, see Activate Office for Mac. If Office activation fails, see What to try if you can’t install or activate Office for Mac. Yes, you can install and use Office for Mac and Office for Mac at the same time. However, we recommend that you uninstall Office for Mac before you install the new version just to prevent any confusion.

Yes, see Install and set up Office on an iPhone or iPad. You can also set up email on an iOS device iPhone or iPad. In most cases, Office is activated once you start an application and after you click Accept to agree to the Microsoft Office License Agreement. Office might activate automatically when you open an app, such as Word, for the first time. If it doesn’t and you see the Microsoft Office Activation Wizard, follow the prompts to activate Office.

If you need help with activation, see Activate Office using the Activation wizard. Premium apps:. Premium apps. Install Office for the first time Some Office and Office products come with a product key.

Reinstall Office If Office originally came pre-installed and you need to reinstall on it on the same device or a new device, you should already have a Microsoft account associated with your copy of Office. Support for Office for Mac ended on October 13, Upgrade to Microsoft to work anywhere from any device and continue to receive support. A subscription to make the most of your time.

Try one month free. Buy now. Best Value. Need more help? Get support. Expand your Office skills. Was this information helpful? Yes No. Any other feedback? The more you tell us, the more we can help. How can we improve? Send No thanks.

What happened to shared workbooks? – Microsoft 365

Important: “Shared Workbooks” is an older feature that allows you to collaborate on a workbook with multiple people. This feature has many limitations, and has been replaced by co-authoring. Excel co-authoring is available in Microsoft Apps Excel desktop client and Excel for the Web for Microsoft subscribers. Be certain that you want to use this method before continuing. Shared Workbooks have limitations, and one in particular is the inability to edit using Excel for the web.

Therefore we highly recommend co-authoring , which is the replacement for Shared Workbooks. Create a new workbook or open an existing workbook. Then place it on a network location. Don’t put the file on OneDrive or SharePoint. If you prefer those locations for the file, co-author the workbook instead. Note that in newer versions of Excel, the Share Workbook button has been hidden.

Here’s how to unhide it. On the Editing tab, select the Allow changes by more than one user On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK. If this is a new workbook, type a name in the File name box. Or, if this is an existing workbook, click OK to save the workbook.

If the workbook contains links to other workbooks or documents, verify the links and update any links that are broken. When you’re done, – Shared will appear at the top of the Excel window, next to the filename. Please be aware that Shared Workbooks is an older method of sharing. Therefore, many items and actions are not supported when this method is used. The table below is only a partial list of features not supported. Before you disconnect users, make sure that they have completed their work on the workbook.

If you remove active users, any unsaved work of theirs will be lost. On the Editing tab, in the Who has this workbook open now list, review the names of users. Select the name of the user who you want to disconnect, and then click Remove User. Please note that although this action disconnects the user from the workbook, it does not prevent that user from editing the workbook again.

Before you turn off this feature, you might want to make a copy of the change history. First make sure that all other users have completed their work. Note that in newer versions of Excel, the Track Changes button has been hidden. Select the List changes on a new sheet check box, and then click OK.

Now you can either print the History worksheet, or you can copy the history and paste it into another workbook. On the Editing tab, make sure that you are the only person listed in the Who has this workbook open now list. Clear the Allow changes by more than one user If this check box is not available, you must first unprotect the workbook.

Do the following:. Click OK to close the Share Workbook dialog box. On the Review tab, in the Changes group, click Share Workbook. On the Editing tab, clear the Allow changes by more than one user When you are prompted about the effects on other users, click Yes. Shared Workbooks have limitations, and therefore we highly recommend co-authoring , which is the replacement for Shared Workbooks. If this is a new workbook, type a name in the Save As box.

On the Review tab, click Protect Workbook. Try one month free. Stay a step ahead with Microsoft Enabling the Shared Workbook feature Be certain that you want to use this method before continuing. Additional information. In the When list, select All. Clear the Who and Where check boxes. If you are prompted, enter the password, and then click OK. On the Review tab, Share Workbook. Need more help? Expand your Office skills.

Get new features first. Was this information helpful? Yes No. Any other feedback? The more you tell us, the more we can help. How can we improve? Send No thanks. Using a data form to add new data.

Save a copy of a workbook to your computer

 
 
Mar 09,  · Sharing an Excel workbook with multiple users is an Excel feature that we called co-authoring, and this is available if you have an Office subscription. Check the support article below for more information about co-authoring: Collaborate on Excel workbooks . Important: “Shared Workbooks” is an older feature that allows you to collaborate on a workbook with multiple feature has many limitations, and has been replaced by co-authoring is available in Microsoft Apps Excel desktop client and Excel for the Web for Microsoft . Note: The steps to install the or versions of Office Professional Plus, Office Standard, or a stand-alone app such as Word or Project might be different if you got Office through one of the following: Microsoft HUP: If you bought Office for personal use through your company, see Install Office through HUP. Volume license versions: If you work in an organization that manages your.