Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Difference in SMB performance between Excel 2007 and prior

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Maurice - 27 Mar 2008 20:26 GMT
Hello all,

I'm not sure if this is the correct forum for this, but I'll take a stab at
it.

For the past three months or so, we've beeen dealing with a problem where
opening Excel documents over a VPN connection (SMB) is painfully slow.   For
example a 500k file can take 2-5 minutes to open.   We've troubleshot our VPN
and server configurations and could not find any problems.   But recently I
stumbled across an interesting find --

When we open our documents using Excel 2007 over the VPN, there is almost no
delay at all; and we've tried it on several different machines with 07.   But
we can try it at the same time with a client running Excel 2003 and we have
to wait minutes.

So does anyone know if something changed with 07 to improve SMB performance?
And if so, is there anyway to apply that change to earlier versions of Excel?

Thanks!
MJ
windsurferLA - 28 Mar 2008 04:10 GMT
Answer at bottom.

> Hello all,
>
[quoted text clipped - 17 lines]
> Thanks!
> MJ

The difference may be related to how the data is stored.

EXCEL2007 stores data in the XMLDSig format, while Excel2003 uses the
format Excel97 - Excel2003 format.  Thus a client running Excel2003
examining Excel2007 data will first have to do a conversion.  One
website says, "Excel 97-2003 files are OLE compound documents, which
are, essentially, file systems inside a single file."

From what I've read, Excel 97-2000 file format was design for speed on
slow machines without attention to compatibility.  Excel2007 takes into
account that new machines are real fast, and sacrifices speed for
compatibility.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.