Just had a brief walk through of a monster .xls (about 50 megs) that caches
about 500,000 lines of data and does various presentations of it.

I couldn't find any way to actually see said data - but I'm taking somebody's
word that it's there.

Anybody have any idea how that might have been done?
--
PeteCresswell

It might be the beta of next excel version (Office 2007 for now but might be
2008 before it arrives)
it has 1 million rows and about 16000 columns. Otherwise they need to
portion out the data over multiple sheets

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"(PeteCresswell)" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Just had a brief walk through of a monster .xls (about 50 megs) that
> caches
> about 500,000 lines of data and does various presentations of it.
>
> I couldn't find any way to actually see said data - but I'm taking
> somebody's
> word that it's there.
>
> Anybody have any idea how that might have been done?
> --
> PeteCresswell

(PeteCresswell) wrote:
> Just had a brief walk through of a monster .xls (about 50 megs) that caches
> about 500,000 lines of data and does various presentations of it.
>
> I couldn't find any way to actually see said data - but I'm taking somebody's
> word that it's there.
>
> Anybody have any idea how that might have been done?

Well, I can guess ways that it *might* be done, but that really does
not give you any information about how it is done. For example:
It might open a new workbook, copy some chunk into a sheet
of that book, save that book, and close it. Getting stuff back
is just the reverse. The other workbooks might even be
pre-existing with base data or helper VBA code in them,
maybe graphs etc. pre-created.

But that is certainly not the only way.
Socks

Per Puppet_Sock:
>is just the reverse. The other workbooks might even be
>pre-existing with base data or helper VBA code in them,
>maybe graphs etc. pre-created.
>
>But that is certainly not the only way.
>Socks

I was thinking more in terms of some kind of object that I'd never heard of...
--
PeteCresswell