Andrew--
Thanks for your quick answer -- that really helps!
-jason
"Andrew C. Oliver" <[EMAIL PROTECTED]>
02/18/2002 03:34 PM
Please respond to poi-user
To: [EMAIL PROTECTED]
cc:
Subject: Re: "Queries to external data"
On Mon, 2002-02-18 at 14:45, [EMAIL PROTECTED] wrote:
> Hi all,
>
> I'm a POI newbie (BTW, this stuff is great!), with what I am sure is a
> newbie question. When I create a new workbook with POI, and open it in
> Excel (2000), I get this message from Excel:
>
You're in a commmon boat. POI's pretty new. Thanks!
> "This workbook contains queries to external data that refreshes
> automatically. ......"
This is a known issue. At some point MS released a security fix that
added this message. There is a patch on the old site
(sourceforge.net/projects/poi - look under Bugs).. I believe this is
also fixed in CVS.
>
> With options to Enable or Disable automatic refresh. My question is,
what
> is the external data that would be queried? Or is this a bug? (By the
> way, I'm testing with the "HSSF Test" from the web pages)
>
It's basically a bug. Mostly, I had no idea what the property was so I
set it to "true" by default (Excel 97, which I use for testing, doesn't
display this error). So basically your options are:
patch the production sources & build thn it will be set to false by
default
download and build the sources from CVS
wait until version 1.5 which we'll release as an interim production
release (to reflect a few bug fixes/changes/new package names).
Anyhow, sorry about this one. I had to guess...it was a 50-50
chance...I'm not very lucky :-)
> Thanks,
> Jason
--
www.superlinksoftware.com
www.sourceforge.net/projects/poi - port of Excel format to java
http://developer.java.sun.com/developer/bugParade/bugs/4487555.html
- fix java generics!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh
