View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Michael Howes Michael Howes is offline
external usenet poster
 
Posts: 8
Default HighlightChangesOptions and HighlightChangesOnScreen not saving?


I generate some Excel files from c#

I turn change tracking on, which requires me to share the the
document. So I save with sharing, turn change tracking on, save again,
then make the excel application Visible.

Everything seems to work fine. Change tracking works, things seem ok

I close Excel, then open the file up manually. Change tracking doesn't
show all changes, for some reason it's set to "Since I last saved"

huh?

my code
excelApp.Workbooks[1].KeepChangeHistory = true;

object oWho = "Everyone";
excelApp.Workbooks[1].HighlightChangesOptions(Excel.XlHighlightChangesT ime.xlAllChanges,
oWho, Type.Missing);
excelApp.Workbooks[1].ListChangesOnNewSheet = false;
excelApp.Workbooks[1].HighlightChangesOnScreen = true;


any ideas?

thanks
mike