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.