Excel file expands ands locks Excel

Excel file expands ands locks Excel

Post by Tvermoe » Thu, 30 Sep 2004 21:27:21


Hi!

I'm working with files that are run on different PCs,
Excel 2000, English or Swedish versions. No Macros.

For some files, it goes wrong. The file size increases
after each saving and eventually cannot be opened. Excel
tries to open but hangs half way.

I have no clue why this hapens, anyone?
 
 
 

1. excel files are locked for editing but not by the user excel state

2. Excel file locked for editing even after deleting Excel server instance

Hello Matlab users,

I am saving computation results to excel files using:

Excel = actxserver ('Excel.Application');
File=filename;
Excel.Visible =1; %added by chiara 9 Aug 2007
if ~exist(File,'file')
ExcelWorkbook = Excel.workbooks.Add;
ExcelWorkbook.SaveAs(File,1);
ExcelWorkbook.Close(false);
end
invoke(Excel.Workbooks,'Open',File);

[...]

invoke(Excel.ActiveWorkbook,'Save');
Excel.Quit
Excel.delete
clear Excel

when i am finished, i try to open the files but once in a while they
are locked for editing and remain so - such that i cannot overwrite or
even delete them. I do not have extra excel processes running, though.

Any tips would be appreciated.

Have a very nice day,
chiara

3. Excel file opens MS Excel Training Webpage When the Excel file ope

4. Why my Excel 2003 don't open excel files by duble click on excel .

5. Excel 2002: How is the Excel 2007 file format open in Excel 20

6. Excel 2003 crashes loading excel files created Excel 2000

7. Copy Paste failed in excel file migrated from Excel 2003 to Excel

8. Can I expand a cell without expanding the whole column in Excel?

9. Excel Option conflicts, forcing Excel files to run new excel.exe

10. Excel 2002: How is the Excel 2007 file format open in Excel 2002 ?

11. Need to Save Excel XML as just Excel file for user to open in Excel 2000

12. Excel Option conflicts, forcing Excel files to run new excel.e

13. Excel Addin- Processing of data while opening excel files in EXCEL

14. search excel file or html file generated from excel file

15. Can I lock info in Excel 2003 and users in Excel 2000 enter info?