Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Excel file "Document not saved"

I have a user on a Windows 7 workstation trying to save an Excel spreadsheet to a network drive (samba). He gets the error message "Document not saved." He can save it to this drive/folder with a different name. He can save this file to his desktop (Redirected folder) or to another network drive. I can open/save the problem file to this drive/folder from other workstations connected to this network drive.

Permissions on the samba drive are the same for the original and newly named file. When, on Windows on the problem workstation I right-click on the file > Properties > Security, I get "The requested security information is either unavailable or can't be displayed." I can show security information if I do so on the renamed file.

Even more interesting, if I remove the original file and renamed the successfully saved file to the original name. I can no longer save it! And, the new file, renamed to the old name, will not now let me see the Security properties, even though I could see the properties when it had the other name. If I then rename it back to e.g. something.xls, I can once again update and save.

I am at a total loss as to what's going on. I can update/save other files in this folder. I can update/save this file from other workstations. I can save this file from this workstation to the same drive/folder with a different name, but I can't save this file to this folder with this particular name!! Help!
0
jmarkfoley
Asked:
jmarkfoley
  • 4
  • 3
1 Solution
 
bbaoIT ConsultantCommented:
it sounds like the given filename contains one or more invalid characters hence it can't be recognised by the W7. do you mind to post the full filename or even the pathname (A-Z and a-z can be censored for privacy concern).

another possible reason is too long pathname. you may verify this by using SUBST command to redirect the full pathname to a short version while keeping the original (problem) filename.
0
 
jmarkfoleyAuthor Commented:
I wish that was it. Full pathname of "bad" file: "X:\Committee - Investment\2016 Investment Reconciliation.xls". Saving this from Excel gives "Document not Saved"

saving same same spreadsheet from Excel with filename  "X:\Committee - Investment\2016 Investment Reconciliation-booga.xls" works and file editable and saveable thereafter.

Deleting original "2016 Investment Reconciliation.xls" and renaming "2016 Investment Reconciliation-booga.xls" to "2016 Investment Reconciliation.xls" causes it to become un-saveable again.
0
 
jmarkfoleyAuthor Commented:
Another wrinkle: Deleting "2016 Investment Reconciliation.xls", but before renaming "2016 Investment Reconciliation-booga.xls", both files show on the workstation's Windows Explorer!

Deleting "2016 Investment Reconciliation.xls", leaves "2016 Investment Reconciliation-booga.xls" showing in Windows Explorer.

Renaming 2016 "Investment Reconciliation-booga.xls" to "2016 Investment Reconciliation.xls" causes the latter to disappear from Windows Explorer! Yet, it is visible in Windows Explorer from other workstations.

Renaming "2016 Investment Reconciliation.xls" to "2016 Investment Reconcile.xls" causes it to re-appear with the new name.

I've disconnected the X: network drive and rebooted the workstation, rebooted the samba host, reconnected the X: drive when the workstation came back up. Everything should have been reset.

What is going on? It's as if this specific file name "2016 Investment Reconciliation.xls" simply WILL NOT WORK on this particular workstation.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
Brian BIndependant Technology ProfessionalCommented:
Since it is involving Samba and not just windows, I added a couple of more groups. Hopefully that will get the attention of more experts.

It almost sounds like some sort of problem with the file allocation table. Just not sure why it would only be to problem on this station.

Not much of the solution, but it sound like permanently giving the file a new name may be the workaround.
1
 
jmarkfoleyAuthor Commented:
Fixed!! There was a shortcut on the user's desktop to this file. The user deleted and re-created the short cut and all is well. He can access the the file with its original "2016 Investment Reconciliation.xls" name.

Now, I specifically DID NOT use the shortcut during my experimentation. I went directly to the folder on the X: drive to open and (attempt to) save the file. Ironically, I did not want to introduce an additional layer of possible problems by using the shortcut.

It seems that if a shortcut exists for a file, attributes of that shortcut are applied to the file whether or not the file is accessed via the shortcut. Does that seem possible?

Before I close this question, I would like someone to comment on this. This seems beyond crazy to me, but then again, this is Windows.
0
 
Brian BIndependant Technology ProfessionalCommented:
Lesson learned about reproducing the problem, I suppose.

The shortcut simply could have been corrupted.

The shortcut and file don't normally have the same properties in Windows. Files normally inherit the properties of the folders where they are contained.
0
 
jmarkfoleyAuthor Commented:
The shortcut certainly must have been corrupted, which is likely why it started working when he recreated it. The puzzler is why I had problems saving and renaming the file when not using the shortcut ? Problems that went away when the shortcut was recreated.
0
 
Brian BIndependant Technology ProfessionalCommented:
Without getting into too long of an explanation, basically windows caches certain information about files and their location. So that cached information may have been corrupted by the bad shortcut.

Anyway, as you saw sometimes it is best to just start over again and see if the problem goes away.

Glad you found your solution. Please don't forget to accept the answers that helped so the question can be closed.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now