Solved Cannot save excel files in a redirected folder unles I use save as

[sulik2]

The computer involved is using Windows 7 Pro 64bit and Office Professional Plus 2010.

I am having a problem I cannot find a solution to. I have one user at a clients location that has recently stopped being able to save excel files in their my documents. The my docs is being redirected to a server. The files open correctly and can be edited, but when save is clicked an error box says the document not saved. Using cntrl-shift-i I found the error code to be 100490. I can open any other file and save them just fine. And any new excel documents can be opened and saved correctly. The file can be saved into the same folder using save as is and the document is renamed. However, the user cannot erase the old file.

Doing some digging I made sure the trust zone was enable for the network path and trusted locations on a network were allowed. They had already been configured.

I checked for the windows update that microsoft reported could fix this problem and it was not installed. I went ahead and tried the hotfix, but it would not run because of the missing update.

I tried changing permissions and ownership. This where it gets strange the user has full control enabled on the folder. On any other folder or file I can right click and view the security tab. However, on the excel files when I click the security tab a red line is displayed that says "This file is currently not available for use on this computer." If I try to make a security change on a whole folder any excel files within that folder give an error and say permissions cannot be changed.

Anyone have an idea how to fix this issue?

 

[writhziden]

To resolve this problem, reinitialize the cache of offline files. To do this, follow these steps:

1. Click Start, type regedit in the Start Search box, and then press ENTER.
2. If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.
3. Locate the following registry subkey, and then right-click it: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CSC
4. Point to New, and then click Key.
5. Type Parameters in the box.
6. Right-click Parameters, point to New, and then click DWORD (32-bit)Value.
7. Type FormatDatabase, and then press ENTER.
8. Right-click FormatDatabase, and then click Modify.
9. In the Value data box, type 1, and then click OK.
10. Exit Registry Editor, and then restart the computer.

Taken from http://www.sevenforums.com/network-sharing/4144-gray-x-network-share-folder-icon.html

 

[sulik2]

Thank you that worked perfectly! Saving is working fine now.

 

[Menippos]

yes, but this creates the problem that whatever changes have been made to files after the last successful sync via folder redirect are lost.
This became a reason that I just lost a client.
Please be clearer when you suggest something like this.