 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007Excel 2007 - non responsive
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. 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. > Background: The issue is on a Vista system running Office 2007. The user > is [quoted text clipped - 10 lines] > > Thank you. Change "and will be recalculated with the workbook is opened." to and will be recalculated when the workbook is opened." 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.  SignatureRegards, Peo Sjoblom > Are you using volatile functions in your workbook? Volatile functions > include: Areas, Cell, Columns, Index, Indirect, Now, Offset, Rand, [quoted text clipped - 19 lines] >> >> Thank you. My Excel books say they are. > 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. [quoted text clipped - 23 lines] >>> >>> Thank you. Which book? SignatureRegards, Peo Sjoblom > My Excel books say they are. > [quoted text clipped - 26 lines] >>>> >>>> Thank you. John Walkenbach's Excel 2003 Formulas > Which book? > [quoted text clipped - 28 lines] >>>>> >>>>> Thank you. I guess I have to send John an email, regardless he is wrong I am right SignatureRegards, Peo Sjoblom > John Walkenbach's Excel 2003 Formulas > [quoted text clipped - 31 lines] >>>>>> >>>>>> Thank you. AHhh - the old forceful Peo, that we all know and love so well ! ! ! <vbg> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- >I guess I have to send John an email, regardless he is wrong I am right > [quoted text clipped - 33 lines] >>>>>>> >>>>>>> Thank you. LOL! You know I am right this time because I have seen the light, or rather http://www.decisionmodels.com/calcsecretsi.htm SignatureRegards, Peo Sjoblom > AHhh - the old forceful Peo, that we all know and love so well ! ! ! <vbg> >>I guess I have to send John an email, regardless he is wrong I am right [quoted text clipped - 34 lines] >>>>>>>> >>>>>>>> Thank you. It's not at all difficult to check it out yourself ... is it? Just open a new WB, and try them ... one by one! SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > John Walkenbach's Excel 2003 Formulas > [quoted text clipped - 31 lines] >>>>>> >>>>>> Thank you. There are no formula's being used. The data was imported in from a text file. > Are you using volatile functions in your workbook? Volatile functions > include: Areas, Cell, Columns, Index, Indirect, Now, Offset, Rand, [quoted text clipped - 17 lines] > > > > Thank you. If the charts are changing, it should be because the data and/or formulas on which the charts are based are changing. > There are no formula's being used. The data was imported in from a text > file. [quoted text clipped - 27 lines] >> > >> > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.