Updating spreadsheets in excel

This blue button is in the bottom-right corner of the window. Include your email address to get a message when this question is answered. Updating Excel can prompt the rest of your Office programs to update as well if you have automatic updates the default setting enabled for them.

Helpful 0 Not Helpful 0. Excel will usually close during the update process, so it's important to save your work before updating. If you don't save your work, you'll be asked if you want to recover the most recent saved version of your work the next time you open Excel. You Might Also Like How to. How to. About This Article. Written by:. Co-authors: 2.

Updated: March 29, Categories: Microsoft Excel. Italiano: Aggiornare Excel. Bahasa Indonesia: Memperbarui Excel. Nederlands: Microsoft Excel updaten. Thanks to all authors for creating a page that has been read 80, times. Is this article up to date? Yes No. Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy.

Featured Articles How to. Trending Articles How to. New Pages How to. Watch Articles How to. By signing up you are agreeing to receive emails according to our privacy policy. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Search instead for.

Did you mean:. All posts Previous Topic Next Topic. KeithCa Regular Visitor. Flow to update spreadsheet in sharepoint from excel on onedrive. Labels: Labels: Excel Sharepoint list. Message 1 of 5. Why aren't you just directly updating the spreadsheet in SharePoint? Why have two copies? Have you considered using OneDrive to sync the two excel files? Message 2 of 5. Message 3 of 5. In response to KeithCa. Then you can update the excel and create SharePoint items every time a row is added.

Message 4 of 5. Would you delete some records within the Excel file stored in OneDrive? If you just add new records within the Excel file stored in your OneDrive folder, I have made a test on my side and please take a try with the following workaround: Add a "When a file is modified" trigger, specify Folder. Add a "Get rows" action, File name set to File identifier dynamic content of the trigger and Table name set to Table1 as a custom value. The Send Link dialog opens so you can send people a link to the workbook.

By default, anyone in your organization can use the link to open and edit the workbook. If you want to adjust who can use the link and what they can do, select People in [Your organization] with the link can edit , choose the options you want in the Link Settings dialog, and then select Apply. Now you can co-author the workbook at the same time as other people. You know you're co-authoring with one other person if you see a message in the upper-right corner that says they're editing.

If more than one other person is editing, you'll see a different message that tells you the number of people that are co-authoring. For example: "2 other people are here. To review changes others have made since you opened the file, select Show Changes.

This opens a pane where you can see the changes, including previous cell values if any have changed. If you want to jump to where someone is working, select their name, and then select the Editing If just one person does this, then everyone else will get the "locked" error — even if everyone else is using a version of Excel that does support co-authoring. Make sure everyone who is working in Excel for Microsoft has AutoSave on.

If someone is using OneDrive to sync files, they need to make sure it isn't paused. And they need the Use Office to sync files This may happen occasionally if someone uses an Excel feature that isn't fully supported in Excel co-authoring yet, and it can stop the co-authoring process temporarily. Finally, one last step: Reopen the original file that's on the cloud and paste your changes back in. Keep in mind that if someone is using OneDrive to sync files, changes they make while their computer is offline won't get merged until their computer is online again.

And once online, all their changes get merged at once. In Excel for the web, go to the folder that contains the file. Then right-click the filename and choose Version history.

Then select an older version on the left and that version will open. To co-author in Excel Android, you need to make sure certain things are set up before you start. You need the latest version of Excel installed, and you need to sign in to Excel with a Microsoft account.

If it isn't, tap Add a place to add the account. Note that if you have a phone or tablet that's larger than Check the current location of the file. If one of these is not selected, then tap OneDrive or SharePoint on the left, name the file, and then tap Save. Tap in the upper-right. Type email addresses in the Invite people box, and separate each with a semicolon.

Tapping this button will send email messages to people for you. Tip: If you want to send the link yourself, don't tap the Share button. Instead, tap Share as link. If you tapped the Share button, people will receive an email message inviting them to open the file. A web browser will open the workbook in Excel for the web. To see who's editing the file with you, tap Share in the upper-right, and then tap Manage.

If there are others working on the file at the same time as you, you'll see their name listed. If they have an Editing label, they're working on the file. Make sure everyone who's working in Excel for Microsoft has AutoSave on in the upper-left corner of the Excel window. For stuff that you need to keep, tap Save a copy and save the file as a different name.

Then tap a past version, and it will open. If you want to restore it to the current version, wait until everyone is no longer co-authoring, and then tap Restore this version. To co-author in Excel for iOS, you need to make sure certain things are set up before you start.

When you open Excel, tap Open and make sure your Microsoft account is listed there. If you created a file, tap File , tap Name , and then name the file.

If the Location path contains the words "OneDrive," "d. Tap Share in the upper-right. Then paste the link into an email message or IM window. If you want Excel to send the link for you in an email message, tap Invite People.

Then type email addresses in the Invite people box and tap return after each address. Also make sure that Can edit is turned on. Finally, tap Send. If you tapped Send in the previous step, people will receive an email message inviting them to open the file. To see who's editing the file with you, tap Share in the upper-right, and then tap Shared With.

If they have an Editing If you want to restore the file to a past version, wait until everyone is no longer co-authoring. A web browser will open with the past versions of the file. If you're using OneDrive, tap a version on the left, and then tap Restore. Then go back to Excel for iOS, and reopen the file. To co-author in Excel Mobile, you need to make sure certain things are set up before you start. You need the latest version of Excel Mobile installed on your tablet or phone, and you need to sign in to Excel with a Microsoft account.

If it isn't, tap Add account. Under the filename, check to see if the words OneDrive or SharePoint are in the path of the file. If they are, tap the Back button and go to the next step. If one of these is not included in the path, then tap Save a copy of this file , and save the file to a OneDrive , OneDrive for Business , or SharePoint Online location. If you're not sure which one you're using, ask the person in charge of your site, or your IT department.

Instead, tap Get a sharing link at the bottom of the pane. To see who's editing the file with you, tap Share in the upper-right. If you are still getting the "locked" error, see Excel file is locked for editing for more solutions to this problem.

Other people's selections aren't visible in Excel Mobile at this time.