|
| Product |
| ExcelWriter |
| Version |
| 1.x, 2.x, 3.x |
| Title |
| ExcelWriter generated files prompt "Save changes" dialog when closed |
| Problem |
| 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? |
| Solution |
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
Next
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) |
|
