Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel file saving problem in the network


14 Jul 2013   #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 pcs 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 Windows 7 pc.
I have changed the below settings also in the Windows 7 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 pcs winxp OS nothing happened.
I changed the settings in Windows 7 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 System SpecsSystem Spec
.

15 Jul 2013   #2

Dual Boot: Windows 7 Pro & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
 
 

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 System SpecsSystem Spec
15 Jul 2013   #3

 
 

Im not sharing any files from Windows 7 pc, only on winxp pc, excel files I want to edit from Windows 7 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 Windows 7 sharing settings? Now that option is OFF. If it's ON, this problem comes always.

Any idea?
My System SpecsSystem Spec
.


15 Jul 2013   #4

Dual Boot: Windows 7 Pro & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
 
 

Quote:
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 System SpecsSystem Spec
15 Jul 2013   #5

 
 

All ways im opening the excel file from Windows 7 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
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 System SpecsSystem Spec
15 Jul 2013   #6

Dual Boot: Windows 7 Pro & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
 
 

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 System SpecsSystem Spec
15 Jul 2013   #7

Dual Boot: Windows 7 Pro & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
 
 

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 System SpecsSystem Spec
15 Jul 2013   #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 System SpecsSystem Spec
15 Jul 2013   #9

Dual Boot: Windows 7 Pro & Server 2012r2 VMs: Kali Linux, Backbox, Matriux, Windows 8.1
 
 

Quote   Quote: Originally Posted by nalin74 View Post
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 System SpecsSystem Spec
15 Jul 2013   #10

 
 

no no, if from xp pc that file open, when im opening from Windows 7 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
Excel file saving problem in the network-2nd-mess.jpg  
Attached Images
 
My System SpecsSystem Spec
Reply

 Excel file saving problem in the network




Thread Tools




Our Sites

Site Links

About Us

Find 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 03:08 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33