Home     Products      Support      Corporate     Sign In 
Support Knowledge Base, Article 293
1.x, 2.x, 3.x
ExcelWriter generated files prompt "Save changes" dialog when closed
Why does a client, who attempts to close out of an open ExcelWriter generated file, often receive a prompt to "save changes", even if they have not made any changes to the downloaded file?
The prompt to confirm the retention of modifications will occur whenever an ExcelWriter generated file contains formulas and/or charts. The reason for this is that ExcelWriter does not contain a calculation engine to execute the formulas server-side. This execution of the formulas and/or the drawing of the charts occurs when the file is opened in MS Excel. Therefore, when you close or move off the displayed file, Excel is attempting to save the changes that it has made in displaying the formula results and/or the chart display.

The only way to overcome this Excel generated message is to use an input Excel file with the template object or Application.Open, which contains a VBA code module that does the following:

Private Sub Workbook_Open() 
Dim Workbook As Workbook 
For Each Workbook In Excel.Workbooks 
	Workbook.Saved = True 
End Sub 

The VBA will be preserved in the new ExcelWriter-generated file and will cause the changes to be automatically saved without prompting the user.
Related Links
OfficeWriter Home Page
OfficeWriter Enterprise Edition
Latest OfficeWriter News
OfficeWriter: Programmatic Runtime Control

Created : 12/1/2002 12:00:00 AM (last modified : 9/19/2002 7:30:19 PM)
Rate this article!