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: Saving spreadsheet over the network...

28 Jan 2015   #1
Cr00zng

Windows 7 64-bit, Windows 8.1 64-bit, OSX El Capitan, Windows 10 (VMware)
 
 
Saving spreadsheet over the network...

Mods, please move this thread if this is the wrong forum. Thanks...

This one irks me to no end...

I have a gigi network at home and it is performing as it should, around 125 MBs transfer speed. Here's the result of transferring a single large file of ISO image via copy/paste from PC2 to PC1:

Saving spreadsheet over the network...-gig.jpg

When trying to save an excel spreadsheet on PC1 from PC2, it takes about a minute to save it even if just one line has been added/changed in the spreadsheet. When clicked on save, this is the window that pops up:

Saving spreadsheet over the network...-save.jpg

The spreadsheet is about 400KB with eleven tabs, even opening the spreadsheet takes about the same time as closing it.

Both PCs have Windows 7 Professional 64-bit, with SP1; the excel version of 2010 is the same as well. Both PCs have 8 GBs memory at least and SATA 3 SSD drives. The folders are shared, initially for the "authenticated users" and for testing purposes for "everyone" with full access to the root of the shared folder. Mapping a network drive on PC2 with user credentials of PC1 didn't make a difference, it still takes about a minute to open or save the same file.

This is prevalent with spreadsheets that have 6 or < number of tabs, regardless of the actual file size. Some of the larger and the all of the smaller files open up just fine over the network. All spreadsheets open up just fine on PC1.

Does anyone have an idea how to fix this?

TIA...




My System SpecsSystem Spec
.
31 Jan 2015   #2
Cr00zng

Windows 7 64-bit, Windows 8.1 64-bit, OSX El Capitan, Windows 10 (VMware)
 
 

There's a solution for this issue and it's rather simple, discovered by accident...

One of the excel spreadsheet with this issue had been saved with the .xlsx extension by accident, instead of the the existing .xls extension. Low and behold, the next time around opening the file with .xlsx had no delay. Excel opened/closed/saved the file almost instantly and that's close enough for me.

My guess is that when Excel 2010 opens up a file with the .xls extension, it checks for compatibility that takes some time. The larger the spreadsheet, the longer this time will be. The compatibility check can be disabled on a per file basis, under the file tab "Info\Check for issues\Check for compatibility" clear the check mark for "Check compatibility when you save this workbook". I was not able to find a registry setting, where this could be done globally, instead of the file by file basis...
My System SpecsSystem Spec
Reply

 Saving spreadsheet over the network...




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
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...
Network & Sharing
Saving to Network Drive.
Hi, how can i force domain users to save files to mapped network drive?
Network & Sharing
Having trouble saving word documents to a network drive
I am having an issue on a machine that is running windows 7 and office 2007. This issue started when the machine was updated to windows 7 recently from windows xp. I am opening an Excel spreadsheet from Microsoft Frontpage in our development enviroment. If I attempt to save the file again it...
Network & Sharing
Office 2007 not saving files on the network share, no error msg
Hi One of our users saves powerpoints onto a network share, she has been doing this for years, I upgraded her to office 07 yesterday and this morning she is reporting when she saves a file on the network share it reverts to the previous changes. The thing is when you close the file and reopen...
Microsoft Office
Office 2007 very slow saving to network
I have recently set up a new network and 4 desktops for a client. The server is running Windows Server 2008 and the desktops are all running Windows 7 with Office 2007. When ever the client goes to save a Word or Excel document to a network share, the applications takes 20-30 seconds to save the...
Network & Sharing
Saving to network?
Hi all, I was wanting to save a back up of my complete drive on my other pc using my network....thing is all starts ok, then asks me for a password!!! i haven't set up a password on either pc, there both running windows 7, and I have turned ask for password off on each pc..any ideas on this? Many...
Network & Sharing


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 22:12.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App