PDA

View Full Version : Solved: Track Changes in Excel Feature



reza_doang
07-07-2010, 11:14 PM
Hi All,
i just know that excel have a great feature about track changes (Review - Changes - Track Changes). But the problem if i use this, the file will share mode on. And in share mode on, i can't delete sheets, can't merge cells and insert feature.
How to use track change but not in shared mode on, so i still can merge cells or insert pivot table? or maybe should use VBA?


thanks


reza

slamet Harto
07-08-2010, 12:41 AM
IMHO, it is excel default.
Change tracking is available only in shared workbooks. when you create it then the workbook is automatically becomes a shared workbook.