Excel Files Are Getting Renamed
I found out today about a problem that began, apparently, this Monday.
A specific set of users have found that opening an excel spreadsheet file and closing it - regardless of whether a change was made, file renamed, or saved - results in the filename and suffix changing. Example: original filename "today.xls" and once it is opened and closed, it is now named "De0328" with no .xls suffix. (note that "De0328" is an example - the files are renamed into apparently random numbers and letters - eight characters - without the .xls suffix) Adding a .xls to the filename allows Excel to reopen the file and all the data is there. This behavior is repeatable from multiple workstations, all XP SP1 or SP2. The target data is on a shared drive on a Win2K server, and happens to be part of our first DFS root implementation as well (files only replicated with DFS, not yet accessed via DFS). An antivirus scan of both file server and DFS came up squeaky clean. Any help is greatly appreciated, thanks in advance ! No unusual error messages in either servers event logs. -- Bill Brower MCSA, MCP |
When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension). If the save is successful, xl will delete the original (or rename it to its backup name (like "backup of book1.xlk)) and if that's successful, xl will rename the funny named file to the original's name. Common things that get blamed for interruptions to this process are antivirus software poking its head in or network errors--either permissions or physical problems. Maybe temporarily disabling the antivirus software would be the easier thing to test. If that doesn't help, maybe there was a permissions change??? Treehouse wrote: I found out today about a problem that began, apparently, this Monday. A specific set of users have found that opening an excel spreadsheet file and closing it - regardless of whether a change was made, file renamed, or saved - results in the filename and suffix changing. Example: original filename "today.xls" and once it is opened and closed, it is now named "De0328" with no .xls suffix. (note that "De0328" is an example - the files are renamed into apparently random numbers and letters - eight characters - without the .xls suffix) Adding a .xls to the filename allows Excel to reopen the file and all the data is there. This behavior is repeatable from multiple workstations, all XP SP1 or SP2. The target data is on a shared drive on a Win2K server, and happens to be part of our first DFS root implementation as well (files only replicated with DFS, not yet accessed via DFS). An antivirus scan of both file server and DFS came up squeaky clean. Any help is greatly appreciated, thanks in advance ! No unusual error messages in either servers event logs. -- Bill Brower MCSA, MCP -- Dave Peterson |
Dave, I ran across something similar in my researching this earlier today, too.
We use Trend Micro's ServerProtect and this problem *is not* happening on other servers and shares with Excel spreadsheets - which doesn't mean there isn't a problem on these affected servers - but for my money makes antivirus a less likely prospect. We have no indications of any type of network problems - but I'll look at that more closely tomorrow. Thanks for the tips. Bill "Dave Peterson" wrote: When excel saves the file, it saves it as a temporary file with a funny name (8 characters--no extension). If the save is successful, xl will delete the original (or rename it to its backup name (like "backup of book1.xlk)) and if that's successful, xl will rename the funny named file to the original's name. Common things that get blamed for interruptions to this process are antivirus software poking its head in or network errors--either permissions or physical problems. Maybe temporarily disabling the antivirus software would be the easier thing to test. If that doesn't help, maybe there was a permissions change??? Treehouse wrote: I found out today about a problem that began, apparently, this Monday. A specific set of users have found that opening an excel spreadsheet file and closing it - regardless of whether a change was made, file renamed, or saved - results in the filename and suffix changing. Example: original filename "today.xls" and once it is opened and closed, it is now named "De0328" with no .xls suffix. (note that "De0328" is an example - the files are renamed into apparently random numbers and letters - eight characters - without the .xls suffix) Adding a .xls to the filename allows Excel to reopen the file and all the data is there. This behavior is repeatable from multiple workstations, all XP SP1 or SP2. The target data is on a shared drive on a Win2K server, and happens to be part of our first DFS root implementation as well (files only replicated with DFS, not yet accessed via DFS). An antivirus scan of both file server and DFS came up squeaky clean. Any help is greatly appreciated, thanks in advance ! No unusual error messages in either servers event logs. -- Bill Brower MCSA, MCP -- Dave Peterson |
Have you ever found a solution to this situation? I have the exact same thing, we have two servers, on in Chicago and one in Denver and have DFS implemeted to sync data between 2 file servers, some folders only replicate after work hours, but the folder that replicates during the day is having this issue.
I've been at a loss, and the anti-virus and "network errors" doesn't offer much of a solution, and I have disabled ths scanning on that folder with the same result. Let me know if you ever have come across a fix for this annoying solution Thanks, Randy |
All times are GMT +1. The time now is 11:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com