Solved Saving spreadsheet over the network...

[Cr00zng]

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:



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:



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...

 

[Cr00zng]

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...