Why does Excel crash when I'm using linked files?

  • Thread starter Jimmy Byström
  • Start date
J

Jimmy Byström

I'm developing an application that modifies the data used to generate
diagrams in Excel. Since I can't modify the data directly in an xls-file,
from a Java application, I created two files for excel to work with. One is a
standard xls files with the diagrams in and the second is an xml file which
contains the data that the diagrams refer to. I have no problem setting up
the links and getting the diagram to respond to changes in the xml data file.
To make it easier for the end users to use the program I packed the two files
(the xls and the xml file) together in a workspace file (xlw file) so that
the data for the diagrams are always open when needed.

The problem I have is that Excel continues to crash if I closes the
application while both files (the xls and the xml file) are open or if I
closes the xml file first. It's a minor problem for me while I'm developing
the program but it isn't very nice to send out a program where Excel crashes
once you close files generated by my program.

I hope it is clear what I'm asking and that somebody in here has an answer
to what might be the problem. If you post a respons in here it would be great
if you could send me a copy too, (e-mail address removed).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top