Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Saving/Locking with Excel different between 2003 AND 2007
We just moved over to 2007, within the last couple of months.
Before, in 2003, it appeared that when you saved an existing file, it deleted that file, and saved a new copy. When file was open by someone else on the network, you would get a message about opening it up later, or opening it up read only, based on the fact that it was already opened by someone else. Now, with 2007, it appears that the existing file is opened, and changes are inserted into it, rather than dumping and creating a new one. Is there any way to change this back to the old method? Now with 2007, it appears that instead of relying on the fact that a file is in use by someone else, Excel is creating a hidden file, that begins with "~" that it uses to tell of a file is in use. If this file does not get deleted, the spreadsheet become unacceptable. This behavior is not optimal on my network. We keep getting files that we can't open because they are "in use". but in reality, they are not in use/ Also, we do not get consistent message saying that the file is in use, sometimes a file will just hang on opening. Any ideas? Any help? Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving from 2007 to 2003 - 2003 won't open the file | Excel Discussion (Misc queries) | |||
Saving as a 2003 file in 2007 | Excel Discussion (Misc queries) | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
Formatting lost when saving excel 2003 file using excel 2007 | Excel Discussion (Misc queries) | |||
Saving in 2007 as a 2003 file | Excel Discussion (Misc queries) |