| 132 | I'm using Excel Version 5.0 on a new Dell Windows XP system. Original data files were recovered from an old PC, which has harddrive problems by a tech using Excel 2000 and now I can't retrieve/open them with V5.0. It was suggested that I upgrade, which I have tried to load Excel 2002 Upgrade and I received error 1608 which means, could not find any previously installed compliant products on the machine for installing this product. I let Windows automatically locate Excel V5 (in C:\Documents & Settings\Janet\Desktop - even in this location I could double click the icon on my desktop and it would open up and I could open a file. I even moved (dragged within Windows Explorer) the Excel V5 folder to the Program Files directory and still I was unsuccessful in loading Excel 2002 Upgrade - received the same error code of 1608. I also installed Lotus SmartSuite V4, (1995) from CD and Excel V5 (Disk 1-9, 3.5")and they were both placed in the same directory automatically. C:\Document & Settings\Janet\Desktop and neither program appears under the Control Panel, Add/Remove Programs. But what does appear is all software that came preloaded and 1 other 2002 that I installed from a CD that is XP compatible. Software preloaded was only Windows XP that includes MS Works, etc. and Dell programs included in the January 2002 special. I was going to uninstall V5 and start over, but it doesn't show up in the Control panel Add/Remove Prog. Any and all help is deeply appreciated, at 58 this is about to get to me. Thanks, Bay |
| 141 | Thanks so much for posting. What would you do with the same problem. Can the tech reverse my data from his 2000 Excel back to the original V5. Is there a valid upgrade..... Excel 2000 / 2001? I need to be able to use existing files. Again, thanks for taking the time to help. Janet "Bay" -----Original Message----- Excel 5 ==== Excel 2002 is not a valid upgrade.. -- Regards, Peo Sjoblom "Bay" <jebn60@msn.com wrote in message news:dc8f01c21636 $2790eed0$a4e62ecf@tkmsftngxa06... I'm using Excel Version 5.0 on a new Dell Windows XP system. Original data files were recovered from an old PC, which has harddrive problems by a tech using Excel 2000 and now I can't retrieve/open them with V5.0. It was suggested that I upgrade, which I have tried to load Excel 2002 Upgrade and I received error 1608 which means, could not find any previously installed compliant products on the machine for installing this product. I let Windows automatically locate Excel V5 (in C:\Documents & Settings\Janet\Desktop - even in this location I could double click the icon on my desktop and it would open up and I could open a file. I even moved (dragged within Windows Explorer) the Excel V5 folder to the Program Files directory and still I was unsuccessful in loading Excel 2002 Upgrade - received the same error code of 1608. I also installed Lotus SmartSuite V4, (1995) from CD and Excel V5 (Disk 1-9, 3.5")and they were both placed in the same directory automatically. C:\Document & Settings\Janet\Desktop and neither program appears under the Control Panel, Add/Remove Programs. But what does appear is all software that came preloaded and 1 other 2002 that I installed from a CD that is XP compatible. Software preloaded was only Windows XP that includes MS Works, etc. and Dell programs included in the January 2002 special. I was going to uninstall V5 and start over, but it doesn't show up in the Control panel Add/Remove Prog. Any and all help is deeply appreciated, at 58 this is about to get to me. Thanks, Bay . |
| 257 | In article <ddb301c21653$64edfc10$36ef2ecf@tkmsftngxa12, "Bay" <jebn60@msn.com wrote: This 1997 or greater would need to be an upgrade version - correct? The tech that recovered the files did say he couldn't guarantee me that if he retrieved and resaved, it might not work - 2 out of 2. I better go shopping. He needed to "save as" the file as a previous version (XL 5 for instance). Even in the current XP based version of xl we have, there is an option to do that. I suggest the tech hasn't finished the recovery job you asked them to do :) Go back and ask them to do it properly ... there is no reason to upgrade xl 5 if you only want to use xl 5 files ... always assuming you can still run xl 5 :) Bruce -----Original Message----- If I understand correctly, you have files that xl97 (or greater) based. But all you have on your new pc is xl95. Do you know someone with xl97 (or greater)? Maybe you could share a copy of your files with them. They could open each one and save it back down to the xl95 version. (Be careful though. If you used anything that was added in xl97, xl2000, it might not be "downgradeable".) I _think_ that xl97 is a valid starting point to upgrade to xl2002. Maybe you can find a (cheap) version on Ebay. Then you can load that version and then upgrade. Bay wrote: Thanks so much for posting. What would you do with the same problem. Can the tech reverse my data from his 2000 Excel back to the original V5. Is there a valid upgrade..... Excel 2000 / 2001? I need to be able to use existing files. Again, thanks for taking the time to help. Janet "Bay" -----Original Message----- Excel 5 ==== Excel 2002 is not a valid upgrade.. -- Regards, Peo Sjoblom "Bay" <jebn60@msn.com wrote in message news:dc8f01c21636 $2790eed0$a4e62ecf@tkmsftngxa06... I'm using Excel Version 5.0 on a new Dell Windows XP system. Original data files were recovered from an old PC, which has harddrive problems by a tech using Excel 2000 and now I can't retrieve/open them with V5.0. It was suggested that I upgrade, which I have tried to load Excel 2002 Upgrade and I received error 1608 which means, could not find any previously installed compliant products on the machine for installing this product. I let Windows automatically locate Excel V5 (in C:\Documents & Settings\Janet\Desktop - even in this location I could double click the icon on my desktop and it would open up and I could open a file. I even moved (dragged within Windows Explorer) the Excel V5 folder to the Program Files directory and still I was unsuccessful in loading Excel 2002 Upgrade - received the same error code of 1608. I also installed Lotus SmartSuite V4, (1995) from CD and Excel V5 (Disk 1-9, 3.5")and they were both placed in the same directory automatically. C:\Document & Settings\Janet\Desktop and neither program appears under the Control Panel, Add/Remove Programs. But what does appear is all software that came preloaded and 1 other 2002 that I installed from a CD that is XP compatible. Software preloaded was only Windows XP that includes MS Works, etc. and Dell programs included in the January 2002 special. I was going to uninstall V5 and start over, but it doesn't show up in the Control panel Add/Remove Prog. Any and all help is deeply appreciated, at 58 this is about to get to me. Thanks, Bay . -- Dave Peterson ec35720@msn.com . -------------------------------------------------------------------- Oook ! NOTE remove the not_ from the address to reply. NO SPAM ! |
| 538 | Excel 2002 Power Programming With VBA by John Walkenbach is one (I have that one), he also wrote a dummies book although I would never buy a dummies book albeit being one, it's too insulting <g -- Regards, Peo Sjoblom "ikr" <ripsher[nospam]@btinternet.com wrote in message news:O$uAHWhGCHA.2684@tkmsftngp10... Can anyone recommend a good book for learning Excel (2k) VBA for absolute beginners? |
| 540 | Hi Ken, If you are talking about restoring from the CD that takes care of the most important part don't do anything to the existing file. If you have the file on the hard drive copy it to another file and work only from the copied file(s). Did you try opening the file without macros and without addins. (in Safe Mode) The most painless solution is obtain Java from Sun Microsystems www.sun.com and Open Office from www.openoffice.com The openoffice is the same as what Sun used to supply free in StarOffice but gave the source code free for open office and now charges for StarCalc. Believe it or not!, some companies prefer to pay, thinking they will get better service if it breaks -- I'm sure not is not your main concern. You would be downloading about 90-120MB of data from those two sites so you would definitely need to have broadband or have someone download them to a CD for you. Other painless solutions (only painless if they work) is to have someone try to read the file on their system preferable Excel 2002 which is supposed to have more recovery ability. But even if you can only find someone with Excel 97 or 2000 or a Mac comparable version they may be able to read your file. If they can they should make a copy and another copy without your most recent sheet worked on. BTW, anybody reading your file should be checking for viruses before attempting to read your file. The second half of my Backup and Recovery page is concerned with Recovery. /dmcritchie/excel/backup.htm Good Luck, these solutions are probably as good as commercial solutions. Please report back your results, including any information as to why you think the copy of the CD got messed up, or was it just copied after the file was destroyed. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Rusty" <rusty@theseams.com.au wrote in message news:3d14b62b$0$28007$afc38c87@news.optusnet.com.au... My daughter's PC crashed and she can't read the backup of her most important Excel file from a CD. Is there a freeware or shareware utility that I can use to recover the file? She can't afford to pay USD$90 for the commercial programs. Thanks for your suggestions. Ken Russell Sydney |
| 599 | In most versions of Excel, if the worksheet is protected, users will not be able to change the cell formatting, which includes the borders, font colour, font size and cell colour. In Excel 2002, you can choose options as you set the protection, and cell formatting can be allowed. Maybe you have protected the workbook, instead of the worksheet. arthur w. mohr, jr. wrote: How can I protect the format of a worksheet. For example; frame around a cell font size and color cell color I have protect all attributes of the worksheet using tools/protect but the users of the worksheet are still able to modify the items mentioned above. Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 602 | Thanks for this recommendation. Does it matter that John's book covers XL2002 (and I have XL2000)? In other words, is the VBA the same 'version' for each? "Peo Sjoblom" <terre08@mvps.org wrote in message news:e8g6CxhGCHA.2580@tkmsftngp09... Excel 2002 Power Programming With VBA by John Walkenbach is one (I have that one), he also wrote a dummies book although I would never buy a dummies book albeit being one, it's too insulting <g -- Regards, Peo Sjoblom "ikr" <ripsher[nospam]@btinternet.com wrote in message news:O$uAHWhGCHA.2684@tkmsftngp10... Can anyone recommend a good book for learning Excel (2k) VBA for absolute beginners? |
| 607 | Thank you for your comprehensive reply. "Peo Sjoblom" <terre08@mvps.org wrote in message news:e$g#P8rGCHA.612@tkmsftngp08... There are some new things that relates to 2002 only but on the whole everything you need for 2000 is there as well, I think that it could be named "Microsoft Excel 2000/2002: Power Programming with VBA, there is a 2000 version named "Microsoft Excel 2000: Power Programming with VBA", don't know if it is still in print but a quick web search at half.com turned up several new copies.. Since 2002 is the latest version I'd recommend that book in case you have to work with someone who has 2002... -- Regards, Peo Sjoblom "ikr" <ripsher[nospam]@btinternet.com wrote in message news:Oi5MweqGCHA.2568@tkmsftngp10... Thanks for this recommendation. Does it matter that John's book covers XL2002 (and I have XL2000)? In other words, is the VBA the same 'version' for each? "Peo Sjoblom" <terre08@mvps.org wrote in message news:e8g6CxhGCHA.2580@tkmsftngp09... Excel 2002 Power Programming With VBA by John Walkenbach is one (I have that one), he also wrote a dummies book although I would never buy a dummies book albeit being one, it's too insulting <g -- Regards, Peo Sjoblom "ikr" <ripsher[nospam]@btinternet.com wrote in message news:O$uAHWhGCHA.2684@tkmsftngp10... Can anyone recommend a good book for learning Excel (2k) VBA for absolute beginners? |
| 615 | Buck, XL97 will be fine to learn on. -- Regards from Virginia Beach, EarlK ------------------------------------------------------------- "buckjordan" <buckjordan@thegrid.net wrote in message news:IDsR8.26332$uH2.982@newsread1.prod.itd.earthlink.net... Peo Sjoblom & ikr commented on the worth of a textbook on Excel 2002 vs. 2000. I have 97 SR, and at a low level of learning (i.e. a beginner). Am I a little out of date, way out of date or what. Do I need a newer version? Comments from both above and anyone else appreciated. -------------------------------------------------------------------------- -- ---- Richard B. Jordan buckjordan@thegrid.net (Fresno)559-439-9550 (Cambria)805-927-3897 (Fresno Fax)559-447-0124 |
| 737 | You could use a Pivot Table (instructions for Excel 2002 -- other versions will vary slightly). 1. Add a heading to each column (e.g. Letter, Number) 2. Select a cell in the list. 3. Choose DataPivotTable and PivotChart Report 4. Click Next, check the range, click Next 5. Click Layout. 6. Drag the Letter button to the Row area 7. Drag the Number button to the Data area, where it will become Sum of Number. 8. Click OK, click Finish Barry Bean wrote: I'm trying to set up a few templates in Excel to have the same functionality as my 123 spreadsheets. One function I haven't been able to find is aggregate. For instance, in lotus 123 I can convert the following list: A 7 B 6 c 1 A 4 B 2 To: A 11 B 8 c 1 How do I accomplish the same thing in Excel? -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 747 | Mel, What version of Excel are you using? In Excel 2002, you would go to Tools - Macro - Security and then on the Trusted Sources tab, check the box: Trust all installed add-ins and templates. Paul "Mel" <shakey@sonic.net wrote in message news:3D18F17A.5AC5C7CD@sonic.net... I do not know what I did but lately I must go thru three screens of marco warnings to open a blank or any excel sheet. First--- C:\whatever\library\sumif.xla then-----C:\whatever\analysis\analys32.xll then-----c:\whatever\start\personal.xls I can understand peresonal and then my requested sheet as they are medium security but what made the first two start requesting permission, they are of MS origion and should always be safe. Mel S. -- Nothing will ever be attempted if all possible objections must first be overcome. |
| 752 | Paul Watson wrote: Mel, What version of Excel are you using? In Excel 2002, you would go to Tools - Macro - Security and then on the Trusted Sources tab, check the box: Trust all installed add-ins and templates. Paul "Mel" <shakey@sonic.net wrote in message news:3D18F17A.5AC5C7CD@sonic.net... I do not know what I did but lately I must go thru three screens of marco warnings to open a blank or any excel sheet. First--- C:\whatever\library\sumif.xla then-----C:\whatever\analysis\analys32.xll then-----c:\whatever\start\personal.xls I can understand peresonal and then my requested sheet as they are medium security but what made the first two start requesting permission, they are of MS origion and should always be safe. Mel S. -- Nothing will ever be attempted if all possible objections must first be overcome. Thanks Paul, That works in 2000 version as well. Darned if I know how it got unchecked. Mel -- Nothing will ever be attempted if all possible objections must first be overcome. |
| 774 | You could use Word Art, and rotate it 180 degrees. In Excel 2002 you can copy a picture of a cell (hold Shift key, choose EditCopy Picture) and rotate the picture. Rhoda Chow wrote: For some formatting reason I need to display the words in a cell flipped upside down. I know in format cell Alignment direction I can change the directions of the words but it limit me to +/- 90 degree. What I need is 180 degree. Can anybody help? Thanks a lot. Rhoda -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 813 | May I take the opportunity to add my 2 cents worth? I started with Excel in Excel 95. I learned maybe 60% of what I know about Excel from the Help files, and the rest from these newsgroups. I now have Excel 2002. And I am hugely disappointed with the change in the Help files in both Word and Excel. If N. Squire (the OP) happens to be using Excel 2002 and went searching in Help, as you might, for "horizontal scroll bar" he would have been faced with 20 possible pages of information. On my system, the first few are: "Insert subtotals", "Include different data in an offline cube", "Troubleshoot security and protection". None of the 20, from what I can see, mentions the horizontal scroll bar on the side of a worksheet or mentions Tools | Options etc. No wonder he can't find what he needs! I used to feel confident that I could tell people that they could find the information they needed in the Help files. I'm no longer confident enough to say that and send them, instead, to the nearest bookshop in search of John Walkenbach's books. With due respect, thanks, praise and genuflection, such books should be an adjunct to, not a replacement for, Help files that are structured such that users can find what they need. Maybe it's just me. But I find the new Help file system imponderable. Perhaps those of you who have Microsoft's collective ear could point out that this is not supporting the company's publicly-stated corporate policy of being driven by the market and making it easy for the user. Anne "Harald Staff" <harald.staff@eunet.no wrote in message news:u6i6$MGHCHA.2604@tkmsftngp11... Hi John Some folks must fight (or worse; persuade) the paperclip to be allowed to enter Help. It is very exhausting, especially on international systems. So I'd prefer a MVP or a tech writer answering <g. Best wishes Harald "John Walkenbach" <john@j-walk.com wrote in message news:epCpV3FHCHA.2652@tkmsftngp11... FYI, answers to these types of questions are readily available in Excel's Help system. You might find that approach more efficient than posting to a newsgroup. |
| 918 | If you still have your Excel 2000 disks, you can try the tip on this page: Getting What's Missing in Excel 2002 /winplanet/tips/3997/1/ Mackeby wrote: Excel 2000 allowes you to create a geographical map and associate with data. I have upgraded to Office XP and am not having success at finding the map in Excel anymore. Is this still an option provided with Excel? If so, how do you hook it back up? Thanks for the help! Mackeby -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 930 | Thanks - I did the next best thing! I reinstalled office 2000. I was not happy with Office XP for many different reasons. Mackeby -----Original Message----- If you still have your Excel 2000 disks, you can try the tip on this page: Getting What's Missing in Excel 2002 /winplanet/tips/3997/1/ Mackeby wrote: Excel 2000 allowes you to create a geographical map and associate with data. I have upgraded to Office XP and am not having success at finding the map in Excel anymore. Is this still an option provided with Excel? If so, how do you hook it back up? Thanks for the help! Mackeby -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html . |
| 934 | In Excel 2002 (installed as part of OXP Pro w/FP), on Windows 2000 SP2, we get this message when saving a document to the network for the second or later time (though sometimes it saves without the warning): The file <filename may have been changed by another user since you last saved it. In that case, what do you want to do? [Save a copy or overwrite changes.] Overwriting works fine, but I don't really want to roll out to a few thousand users with this error happening regularly. This happens on several different machines (every tester so far), whether installed manually from CD or via Group Policy from an admin installation point (with the latest patches, but also earlier before patching). Saving to a local drive has yet to cause the error, just saving to the network (Win2K SP2 servers in a domain). The latest patches for Excel didn't help. Suspicion has been pointed at our Clariion SAN which the servers use for their storage, but that's unclear and hard to test. Installed OXP on a WinXP test machine and was able to save repeatedly without the warning, so it seems to be a Win2K- specific issue. Neither Clariion tech support nor MSKB have offered up any pearls of wisdom. Any suggestions? |
| 1123 | If you have strictly positive numbers: [9999999.99]##\,##\,##\,##0.00;[99999.99]"##\,##\,##0.00;"##,##0.00 (This format separates groups for India/Thailand, format valid for positive numbers up to 99,99,99,999.99 or 999,999,999.99) in Excel XP see function BhatText as in Thai Bhat currency. This is the HELP as seen in Excel 2002 [I do not have 2002 on my computer] /assistance/offhelp/offxp/excel/xlmain10/html/Bahttext.htm HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Niek Otten" <nicolaus@xs4all.nl wrote in message news:eiW8i1DICHA.2060@tkmsftngp11... Enclose the commas in (double) quotes, like: _-$* ##","##","##","##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_- -- Regards, Niek Otten Microsoft MVP - Excel "CD" <soxplato@yahoo.com wrote in message news:118c001c2203b$e94ea580$9ee62ecf@tkmsftngxa05... Hi I created a custom format and positioned the commas to where I wanted them. But the comma positions keep getting reset to the thousand's place. This _-$* ##,##,##,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_- gets automatically changed to _-$* ###,###,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_- Any help would be appreciated. Thanks. |
| 1153 | I am having several problems in Excel 2002 under Win XP Pro which I never had in earlier versions of these programs. I will submit them one at a time here looking and hoping for help. The first: I have a file of autoshapes filled with text that I use either in macros or to cut and paste as "stick-ons" or "labels" which are placed on billing statements - usually over old text which does not need to be presently read. Worked fine for years with black text (or color) on white opaque background. Somewhere along the line these have all become transparent "labels" so that all underlying text, lines, etc. show "through", making the stuff an unreadable mess. I have looked at all properties menus I can find to set these as not transparent with various foregrounds/backgrounds and moving focus back, forward, etc. I have recreated them in new sheets, I have reset properties in book and book1.xlt and personal.xls and whatever I can think of - but I cannot any longer paste an autoshape in XL2002 that is not transparent. Text boxes work fine but I need to have variable shapes. Any ideas on either cause or solution. WHat's worse, I think, but am not sure, that when I first set the XP computer up and transferred these spreadsheets, they worked fine. |
| 1155 | 1. Double-click the AutoShape 2. On the Colors and Lines tab, set the Transparency slider to 0% wbbirner@rtconline.com wrote: I am having several problems in Excel 2002 under Win XP Pro which I never had in earlier versions of these programs. I will submit them one at a time here looking and hoping for help. The first: I have a file of autoshapes filled with text that I use either in macros or to cut and paste as "stick-ons" or "labels" which are placed on billing statements - usually over old text which does not need to be presently read. Worked fine for years with black text (or color) on white opaque background. Somewhere along the line these have all become transparent "labels" so that all underlying text, lines, etc. show "through", making the stuff an unreadable mess. I have looked at all properties menus I can find to set these as not transparent with various foregrounds/backgrounds and moving focus back, forward, etc. I have recreated them in new sheets, I have reset properties in book and book1.xlt and personal.xls and whatever I can think of - but I cannot any longer paste an autoshape in XL2002 that is not transparent. Text boxes work fine but I need to have variable shapes. Any ideas on either cause or solution. WHat's worse, I think, but am not sure, that when I first set the XP computer up and transferred these spreadsheets, they worked fine. -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 1159 | That was the first thing I checked. Already there. (I only look not too bright :-) ) On Sun, 30 Jun 2002 17:56:13 -0400, Debra Dalgleish <dsd@contextures.com wrote: 1. Double-click the AutoShape 2. On the Colors and Lines tab, set the Transparency slider to 0% wbbirner@rtconline.com wrote: I am having several problems in Excel 2002 under Win XP Pro which I never had in earlier versions of these programs. I will submit them one at a time here looking and hoping for help. The first: I have a file of autoshapes filled with text that I use either in macros or to cut and paste as "stick-ons" or "labels" which are placed on billing statements - usually over old text which does not need to be presently read. Worked fine for years with black text (or color) on white opaque background. Somewhere along the line these have all become transparent "labels" so that all underlying text, lines, etc. show "through", making the stuff an unreadable mess. I have looked at all properties menus I can find to set these as not transparent with various foregrounds/backgrounds and moving focus back, forward, etc. I have recreated them in new sheets, I have reset properties in book and book1.xlt and personal.xls and whatever I can think of - but I cannot any longer paste an autoshape in XL2002 that is not transparent. Text boxes work fine but I need to have variable shapes. Any ideas on either cause or solution. WHat's worse, I think, but am not sure, that when I first set the XP computer up and transferred these spreadsheets, they worked fine. -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 1166 | Since TextBoxes work properly, what happens if you paste a textbox, then choose DrawChange AutoShape, and select a different shape? rambeaux@rtconline.com wrote: That was the first thing I checked. Already there. (I only look not too bright :-) ) On Sun, 30 Jun 2002 17:56:13 -0400, Debra Dalgleish <dsd@contextures.com wrote: 1. Double-click the AutoShape 2. On the Colors and Lines tab, set the Transparency slider to 0% wbbirner@rtconline.com wrote: I am having several problems in Excel 2002 under Win XP Pro which I never had in earlier versions of these programs. I will submit them one at a time here looking and hoping for help. The first: I have a file of autoshapes filled with text that I use either in macros or to cut and paste as "stick-ons" or "labels" which are placed on billing statements - usually over old text which does not need to be presently read. Worked fine for years with black text (or color) on white opaque background. Somewhere along the line these have all become transparent "labels" so that all underlying text, lines, etc. show "through", making the stuff an unreadable mess. I have looked at all properties menus I can find to set these as not transparent with various foregrounds/backgrounds and moving focus back, forward, etc. I have recreated them in new sheets, I have reset properties in book and book1.xlt and personal.xls and whatever I can think of - but I cannot any longer paste an autoshape in XL2002 that is not transparent. Text boxes work fine but I need to have variable shapes. Any ideas on either cause or solution. WHat's worse, I think, but am not sure, that when I first set the XP computer up and transferred these spreadsheets, they worked fine. -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 1186 | Hi, Easy Peasy question. Using the Books "Excel 2002 Bible" and "Excel 2002 VBA" I wrote the following code. Worksheets(7).ActiveCell.Offset(0, 1).Copy Destination = Worksheets(2).ActiveCell.Offset(c, 0) Which when dedugged is ok but when runs states "Object doesn't support this property or method" C= "some vertical number" What would the correct syntax be to copy a value from one cell in a workbook sheet to another cell in a workbook sheet. William |
| 1188 | "William" <wapfu@xtra.co.nz wrote in message news:11d8001c220b3$49b8d540$36ef2ecf@tkmsftngxa12... | Hi, | Easy Peasy question. | Using the Books "Excel 2002 Bible" and "Excel 2002 VBA" | I wrote the following code. | Worksheets(7).ActiveCell.Offset(0, 1).Copy Destination = | Worksheets(2).ActiveCell.Offset(c, 0) | | Which when dedugged is ok but when runs states "Object | doesn't support this property or method" | C= "some vertical number" | | What would the correct syntax be to copy a value from one | cell in a workbook sheet to another cell in a workbook | sheet. | | William |
| 1190 | Hi William Try: Worksheets(7).Select ActiveCell.Copy Destination:= _ Worksheets(2).Range(ActiveCell.Address) You cannot specify ActiveCell after referencing a Worksheet. OR better yet, use the sheets CodeName (name not in brackets in the Project Explorer). So the code might look something like: Sheet7.Select ActiveCell.Copy Destination:= _ Sheet2.Range(ActiveCell.Address) The CodeName of a Sheet is not altered by changing its position or renaming it. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "William" <wapfu@xtra.co.nz wrote in message news:11d8001c220b3$49b8d540$36ef2ecf@tkmsftngxa12... | Hi, | Easy Peasy question. | Using the Books "Excel 2002 Bible" and "Excel 2002 VBA" | I wrote the following code. | Worksheets(7).ActiveCell.Offset(0, 1).Copy Destination = | Worksheets(2).ActiveCell.Offset(c, 0) | | Which when dedugged is ok but when runs states "Object | doesn't support this property or method" | C= "some vertical number" | | What would the correct syntax be to copy a value from one | cell in a workbook sheet to another cell in a workbook | sheet. | | William |
| 1192 | Hi We are receiving the following error message when certain users try to use excel 2002 "An error occurred initializing the VBA libraries (265)" All the computers are running Windows 2000 with Office XP professional connected to a Win2000 SBS. We first noticed the problem on 2 computers which were upgraded to Win2000 from Win98. On those computers the only user who doesn't get the message is the Administrator. The only other 2 computers experiencing the problem have always been Win2000. On those computers only one particular user get the problem on each machine. I have noticed that on the machines that have always been Win2000 each time a new user logs on office is installed however in the upgraded machines each user opens up office straight away without running through the initial setup. We recently upgraded our practice management software which may have caused the problem however the software was removed from 2 upgraded machines then the operating system was reinstalled. We have tried uninstalling office then reinstalling the operating system before reinstalling office. We also tried repairing the office installation Any assistance would be appreciated Thanks Ben |
| 1203 | Dave, Again I thankyou, and am indebted to your valued=20 assistance. Read about the active cell in "Excel 2002 Bible" and=20 thought if the match had been made then the refernce=20 would be stable for the want of a better word. That is,=20 both sheets would have a cell that the routine knew=20 about, and shifting the value would be clean, and then=20 the routine would step again to a new match. William -----Original Message----- Hi William I haven't read all through your code but a few things do=20 catch my eye, it appears you could replace a lot of your code with the=20 snippet below Select Case Sheet8.Cells(2, 3) ' Gets Case 1 To 3 C =3D Sheet8.Cells(2, 3) + 10 Case 4 To 12 C =3D Sheet8.Cells(2, 3) - 2 Case Else 'Whatver End Select Sheet8.Select ActiveCell.Offset(0, 1).Copy _ Destination:=3DSheet2.Range(ActiveCell.Offset(C,=20 0).Address) Not too sure why you are using the ActiveCell, but=20 consider setting a range variable at the start like below: Set rActCell =3D ActiveCell Then use the Object variable in place of ActiveCell.=20 Just be aware the ActiveCell Always refers to the active cell on the=20 Active sheet. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "William" <wapfu@xtra.co.nz wrote in message news:13f9801c220d3$bf0b1cc0$19ef2ecf@tkmsftngxa01... | Hi, | Dedugging a routine. Thanks to all that have got me=20 this | far. | The idea is to match two tables, One horizontal to one | vertical. When there is a match(there will be more than | one where nonidentical pairs match in both tables) the | value, one cell across, from the active cell in the | vertical table, Sheet8, is copied to a cell in the=20 table | (horizontal) sheet2 where it is offeset vertically from | the matching pair value in that table. The routine runs | to all pairs that can be matched are anf values have=20 been | copied across. I get "Method or data member not found=20 for | SelectActiveCell in the following. The full code=20 follows. | Thanking anyone that can give my brain help. | Regards William | | Sub test() | 'table in worksheet(7) is vertical | 'table in worksheet(2) is horizontal | | Dim rng1 As Range, rng2 As Range | Dim cell As Range | Dim res As Variant | Set rng1 =3D Sheet2.Range("D3:AD3") | Set rng2 =3D Sheet8.Range("A0:A16") | For Each cell In rng1 | res =3D "" | res =3D Application.Match(cell.Value, | rng2, 0) | If Not IsError(res) Then | ' the match, do something | Select Case Sheet8.Cells(2, 3) ' Gets | the month value to set the offset "c" | 've rti | cally from the active cell in | 'wo rks | heet(2). | Case Is =3D 1 | C =3D 11 | Case Is =3D 2 | C =3D 12 | Case Is =3D 3 | =CD{=9Dw=C0=1F=BC=03\v=DCqo=A5=BEq=CCC-=08 =EC?=04 = C =3D 13 | Case Is =3D 4 | C =3D 2 | Case Is =3D 5 | C =3D 3 | Case Is =3D 6 | C =3D 4 | Case Is =3D 7 | C =3D 5 | Case Is =3D 8 | C =3D 6 | Case Is =3D 9 | C =3D 7 | Case Is =3D 10 | C =3D 8 | Case Is =3D 11 | C =3D 9 | Case Is =3D 12 | C =3D 10 | End Select | Sheet8.SelectActiveCell.Offset(0, 1).Copy | Destination:=3DSheet2.Range(ActiveCell.Offset(C, 0)) | Rem MsgBox cell.Value & " equals " & rng2 | (res).Value | Exit Sub | Else | ' the don't match | End If | ' continue the search | Next | | | | | | | End Sub | . |
| 1205 | Hi William You cannot use Code like: Sheet.ActiveCell or Sheets(1).ActiveCell etc as ActiveCell is not a Data member of the Sheet Object. When you type the CodeName of a Sheet (which is good practice to use) and then type the Dot (.) you will see a list of all the Properties and Methods available. If you wish to copy from Sheet8 the same address as the ActiveCell address you can use: Sheet8.Range(rActCell.Address).Offset(0, 1).Copy Or if you are wanting the Active Cell on sheet8 you MUST activate the sheet first, then just use ActiveCell Sheet8.Select ActiveCell.Offset(0, 1).Copy You must remember that ActiveCell Always refers to the active cell on the Active sheet and nowhere else. Perhaps if you could explain what the Copy code is suppose to do....... -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "William" <wapfu@xtra.co.nz wrote in message news:13c8f01c220ea$a13ef8d0$b1e62ecf@tkmsftngxa04... | Hi, | Replaced the case select in its shortened form, | set the range as | set rActCell = Activecell | and | used the following | Sheet8.rActCell.Offset(0, 1).Copy | Destination:=Sheet2.Range(rActCell.Offset(c, 0).Address) | | Still returning Method or data not found. | | Read about the active cell in "Excel 2002 Bible" and | thought if the match had been made then the refernce | would be stable (for the want of a better word). That is, | both sheets would have a cell that the routine knew | about, and shifting the value would be no problem, and | then the routine would step again to a new matching pair. | Can't think of another way to make the unique cell from | the matching , the only one that can be copied, hence the | offeset and active cell course. | Could you Run the object variable by me please or am I | missing something very simple. | | William | |
| 1212 | Hi Ben, Try running Excel in Safe Mode and see if the error occurs. For this go to Start/Run and run the following command: Excel.exe /s Note that there is a space before the forward slash. If everything works fine in Safe Mode, then the problem could be due to an add-in Go to Tools/Add-ins and uncheck all the add-ins. Then start Excel without using the /s switch. If this solves the problem then enable the add-ins one-by-one, restarting Excel each time, to find the offending add-in. If the problem still exists then go to Tools/Options/General and make sure that the 'Alternate Startup file location' is blank. If this doesn't work, move all the files out of C:\...\Office\XLStart. This could also be caused by a bad xlb file. Search for files "*.xlb" and move them to another folder.. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Please post replies/further questions to the newsgroup so that all may benefit. Personal requests for assistance can not be acknowledged. "Ben Owen" <thebigo@nospam.iinet.net.au wrote in message news:3d1fdfdc$0$23244$5a62ac22@freenews.iinet.net.au... Hi We are receiving the following error message when certain users try to use excel 2002 "An error occurred initializing the VBA libraries (265)" All the computers are running Windows 2000 with Office XP professional connected to a Win2000 SBS. We first noticed the problem on 2 computers which were upgraded to Win2000 from Win98. On those computers the only user who doesn't get the message is the Administrator. The only other 2 computers experiencing the problem have always been Win2000. On those computers only one particular user get the problem on each machine. I have noticed that on the machines that have always been Win2000 each time a new user logs on office is installed however in the upgraded machines each user opens up office straight away without running through the initial setup. We recently upgraded our practice management software which may have caused the problem however the software was removed from 2 upgraded machines then the operating system was reinstalled. We have tried uninstalling office then reinstalling the operating system before reinstalling office. We also tried repairing the office installation Any assistance would be appreciated Thanks Ben |
| 1240 | I have a spreadsheet that was created in Excel 2000 which displays an error condition, but only when opened in Excel 2002. Some cells containing numbers are displayed with a small green triangle in the upper left corner of the cell. When you place your mouse pointer in this cell an error box appears to the left of the cell which contains an exclamation point and a drop down menu. The drop down menu tells you that you have a number in the cell which has been stored as text, and asks whether you want to correct this "error" by converting it to a number. Once you do this the green triangle is removed, and you are presumably okay. I opened a new spreadsheet in 2002 and pre-formatted a cell to text before entering a number. The green triangle appeared, and reformatting the cell to general or number did not make it go away. You have to fix the "error" with the special drop down box to the left of the cell. However, if you format a cell as text after a number has been entered into it using general or number format this error does not occur. I also encountered this problem when trying to import this spreadsheet into Access 2000. These cells cause an import error to occur - error 3349 numeric overflow. Once the "error" cells are fixed this import error disappears. Is anyone aware of a general fix for this problem by way of a service pack for Excel 2002? Bill |
| 1247 | Hi Bill ToolsOptionsError Checking. You can record a macro toggling the options to get the code. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "Bill Murphy" <wmurphy@NO*SPAM!houston.rr.com wrote in message news:377U8.25029$p85.681329@twister.austin.rr.com... | I have a spreadsheet that was created in Excel 2000 which displays an error | condition, but only when opened in Excel 2002. Some cells containing | numbers are displayed with a small green triangle in the upper left corner | of the cell. When you place your mouse pointer in this cell an error box | appears to the left of the cell which contains an exclamation point and a | drop down menu. The drop down menu tells you that you have a number in the | cell which has been stored as text, and asks whether you want to correct | this "error" by converting it to a number. Once you do this the green | triangle is removed, and you are presumably okay. | | I opened a new spreadsheet in 2002 and pre-formatted a cell to text before | entering a number. The green triangle appeared, and reformatting the cell | to general or number did not make it go away. You have to fix the "error" | with the special drop down box to the left of the cell. However, if you | format a cell as text after a number has been entered into it using general | or number format this error does not occur. | | I also encountered this problem when trying to import this spreadsheet into | Access 2000. These cells cause an import error to occur - error 3349 | numeric overflow. Once the "error" cells are fixed this import error | disappears. | | Is anyone aware of a general fix for this problem by way of a service pack | for Excel 2002? | | Bill | | |
| 1254 | Dave, Thanks for this tip. I turned off this error check and it immediately resolved my problem, including the problem when importing to Access. Bill "" <DavidH@OzGrid.com wrote in message news:6o7U8.18$tm.19011@vicpull1.telstra.net... Hi Bill ToolsOptionsError Checking. You can record a macro toggling the options to get the code. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "Bill Murphy" <wmurphy@NO*SPAM!houston.rr.com wrote in message news:377U8.25029$p85.681329@twister.austin.rr.com... | I have a spreadsheet that was created in Excel 2000 which displays an error | condition, but only when opened in Excel 2002. Some cells containing | numbers are displayed with a small green triangle in the upper left corner | of the cell. When you place your mouse pointer in this cell an error box | appears to the left of the cell which contains an exclamation point and a | drop down menu. The drop down menu tells you that you have a number in the | cell which has been stored as text, and asks whether you want to correct | this "error" by converting it to a number. Once you do this the green | triangle is removed, and you are presumably okay. | | I opened a new spreadsheet in 2002 and pre-formatted a cell to text before | entering a number. The green triangle appeared, and reformatting the cell | to general or number did not make it go away. You have to fix the "error" | with the special drop down box to the left of the cell. However, if you | format a cell as text after a number has been entered into it using general | or number format this error does not occur. | | I also encountered this problem when trying to import this spreadsheet into | Access 2000. These cells cause an import error to occur - error 3349 | numeric overflow. Once the "error" cells are fixed this import error | disappears. | | Is anyone aware of a general fix for this problem by way of a service pack | for Excel 2002? | | Bill | | |
| 1309 | Hi all, I have Microsoft Excel 2002 and I want to save my Excel files in a format that can be opened on Microsoft Works 2001. What format should I use? Can someone help? |
| 1312 | Hi Dave, The following may help, Instead of ; Range("A3").Select With Selection.QueryTable .Connection = "TEXT;C:\stuff.txt" TRY With ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\stuff.txt", _ Destination:=Range("a3")) Therefore, the whole code would look like this Sub importstuff() ' Application.DisplayAlerts = False Sheets("Import").Select With ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\stuff.txt", _ Destination:=Range("a3")) .TextFilePlatform = xlWindows .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = True .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, _ 1, 1, 1, 1, 1, 1, 1, 1, 1, _ 1, 1, 1, 1, 1, 1) .Refresh BackgroundQuery:=False End With End Sub When I tried the above code, I wasn't prompted (Excel 2002). Regards, Andrew "Dave B" <david.bracknell@avmltd.com wrote in message news:#xndDrTICHA.2612@tkmsftngp08... Below is my vb macro which works up to the point of the "Import Text File" message box. There it waits for the user to select "Import." How do I get it to automatically select "Import" to fully automate the data import? Thanx for any help!! ------------------------------ Sub importstuff() ' Application.DisplayAlerts = False ' Sheets("Import").Select Range("A3").Select With Selection.QueryTable .Connection = "TEXT;C:\stuff.txt" .TextFilePlatform = xlWindows .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = True .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, _ 1, 1, 1, 1, 1, 1) .Refresh BackgroundQuery:=False End With End Sub |
| 1334 | "Edward Thornton" <edward.thornton@btinternet.com wrote in message news:<afqe1u$9n6$1@helle.btinternet.com... Can anyone please advise on how to open spreadsheets created with MS Works Version 4 for Windows 95 using Excel 2002? I can use Works to save spreadsheets in Excel format and then open them in Excel 2002 but I'd prefer to copy them across to a new PC as *.wks files and open them in Excel 2002 as required. Thanks, Ed RL-Software's Works spreadsheet to Excel Converter does this perfectly with almost all formulae and formatting of the cells maintained. You can find a free evaluation copy of this Excel Add-Inn at www.rl-software.com HTH Rob |
| 1335 | "Edward Thornton" <edward.thornton@btinternet.com wrote in message news:<afqe1u$9n6$1@helle.btinternet.com... Can anyone please advise on how to open spreadsheets created with MS Works Version 4 for Windows 95 using Excel 2002? I can use Works to save spreadsheets in Excel format and then open them in Excel 2002 but I'd prefer to copy them across to a new PC as *.wks files and open them in Excel 2002 as required. Thanks, Ed RL-Software's Works spreadsheet to Excel Converter does this perfectly with almost all formulae and formatting of the cells maintained. You can find a free evaluation copy of this Excel Add-Inn at www.rl-software.com HTH Rob |
| 1336 | I have Excel 2002 on Windows XP and I don't have that kind of problem. You might want to clean out your \Temp folder. Sometimes it being too full can have bad effects on Excel. Paul "naven" <naven@california.net wrote in message news:u8$3n#fICHA.2604@tkmsftngp11... I do not know if this is an issue with Excel or with Windows XP. Certain functions in Excel are incredibly slow. Print Preview of a 20K spreadsheet can take up to two minutes. After making a small settings change, the program hangs. Sometimes a small format change, like font color of one word, can take a full minute. If I click anywhere on the spreadsheet before it finishes I get "not responding" message. (P4, 1.7G, 512M ram, Office 2002) Compared to this, my P3, 300M, 128 ram machine running Office 97, was like greased lightning! Any help is appreciated. |
| 1337 | I have Excel 2002 on Windows XP and I don't have that kind of problem. You might want to clean out your \Temp folder. Sometimes it being too full can have bad effects on Excel. Paul "naven" <naven@california.net wrote in message news:u8$3n#fICHA.2604@tkmsftngp11... I do not know if this is an issue with Excel or with Windows XP. Certain functions in Excel are incredibly slow. Print Preview of a 20K spreadsheet can take up to two minutes. After making a small settings change, the program hangs. Sometimes a small format change, like font color of one word, can take a full minute. If I click anywhere on the spreadsheet before it finishes I get "not responding" message. (P4, 1.7G, 512M ram, Office 2002) Compared to this, my P3, 300M, 128 ram machine running Office 97, was like greased lightning! Any help is appreciated. |
| 1340 | Thanks Paul, i am trying that as we speak, if only to eliminate it as the cause. This is a brand new computer, and these are the very first spreadsheets edited on it. As i expected, clearing the Temp folder did not help. The spreadsheets were originally composed using Excel 97. I wonder, can that be the cause? Thanks for your suggestion. Let me know if you have any others ..n "Paul Watson" <pwwatsoniii@msn.com wrote in message news:uSAWFHmICHA.2032@tkmsftngp08... I have Excel 2002 on Windows XP and I don't have that kind of problem. You might want to clean out your \Temp folder. Sometimes it being too full can have bad effects on Excel. Paul "naven" <naven@california.net wrote in message news:u8$3n#fICHA.2604@tkmsftngp11... I do not know if this is an issue with Excel or with Windows XP. Certain functions in Excel are incredibly slow. Print Preview of a 20K spreadsheet can take up to two minutes. After making a small settings change, the program hangs. Sometimes a small format change, like font color of one word, can take a full minute. If I click anywhere on the spreadsheet before it finishes I get "not responding" message. (P4, 1.7G, 512M ram, Office 2002) Compared to this, my P3, 300M, 128 ram machine running Office 97, was like greased lightning! Any help is appreciated. |
| 1387 | Hi Phil, Excel 2002 has the same "limitation" as 97 and 2000 when it comes to number of rows.. Regards, Peo Sjoblom "Phil" <pspearman@rm.com wrote in message news:14d8901c222a0$5a5002e0$9be62ecf@tkmsftngxa03... Hi, Ive heard a rumour that 'a new version of Excel' gets around the 65 536 row limitation of previous versions. Ive had a quick look at new features in Excel2002 but cant find anything relating to this. We're currently using Excel2000. Can anyone confirm or deny this rumour? Thanks in advance for any news Phil |
| 1421 | Hi Bosley, Only by restarting the printing to print another page changing the options in between. Look for some Myrna Larson links in my pathname.htm if really interested. You will find other links somewhat more suited in the archives, but this will certainly give you an idea of what is involved. You would have to force page breaks if size of pages would change when you change your options. If you just want the first page to be different you can use the first rows of the spreadsheet for the the header on first page then perhaps rows 48:49 are to be repeated for rest of pages. page setup, rows to repeat at top $48:$49 select row 48, insert page Not sure of full extent of Excel 2002 improvements for headers and footers, but think you will only see improvements in printing graphics in actual headers and footers and obtaining the full pathname without using a macro. /assistance/offhelp/offxp/excel/xlmain10/html/InsertAGraphicInAHeaderOrFooter.htm /assistance/offhelp/offxp/excel/xlmain10/html/InsertAFilenameInAHeaderOrFooter.htm HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Bosley" <presstools@clara.net wrote in message news:1025695903.5242.0@iapetus.uk.clara.net... Is it possible on a single worksheet with several pages to select the header/footer to only appear on selected pages. Regards, Bosley. |
| 1422 | Using the File/Save as Web Page.../Publish command in Excel 2002 SP-1 on a cell range, everything works as advertised except that the heavy outline border that I created around the range does not appear in the published web page, only a thin line, although it is certainly present in the worksheet. The interior grid lines in the worksheet do transfer to the published web page. I tried creating an outer heavy border around adjacent surrounding cells, thinking that the now interior heavy border was just getting clipped, but that was not the case. The line thickness just gets lost and I just end up with a thin double line frame. Do I need to set some obscure flag somewhere to get the border formatting to completely carry through to the published data? I didn't see anything at Tools/Options/Web Options... that appeared to apply. Or is this a "feature"? John D. Peterson jdpeterson@glpwgroup.com |
| 1440 | At times, I'll open Excel 2002 and the entire spreadsheet area (i.e., everything below the menu bar, tool bar, cell bar, and status bar--yes, the one on the bottom) will be blank; no cells or cell data appear; the images from the underlying window(s) are all that appear. The entire Excel window frame is visible. Minimizing/restoring Excel or the spreadsheet document itself doesn't help; neither does closing and re-opening the spreadsheet; neither does opening another spreadsheet. Re-starting Excel doesn't take care of the problem, either. I've seen this on at least two different computers; so it seems unlikely to be a video driver problem. Any idea what's causing this...and how to fix it? |
| 1450 | If you go to window is there an ungreyed out entry for unhide window? "Garth" <me@garth.com wrote in message news:OEKIuUsICHA.2228@tkmsftngp08... : At times, I'll open Excel 2002 and the entire spreadsheet area (i.e., : everything below the menu bar, tool bar, cell bar, and status bar--yes, the : one on the bottom) will be blank; no cells or cell data appear; the images : from the underlying window(s) are all that appear. The entire Excel window : frame is visible. Minimizing/restoring Excel or the spreadsheet document : itself doesn't help; neither does closing and re-opening the spreadsheet; : neither does opening another spreadsheet. Re-starting Excel doesn't take : care of the problem, either. : : I've seen this on at least two different computers; so it seems unlikely to : be a video driver problem. Any idea what's causing this...and how to fix it? : : |