Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 16th 04, 03:27 PM
Fysh
 
Posts: n/a
Default Charts causing program to crash

I have a worksheet that has 2 charts on it. When I close(save) the program
and try to open it, it crashes. In other words it shuts down and creates
some kind of Error log. If I close the program on another worksheet then it
is fine. I think what the problem is the other worksheets are being updated
with information from other workbooks. At the same time the chart worksheet
is trying to update itself as well, thus causing it to crash. How can I
prevent this from happening? Also, how do you get back into the program if
this keeps happening? Right now I have a backup, which I will have to edit
if I can't get back into this one. The program is going out to a few people
and I really don't want to cause them any problems. Thanks for any input.

  #2   Report Post  
Old December 16th 04, 10:12 PM
Jon Peltier
 
Posts: n/a
Default

Earlier versions of Excel aren't so stable. XP is pretty good, 97 is pretty bad,
2000 is in between. Sometimes it's enough to open and save the file in XP, then
resume working in 2000 (which doesn't help if all you have is 2000).

Using a lot of formulas and names to define chart source data gives Excel a headache
after a while. Charts aren't as smart as worksheets when it comes to named ranges.
Convoluted chart data seems to make workbooks easier to corrupt. Sometimes I find
that I must rebuild a sheet or entire workbook when it starts to misbehave.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Fysh wrote:

I have a worksheet that has 2 charts on it. When I close(save) the program
and try to open it, it crashes. In other words it shuts down and creates
some kind of Error log. If I close the program on another worksheet then it
is fine. I think what the problem is the other worksheets are being updated
with information from other workbooks. At the same time the chart worksheet
is trying to update itself as well, thus causing it to crash. How can I
prevent this from happening? Also, how do you get back into the program if
this keeps happening? Right now I have a backup, which I will have to edit
if I can't get back into this one. The program is going out to a few people
and I really don't want to cause them any problems. Thanks for any input.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Log charts Robert Peirce Charts and Charting in Excel 2 December 9th 04 09:48 PM
pie charts - how to include "zero" fields on Legends Doug VanOrnum Charts and Charting in Excel 0 November 30th 04 04:49 PM


All times are GMT +1. The time now is 04:50 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017