Click here to go back to Track Changes Page 1
Highlight Changes on Screen See Also: Track/Report Excel Changes VBA Method
Selecting this option means each time a change is made to your Workbook, a cell comment will be inserted into the changed cell and will have: Username, Date, Time, Changed from and Changed to. A small comment flag (triangle) will be in the upper right of the cell and be a different colour to a normal cell comment.
Once you have made your choices for the options and click OK, Excel will warn us that doing so will Save the Workbook and allow you to Continue or Cancel. When you opt to Continue our Workbook will become a Shared Workbook. From now on any changes that are made will be tracked. The type of changes that are tracked are :
Remembering that we must first save our Workbook as a Shared Workbook, have some changes made and those changes saved, this option provides far more information of what changes have taken place. After you have saved the Workbook as Shared and selected this option, it means that you can then go to Tools>Track Changes>Accept or Reject Changes (after changes have been made) and have the following information automatically listed on a another Worksheet named History. This sheet will also, by default, have Excels AutoFilters turned on for easier viewing.
|Action number||This is the order in which the changes were made in numeric order|
|Change||The type of change made eg; Cell change, row deletion etc.|
|Sheet||Name of the Worksheet that the change occurred on.|
|Range||Address of the change.|
|New Value||Value of the cell before it was changed.|
|Old Value||Value of the cell after it was changed.|
|Action Type||This will list whether the change was the "Result of rejected action", "Undo" or "Won" See Accept or Reject Changes below.|
|Losing Action||This relates to the Action Number if the change was the result of the Accept or Reject Changes dialog box. See Accept or Reject Changes below.|
The History Sheet will only be available until the Workbook is re-saved. Once the Workbook is re-saved the History sheet will be deleted. To display it again simply go to Tools>Track Changes>Highlight Changes and check the Highlight changes on screen option and click OK.
Click here to go to Track Changes Page 3
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates