I'm using UltraWebGridExcelExporter, and I get the messages below when I try to save the Excel file which I just opened by selecting 'Open' on the Save/Open/Cancel dialog box. When I click 'Save' on newly created excel file, Excel usually gives me 'Save As' dialog, but for some reason I don't get 'Save AS' dialog and the Excel program seems to be trying to save the temporary file which is (probably) created by UltraWebGridExcelExporter.
I get these 3 messages after I click 'Save' button on Excel...
1) Your Changes could not be saved to 'MyCF_DG[1].XLS' because of a sharing violation. Try saving to a different file. ->Click OK (MyCF_DG is my UltraWebGrid name.)2) The file you are trying to open, '9D1A300.IES\...', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now> Yes/No/Help -> Click No3) Your changes could not be saved to 'MyCF_DG(1).XLS', but were saved to a temporary document named '9D1A3000'. Close the existing document, then open the temporary document and save it under a new name. -> Click OK (The help says I do not have a permission to modify or delete the file.)
After I go through all these messages and click the save button again, Excel brings me to 'Save As' dialog and I can save the file without any problem. I am wondering why Excel does not give me 'Save As' dialong at the first time I click 'Save' button.
Thank you in advance.
Hello mgmtakahashi,
Please let me know if I can provide any further assistance regarding this matter.
I have noticed that you posted this a while ago. Please note we are making efforts to ensure all posts are addressed by an Infragistics expert. We believe that the other community members could benefit from this thread as well.
From the details provided, the error means usually occurs when using Excel 2007. Please go through this link from MSDN which explains you how to overcome this error.
http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning.aspx
Additional Note: This link is neither created nor maintained by Infragistics.
Sincerely,
Prabha.