PDA

View Full Version : got following error after export excel file .



ankit_ddit
03-20-2009, 09:07 AM
this error appears if you have tried to save a workbook on a drive and you do not have Modify and Delete permissions to the location where the file is being saved. It is also possible that another user has a read lock on the file.
Excel saves a file using three steps (if the file already exists in the target location):
Creates a temporary file with a randomly generated name, such as 4CCA4100.
Deletes the original file.
Renames the temporary file to the original file name.
If Excel cannot delete the original file or cannot rename the temporary file, this error message appears.
To temporarily work around this problem (providing another user does not have a read lock on the file), save the workbook to a local hard disk, or to a folder where you do have Modify and Delete rights. You may then be able to copy the file to the network drive.
This problem can also appear if you have an antivirus program installed either on your computer or on the network server. If this is the case, you may want to temporarily turn off or remove the antivirus program. If Microsoft Office Excel begins to save files correctly, contact the anti-virus vendor and ask if there is an update or correction to this problem.
More information about this error message online.