Windows - Delayed Write Failed when saving Excel file

Posted on 2007-10-01
Last Modified: 2010-10-05
When trying to save an Excel file to a mapped shared folder on 2003 SBS, the progress bar gets to about 98% then stops and after 20-30 seconds an exclamation icon appears in the system tray with a balloon message  "Windows Delayed Write Failed   Windows was unable to save all the data for the file \\xxxserv1\public2\xxxx\xxxx\F5B67000. The Data has been lost. This error may be caused by a failure of your computer hardware or network connection. Please"

Plenty of disk space is available, no disk quotas, other files can be saved, this file can be saved locally without problems and the file name it quotes is obviously a temporary file during the disk write.

any ideas ?
Question by:orbtechnik
    LVL 70

    Expert Comment

    LVL 4

    Expert Comment

    From previous experience of this sort of problem, either there is a network connectivity issue (probably less likely in your situation), or something is causing the Microsoft opportunistic locking machanism to fail.  Check out the following KB, under 'More Information' - 'To troubleshoot this issue' - check the server's disk queue length (and general disk stats), then the setting that may just fix it for you - disable opportunistic locking.
    Best of luck.

    Author Comment

    changed HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Lanmanserver\Parameters enablesecuritysignature on server and all is ok

    Thanks for the help guys.
    LVL 1

    Accepted Solution

    PAQed with points refunded (125)

    EE Admin

    Expert Comment

    This almost exact issue came up recently after bringing down our Winndows2003 server. We have tried all the fixes listed, does anyone have a resolution specific to Excel? It's only excel files that are having the problem with saving back to the Netowrk drive. Please advise, Thanks.

    Expert Comment

    I would like to know what was changed in the Hkey parameters orbtechnik was speaking of.  I'm having the same issue and haven't found a fix for it yet.

    Expert Comment

    My first comment here on experts exchange :)

    I just resolved this issue on a clients machine.
    The solution i found was to change the NIC Link Speed and Duplex to Full Duplex - 100mb.

    In the network card under the advanced tab > Link Speed & Duplex > 100mb/Full Duplex.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now