 |
 | 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 / November 2007Advice re: Excel
I have been using Office 97 for several years (primarily Excel and Word) and realize that it is no longer supported by MS, but since it still worked and I couldn't afford to update, I just kept rolling along. Last night however, I attempted to open one of my Excel files and got a notice that some file within Excel couldn't be located and that I should upgrade immediately! Now I can get into some of my files but not others --bummer!! I really cannot afford to run out and purchase a new Office Suite and do not yet feel comfortable using Open Office, do was wondering if I can just reload my old Excel and continue to use it to rescue some of my files and limp along until I can get a newer Office Suite. I've never seen any version of excel that gives a message that you should upgrade. You may want to share the exact message that you got and what you were doing (be specific as possible) when you got it. > I have been using Office 97 for several years (primarily Excel and Word) > and realize that it is no longer supported by MS, but since it still [quoted text clipped - 8 lines] > just reload my old Excel and continue to use it to rescue some of my > files and limp along until I can get a newer Office Suite.  SignatureDave Peterson I agree with Dave........something else must be going on.........I work at a company that has over 1000 computers, most of which are still using XL97 very happily......we've never seen that "upgrade message". Please come back with more details. Vaya con Dios, Chuck, CABGx3 > I've never seen any version of excel that gives a message that you should > upgrade. [quoted text clipped - 14 lines] > > just reload my old Excel and continue to use it to rescue some of my > > files and limp along until I can get a newer Office Suite. > I agree with Dave........something else must be going on.........I work at a > company that has over 1000 computers, most of which are still using XL97 very [quoted text clipped - 24 lines] >>> just reload my old Excel and continue to use it to rescue some of my >>> files and limp along until I can get a newer Office Suite. Well, it came as such a shock, I failed to try to copy it and didn't write down any of the details. Next time I'll know better, if there is a next time. As I mentioned, I can now get into some of my files, and not others -- about 50-50. I guess my major question now is, should I be able to reload Excel (I still have my original disk) and hopefully/possibly recover the my missing files? Big John (CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know what this means) What happens when you try to open the troublesome workbooks? Write down any message you get <bg>. And share the details of what you're doing when it fails. I'm not sure if reinstalling excel will fix anything (but it shouldn't hurt). <<snipped>> > Well, it came as such a shock, I failed to try to copy it and didn't > write down any of the details. Next time I'll know better, if there is a [quoted text clipped - 8 lines] > (CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know > what this means) SignatureDave Peterson >(CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know >what this means) Dave does, but I'm not sure how many others here do. As for your problem about opening files.........is it possible that someone else opened and saved them back in place using a higher version of Excel? Vaya con Dios, Chuck, CABGx3 > > I agree with Dave........something else must be going on.........I work at a > > company that has over 1000 computers, most of which are still using XL97 very [quoted text clipped - 36 lines] > (CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know > what this means) >>(CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know >>what this means) >Dave does, but I'm not sure how many others here do. I do. If you remember, I asked you. (and Dave replied as well) Hope you guys are doing well! Happy Thanksgiving. SignatureBiff Microsoft Excel MVP > >(CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know >>what this means) [quoted text clipped - 56 lines] >> (CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know >> what this means) Yeah Biff, I remember now sorry........but I even had to look up the "St. Jude AV" thing, I had not heard of it before. Happy Thanksgiving to you and yours as well, Vaya con Dios, Chuck, CABGx3 > >>(CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know > >>what this means) [quoted text clipped - 64 lines] > >> (CABGx3, also Chuck - plus a St.Jude AV)( I wonder how many folks know > >> what this means) >I've never seen any version of excel that gives a message that you should >upgrade. I've gotten that message following a crash of Outlook 2002. OL Crashes Message Box: (paraphrase) OL has shut down. Do you want to send a report to MS? Answer YES to the above. Reply from MS is that they cannot fix the problem, and I should upgrade. So the message doesn't really come from Outlook, but rather is generated by the error reporting mechanism set up from MS. I wonder if the OP's sequence is similar. I've not had an Excel 2002 crash, so I don't know if I would get a similar "upgrade" message. --ron I guess those reports go through MS's marketing group first <bg>. And keep those fingers crossed -- you've had an excellent track record with xl2002. > >I've never seen any version of excel that gives a message that you should > >upgrade. [quoted text clipped - 15 lines] > I don't know if I would get a similar "upgrade" message. > --ron SignatureDave Peterson >I've not had an Excel 2002 crash Do you want to experience one? I also run 2002 and can crash mine at will! Version: 10.6823.6825 SP3 Consider this innocuous array formula: =IF(A1>0,(MATCH(TRUE,A2:A10>0,0)-1)*A1,"") Paste that formula in cell B1 (array entered) Enter a number in cell A1. (any number, doesn't matter) Select cell B1 then goto Tools>Formula Auditing>Evaluate Formula Click the Evaluate button twice, click it again and it will be evaluating this expression: A2:A$10>0 Crash! SignatureBiff Microsoft Excel MVP > On Wed, 21 Nov 2007 13:13:27 -0600, Dave Peterson > <petersod@verizonXSPAM.net> [quoted text clipped - 22 lines] > I don't know if I would get a similar "upgrade" message. > --ron >Enter a number in cell A1. (any number, doesn't matter) Well, any number >0. You want the value_if_true to evaluate. SignatureBiff Microsoft Excel MVP > >I've not had an Excel 2002 crash > [quoted text clipped - 45 lines] >> I don't know if I would get a similar "upgrade" message. >> --ron >>I've not had an Excel 2002 crash > [quoted text clipped - 18 lines] > >Crash! Yup, that does it. And the message from the "crash message" at http://wer.microsoft.com/responses/Response.aspx/2803/en-us/0.0.0000.0.00000000. 0.0?SGD=d5338636-6853-4b96-99dd-63192f632050 includes: Problem caused by Microsoft Excel 2002: consider upgrading The problem was caused by Microsoft Excel 2002, which was created by Microsoft Corporation. Microsoft Excel 2002 is in its "Extended Support" phase. This phase of support for Microsoft Excel 2002 began on July 11, 2006. Only security-related solutions are created by Microsoft for this version of Microsoft Office. Recommendation -------------------------------------------------------------------------------- Consider upgrading to the latest version of Microsoft Office to receive full support. Go online to learn how to upgrade. -------------------------------------------------------------------------------- --ron I've had similar messages when XL2000 crashes and I click to send the report to MS. I suppose they want you to part with some money and get the latest versions. I've stopped sending the messages, as the replies don't help in solving problems. I'm not sure why the OP can't access some of his files now, though. Pete > >>I've not had an Excel 2002 crash > [quoted text clipped - 45 lines] > > - Show quoted text - >>>I've not had an Excel 2002 crash >> [quoted text clipped - 46 lines] > > --ron That was a minor crash. Depending on the complexity of the formula, sometimes it crashes "hard" to where you have to go into Task Manager to regain control of the machine. What's surprising is if that formula was reduced to: =MATCH(TRUE,A2:A10>0,0) And you then do the evaluate formula it will not crash. SignatureBiff Microsoft Excel MVP >>>>I've not had an Excel 2002 crash >>> [quoted text clipped - 58 lines] > > And you then do the evaluate formula it will not crash. P.S. I've learned to recognize what kinds of formulas will cause this and avoid doing an evaluation altogether. However, sometimes I need to find a problem in a really complex formula and if I suspect it will cause a crash I reduce the size of the ranges in the formula to no more than 5 cells. This seems to help prevent the crash. SignatureBiff Microsoft Excel MVP Biff, Sounds like you need to upgrade. <g> SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "T. Valko" wrote in message P.S. I've learned to recognize what kinds of formulas will cause this and avoid doing an evaluation altogether. However, sometimes I need to find a problem in a really complex formula and if I suspect it will cause a crash I reduce the size of the ranges in the formula to no more than 5 cells. This seems to help prevent the crash. -- Biff Microsoft Excel MVP > Sounds like you need to upgrade. <g> Yeah! I can get a really good deal on Office/Excel 2003 but I don't think this particular problem is fixed in that version: Note the version Dave Peterson is using. http://tinyurl.com/q92ty I'm not convinced Excel 2007 is an upgrade! SignatureBiff Microsoft Excel MVP > Biff, > Sounds like you need to upgrade. <g> Biff, To make sure there is no misunderstanding, I was joking. I did get a brand new unopened XL 2003 box, early in the year, on close out from Circuit City for about $30.00. But I hardly ever use it. Nice looking toolbars though. In Steven Roman's "Writing Excel Macros", he claims that MS puts a brand new team on XL every two years. If that is the case, I wonder how problems ever get fixed. That also ought to make the next version of Excel even more interesting. I am still sitting on the curb watching the parade go by and may stay here. Regards, Jim Cone "T. Valko" wrote in message > Sounds like you need to upgrade. <g> Yeah! I can get a really good deal on Office/Excel 2003 but I don't think this particular problem is fixed in that version: Note the version Dave Peterson is using. http://tinyurl.com/q92ty I'm not convinced Excel 2007 is an upgrade! SignatureBiff Microsoft Excel MVP "Jim Cone" wrote in message > Biff, > Sounds like you need to upgrade. <g> > "T. Valko" > wrote in message [quoted text clipped - 7 lines] > to > help prevent the crash. > I have been using Office 97 for several years (primarily Excel and Word) > and realize that it is no longer supported by MS, but since it still [quoted text clipped - 8 lines] > just reload my old Excel and continue to use it to rescue some of my > files and limp along until I can get a newer Office Suite. Yea!! I' glad to hear that someone has had a similar experience - I thought maybe I was losing my marbles!! Now to top it all off -- I gave up on the lost files, shut down and went away. This morning I thought I would try one more time, I rebooted (for about the tenth time) and opened up again just to see if anything had changed (and mourn the loss of my files) --Eureka!! they are back!!! Everything seems to be back to normal and working fine!! Now how do we explain that????????? Hmmmm! Maybe I am losing it!! Anyway, thanks to everyone for their advise and kind words. You can rest assured I will back up, back up, backup on a flash drive so I can at least rescue any files on my other computer. BJ Glad to hear that you got your files back. I don't have an explanation, but I agree that backing up those important files is a very good idea <bg>. <<snipped>> > Now to top it all off -- I gave up on the lost files, shut down and went > away. This morning I thought I would try one more time, I rebooted (for [quoted text clipped - 8 lines] > > BJ SignatureDave Peterson
|
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.