{"id":632,"date":"2012-04-19T19:02:04","date_gmt":"2012-04-19T19:02:04","guid":{"rendered":"http:\/\/microsoftgeek.com\/?p=632"},"modified":"2012-04-19T19:02:04","modified_gmt":"2012-04-19T19:02:04","slug":"unable-to-save-ms-excel-spreadsheets-to-a-windows-server-2008-network-share","status":"publish","type":"post","link":"https:\/\/microsoftgeek.com\/?p=632","title":{"rendered":"Unable to save MS Excel spreadsheets to a Windows Server 2008 network share"},"content":{"rendered":"

Yesterday I had an end user call me from one of our branch offices, she said that they store their spreadsheets on a network share;\u00a0 \\\\server_name\\folder_name<\/p>\n

They have this network share mapped as a network drive, so they open the folder location then open a spreadsheet they want to edit, when they try to save it by clicking on the SAVE icon for file > save, the blue saving progress bar gets stuck half way and freezes, it never saves the document, then you can no longer edit the file or save it. You need to either log off or reboot your computer to access the file again.<\/p>\n

After some extensive troubleshooting on the server, network, application level, windows patching. The issue still remained. I did fine some tech forums which suggested some registry fixes on the client and server side to fix this issue. Below is what the end user was experiencing:<\/p>\n

1.\u00a0\u00a0\u00a0 User is working with an Office file opened from a mapped network drive location<\/p>\n

2.\u00a0\u00a0\u00a0 User has full access permission to the folder and correspondingly to the particular file<\/p>\n

3.\u00a0\u00a0\u00a0 User can usually save changes to the file<\/p>\n

4.\u00a0\u00a0\u00a0 User attempts to save ongoing changes either by choosing file \u2013 save or by clicking the save icon<\/p>\n

5.\u00a0\u00a0\u00a0 Office application starts the saving process, green process bar is running up to 30% or 50% approximately<\/p>\n

6.\u00a0\u00a0\u00a0 Office application is not responding anymore, client system freezes so that only hard reset using power button is possible<\/p>\n

7.\u00a0\u00a0\u00a0 After the system reset there is an XXXXXXXX.tmp file created in the mapped drive where XXXXXXXX represents a hex number<\/p>\n

8.\u00a0\u00a0\u00a0 User can open the original file he was working with, changes are not being saved.<\/p>\n

9.\u00a0\u00a0\u00a0 Next attempt to save any changes to the file leads to the sharing violation message (file is in use)<\/p>\n

On the client side you want to create two DWORD Values NetworkResiliency & <\/strong>PivotTableNetworkResiliency<\/strong> here is how:<\/p>\n

Go to Start<\/strong> > type Regedit<\/strong> > OK<\/strong> and go to:<\/p>\n

HKEY_CURRENT_USER > Software > Microsoft > Office > 12.0 > Excel<\/p>\n

    \n
  1. In the left pane, click the Options<\/strong> folder.<\/li>\n
  2. On the Edit<\/strong> menu, point to New<\/strong>, and then click DWORD Value<\/strong>.<\/li>\n
  3. Type NetworkResiliency<\/strong>, and then press ENTER.<\/li>\n
  4. Double-click the NetworkResiliency<\/strong> icon.<\/li>\n
  5. In the Value data<\/strong> box, type 1, and then click OK<\/strong>.<\/li>\n
  6. On the Edit<\/strong> menu, point to New<\/strong>, and then click DWORD Value<\/strong>.<\/li>\n
  7. Type PivotTableNetworkResiliency<\/strong>, and then press ENTER.<\/li>\n
  8. Double-click the PivotTableNetworkResiliency<\/strong> icon.<\/li>\n
  9. In the Value data<\/strong> box, type 1<\/strong>, and then click OK<\/strong>.<\/li>\n<\/ol>\n

    These changes take effect the next time that you start Excel. For both registry keys, setting the key to 0<\/strong> turns the setting off and 1<\/strong> turns the setting on.<\/p>\n

    \"\"<\/p>\n

    On the Windows Server 2008 machine you want to disable the SMB (Server Message Block) 2.0 protocol.<\/p>\n

    1.\u00a0 Disable SMB 2.0 using the description here<\/strong><\/p>\n

    a. Run “regedit” on Windows Server 2008 based computer.<\/p>\n

    b. Expand and locate the sub tree as follows.<\/p>\n

    HKLM\\System\\CurrentControlSet\\Services\\LanmanServer\\Parameters<\/p>\n

    c. Add a new REG_DWORD key with the name of “Smb2” (without quotation mark)<\/p>\n

    Value name: Smb2<\/p>\n

    Value type: REG_DWORD<\/p>\n

    0 = disabled<\/p>\n

    1 = enabled<\/p>\n

    d. Set the value to 0 to disable SMB 2.0<\/p>\n

    e. Reboot the server.<\/p>\n

    \"\"<\/p>\n

    2. Download and install newest driver for the server\u2019s network interface controller (Only do this step if you notice the NIC drop packets)<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

    Yesterday I had an end user call me from one of our branch offices, she said that they store their spreadsheets on a network share;\u00a0 \\\\server_name\\folder_name They have this network share mapped as a network drive, so they open the folder location then open a spreadsheet they want to edit, when they try to save […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,9,26,6],"tags":[],"class_list":["post-632","post","type-post","status-publish","format-standard","hentry","category-computer-tech-stuff","category-ms-office-07","category-win_7","category-general-2008"],"_links":{"self":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/632","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=632"}],"version-history":[{"count":3,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/632\/revisions"}],"predecessor-version":[{"id":635,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/632\/revisions\/635"}],"wp:attachment":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}