|
-----Original Message----- From: Bill [mailto:brobins3d@subdimension.com] >> I'm pretty darn sure that the Excel query . . . is stored on the users >> disk and is not a part of the sheet itself, >Not necessarily true. In fact, I've never had occassion to save the query >to disk; I always use the built-in External Data function which stores the >query definition in the worksheet's QueryTable Collection. BTW, MS Query >is not installed if the defaults are taken on an Office install. >Bill That is interesting, I'd done a custom report on our 400 that created an outfile for a co-worker who then created an excel sheet that would autoupdate with a few sorting parms. When he sent me the sheet I was unable to even open it until he sent me the associated *.dqy file(s). M$ stuff is very YMMV based on which version of office you've got it seems.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
