Excel 2007 - non responsive

S

Sheena

Background: The issue is on a Vista system running Office 2007. The user is
creating an excel workbook with 5-7 worksheets. The 1st 2 worksheets have
1000 - 6000 records, the rest of the sheets are graphs and charts that are
created from those records. In one of the charts she is creating a dot
diagram which has 1000-6000 dots plotted on it.

Issue: The spreadsheet with the graphs are changing each time the document
is closed and reopened (dots are changing locations) and the workbook is
constantly becoming non-responsive.

Please advise on what could be causing this issue.

Thank you.
 
W

Wondering

Are you using volatile functions in your workbook? Volatile functions
include: Areas, Cell, Columns, Index, Indirect, Now, Offset, Rand,
Randbetween, Rows, Today. These functions are recalculated anytime the
worksheets are recalculated (if any single formula is recalculated, all the
volatile functions are recalculated too) and will be recalculated with the
workbook is opened.
 
W

Wondering

Change "and will be recalculated with the workbook is opened." to and will
be recalculated when the workbook is opened."
 
P

Peo Sjoblom

INDEX is not a volatile function, it was pre Excel 97, AREAS COLUMNS and
ROWS are not volatile either although documented by MS as such.


--


Regards,


Peo Sjoblom
 
W

Wondering

My Excel books say they are.

Peo Sjoblom said:
INDEX is not a volatile function, it was pre Excel 97, AREAS COLUMNS and
ROWS are not volatile either although documented by MS as such.


--


Regards,


Peo Sjoblom
Click to expand...
 
W

Wondering

If the charts are changing, it should be because the data and/or formulas on
which the charts are based are changing.
 
P

Peo Sjoblom

I guess I have to send John an email, regardless he is wrong I am right


--


Regards,


Peo Sjoblom
 
R

RagDyer

It's not at all difficult to check it out yourself ... is it?

Just open a new WB, and try them ... one by one!
 

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

Similar Threads

Excel 2007 Non-responsive 1
Charts: 2007 to 2003 0
slow calculation of rank and percentile in Excel 2007 3
2007 SP2 breaks Excel Graphics in Save as PDF 0
Generating blank cells in Excel 2007 1
Condensing part of the X-Axis Excel 2007 charts 3
x-y scatter graph and confused 0
No "Chart Option" feature in the FormattingPalette or when double click on Chart 3

Top