Just click the button at the right and select the range of cells you want to keep track of.įinally, you can un-check the Highlight changes on screen option if you do not want others to know you are tracking changes. The Where option allows you to track changes only for a specific portion of the spreadsheet.
If you check Who, you can choose to track changes made by anyone or changes made by everyone except you. You also have the option of highlighting changes from the last time you saved the document, since a specific date, or changes that have not yet been reviewed. For When, All means every change will be highlighted. You have several options here including When, Who, and Where. You’ll get a dialog box where you now need to check off the option “Track changes while editing. At the far right, you should see an option called Track Changes under the Changes section.Ĭlick the button and choose Highlight Changes. Open Excel and click on the Review tab on the ribbon. Let’s go ahead and turn on tracking first.
Now that you know some basics of how tracking works in Excel, let’s talk about how to enable it, change settings and keep track of changes! Enabling Tracking This means that multiple users will be making changes to the document. Whenever your turn on tracking, the workbook becomes a shared workbook. That means the next time you open it, you won’t be able to see that change you had made 45 days earlier.Ĥ. When you close it, any change history older than 30 days will be gone. If you make changes to an Excel worksheet and then open the workbook again 45 days later, then you’ll be able to see the change history for all 45 days until you close the workbook. Change history is only kept for 30 days by default. Other changes that are not tracked include hiding/unhiding rows and columns, comments, and cell values that change to due a formula recalculation.ģ. Any data stored in a cell is tracked, but other changes like formatting are not. Turning on tracking doesn’t mean every single change you make will be recorded. You can manually go and see what data was deleted or added, but you’ll have to make the changes to the spreadsheet yourself.Ģ. It’s basically a log file that records everything and that’s it. Turning on tracking does not mean that you can revert the spreadsheet back in time to a previous state by undoing the changes.
Now with one click on “ Remove Password“, and in about one second, you would see sheet password, workbook password and read-only password are all removed.Ĭonfirm and you would successfully get unprotected excel file after unlocking locked excel file.1. Step 3: Click on “Remove Password” button and regain editor privileges. While excel file is *.xls format, please convert it into *.xlsx firstly, and then you can successfully add excel file locked for editing. And click Open button on Workbook Unprotect Genius, then select locked excel file to import into iSunshare software. Make sure the location of your password protected excel file locked for editing. Step 2: Run it and import password protected excel file locked for editing.
However, Workbook Unprotect Genius trial version here only allows you to add password protected excel file (*.xlsx).
Step 1: Install iSunshare Workbook Unprotect Genius full version on computer.īesides full version, surely there is also trial version provided for users free.
It will remove all sheet password, workbook password and read-only password at once. But don’t worry, because you can remove the editing restrictions just with software, iSunshare Workbook Unprotect Genius. When your excel file is read-only after opening, it must be locked for editing by you or another user before. Part 2: How to Unlock Excel File Locked for Editing More details about this topic, you can refer to article relating to removing forgotten password from excel files. The best way to unlock it should be removing open password from excel file and you could open it at any time without password requirement.įor excel file *.xls format, you could directly remove its open password with iSunshare Excel Password Remover.įor excel file *.xlsx format, only after open password is recovered with iSunshare Excel Password Genius, you can remove forgotten open password after opening excel file In MS Excel. While you find your excel file cannot be opened, it means it is locked for viewing. Part 1: How to Unlock Excel File Locked for Viewing