Excel file saving problem in the network

Page 1 of 2 12 LastLast

  1. Posts : 11
    Windows 7 32bit
       #1

    Excel file saving problem in the network


    I have a problem in saving an excel file on to another pc in the network, which has windows xp. But before I used in both pc’s windows xp & that time there were no problem saving on to the other pc.
    Now I use windows 7 32bit (Service pack1) in my pc & other pc on network is windows xp. Im doing some thing on Microsoft Excel 2007 (password protected file) in windows7 pc & when I saving to windows xp pc, most of the time saving bar displayed & say document not saved. But that time some TMP file will be saved in windows xp pc.
    Im opening the excel file from network windows xp pc & im doing the amendments from windows7 pc & saving back to winxp pc.
    Original file is at winxp pc. Im opening it from win7 pc.
    I have changed the below settings also in the win7 pc. But only some times this problem occurs. Some times I can save smoothly.
    I wanted to know why this problem comes only some times.
    I must say when I using in both pc’s winxp OS nothing happened.
    I changed the settings in win7 pc as below,
    *Network discovery – off
    *Enable file sharing for devices that use 40 or 56 bit encryption
    Please give me a help how to solve this saving issue.
      My Computer


  2. Posts : 1,810
    Dual Boot: Windows 8.1 & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
       #2

    First of all, you're going to want Network Discovery turned on if you're sharing files on the network.

    Is this only one file, only on excel, or is this a random problem saving ANY files on the network.

    Please make sure each computer has full permissions over the file you are trying to edit.
      My Computer


  3. Posts : 11
    Windows 7 32bit
    Thread Starter
       #3

    Im not sharing any files from win7 pc, only on winxp pc, excel files I want to edit from win7 pc.

    And also I gave full permission from each computer. Only this problem comes some times. Not all ways. Before I saving if I access other pc some files then I saved after that, it saves with no issue.

    What is the meaning of Network discovery in win7 sharing settings? Now that option is OFF. If it's ON, this problem comes always.

    Any idea?
      My Computer


  4. Posts : 1,810
    Dual Boot: Windows 8.1 & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
       #4

    Network discovery is a network setting that affects whether your computer can find other computers and devices on the network and whether other computers on the network can find your computer.

    There are three network discovery states:

    On

    This state allows your computer to see other network computers and devices and allows people on other network computers to see your computer. This makes it easier to share files and printers.

    Off

    This state prevents your computer from seeing other network computers and devices and prevents people on other network computers from seeing your computer.

    Custom

    This is a mixed state in which some settings related to network discovery are enabled, but not all of them. For example, network discovery could be turned on, but you or your system administrator might have changed firewall settings that affect network discovery.

    Network discovery requires that the DNS Client, Function Discovery Resource Publication, SSDP Discovery, and UPnP Device Host services are started, that network discovery is allowed to communicate through Windows Firewall, and that other firewalls are not interfering with network discovery. If some but not all of these are true, the network discovery state will be shown as Custom.

    To turn on network discovery
    Click to open Advanced sharing settings.

    Click the chevron Picture of the chevron icon to expand the current network profile.

    Click Turn on network discovery, and then click Save changes. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

    Network locations
    When you connect to a network, you must choose a network location. There are four network locations: Home, Work, Public, and Domain. Based on the network location you choose, Windows assigns a network discovery state to the network and opens the appropriate Windows Firewall ports for that state. For more information about network locations, see Choosing a network location.
    Can you tell me in what situation does this happen every time? Like for example, if you save it a certain way and try to bring it back over to XP, it wont save every time... does something like that happen, or is this completely random?
      My Computer


  5. Posts : 11
    Windows 7 32bit
    Thread Starter
       #5

    All ways im opening the excel file from win7 pc & file located in network xp pc. When i coming to office im opening in the morning & editing the file & when saving this issue comes. Today i saved from the morning 1st three times, smoothly it saved, but 4th time when i saved, it wont. so again i have to browse the network xp pc & have to save.
    It automatically indicating a moving shaded bar going on the top searching the network. see the screen shot, now also that network xp pc not connected.
    This issue comes just after the saving failure occurs.
    Pls see the 2nd screen shot. when i click on one file this searching bar going.
    Pls check the TMP files created when the saving fails. screen shot 3
    Attached Thumbnails Attached Thumbnails Excel file saving problem in the network-sc1.jpg   Excel file saving problem in the network-sc2.jpg   Excel file saving problem in the network-sc3.jpg  
      My Computer


  6. Posts : 1,810
    Dual Boot: Windows 8.1 & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
       #6

    By any chance, does this happen when you try to save the file and both PC's have the file open via the network?
      My Computer


  7. Posts : 1,810
    Dual Boot: Windows 8.1 & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
       #7

    If I understand you correctly, (this article) should do a good job of explaining what is going on.

    Another link that may be of use to you: Temporary files do not synchronize correctly to a non-DFS share on a server from a client computer that is running Windows 7 or Windows Server 2008 R2
      My Computer


  8. Posts : 11
    Windows 7 32bit
    Thread Starter
       #8

    no no, only i opened from the network. But why some times saving & some times not?
    why that TMP file created every time saving not occurred?
      My Computer


  9. Posts : 1,810
    Dual Boot: Windows 8.1 & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
       #9

    nalin74 said:
    no no, only i opened from the network. But why some times saving & some times not?
    why that TMP file created every time saving not occurred?
    Sorry if I'm being redundant here but I want to make sure of this...

    Is there ever a time where you leave the file open on the machine running XP, then go to your machine running Windows 7 and open the file from the network, edit it, then save it (while the file is open on the other PC)?
      My Computer


  10. Posts : 11
    Windows 7 32bit
    Thread Starter
       #10

    no no, if from xp pc that file open, when im opening from win7 pc, it gives me as read only file.
    But im the one who opening 1st, but from network.
    can you tell me why that searching bar going? GREEN bar in the screen shot.
    If once connected to the network xp pc, why again searching? my question is that?

    Here i attached two screen shots, when the saving error occurred.
    1st coming saving window & it not goes, then i click cancel, it gives document not saved window & created the TMP file.
    Attached Thumbnails Attached Thumbnails Excel file saving problem in the network-1st-mess.jpg   Excel file saving problem in the network-2nd-mess.jpg  
      My Computer


 
Page 1 of 2 12 LastLast

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 11:42.
Find Us