| Article | Body |
| 285 | I posted this on the "setup" board, but then found this board - question is probably better suited for here. I have a relatively new computer which came with Works. My old computer came with Excel 97. I'm trying to open an Excel 97 file someone sent me, but cannot open it with Works. Then I tried installing the Excel 97 onto my new computer (I still have all the CDs that came with the old one). It asks for an authenticity code and I no longer have ANY of that stuff? What can I do? Thanks for any help, Martha |
| 289 | Martha, sounds like the old Excel97 stuff is upgrade software, not the full installation. You need a full installation software package. There are ways around your problem but it is considered pirating software. Sorry cannot help you except suggest you purchase full program. Gilles "Craig Charles M.D." <craigmartha@mindspring.com wrote in message news:aeqj3h$vii$1@slb2.atl.mindspring.net... I posted this on the "setup" board, but then found this board - question is probably better suited for here. I have a relatively new computer which came with Works. My old computer came with Excel 97. I'm trying to open an Excel 97 file someone sent me, but cannot open it with Works. Then I tried installing the Excel 97 onto my new computer (I still have all the CDs that came with the old one). It asks for an authenticity code and I no longer have ANY of that stuff? What can I do? Thanks for any help, Martha |
| 290 | Usually the code is on the back of the CD case. Do you have a code there? (orange sticker?) "Craig Charles M.D." <craigmartha@mindspring.com wrote in message news:aeqj3h$vii$1@slb2.atl.mindspring.net... I posted this on the "setup" board, but then found this board - question is probably better suited for here. I have a relatively new computer which came with Works. My old computer came with Excel 97. I'm trying to open an Excel 97 file someone sent me, but cannot open it with Works. Then I tried installing the Excel 97 onto my new computer (I still have all the CDs that came with the old one). It asks for an authenticity code and I no longer have ANY of that stuff? What can I do? Thanks for any help, Martha |
| 309 | Nope - my husband put all the CDs in a big CD holder a long time ago for simplicity's sake. Oh well....guess that file wasn't that important anyway. Thanks for the tip, though. Martha "Tom Ogilvy" <twogilvy@msn.com wrote in message news:ecbi2P8FCHA.2424@tkmsftngp10... Usually the code is on the back of the CD case. Do you have a code there? (orange sticker?) Regards, Tom Ogilvy "Craig Charles M.D." <craigmartha@mindspring.com wrote in message news:aeqj3h$vii$1@slb2.atl.mindspring.net... I posted this on the "setup" board, but then found this board - question is probably better suited for here. I have a relatively new computer which came with Works. My old computer came with Excel 97. I'm trying to open an Excel 97 file someone sent me, but cannot open it with Works. Then I tried installing the Excel 97 onto my new computer (I still have all the CDs that came with the old one). It asks for an authenticity code and I no longer have ANY of that stuff? What can I do? Thanks for any help, Martha |
| 345 | Is it possible, in Excel 97 to prevent a user from entering data in a cell until data has been completly entered in another cell. For example, I want to lock cell G44 until data in F24 has been entered, and then unlock G44. This needs to be done without user intervention. Thanks for any suggestions |
| 353 | Hi, how many rows does Excel 97 have. I thought read some where that it was just over the 16000 mark. Thanks Murray |
| 357 | Hi Murray 65,536 per worksheet -- Regards William willwest22@yahoo.com "Murray" <Murray.hall@markelintl.com.au wrote in message news:1091d01c217ed$57362750$39ef2ecf@TKMSFTNGXA08... | Hi, how many rows does Excel 97 have. I thought read some | where that it was just over the 16000 mark. | Thanks Murray |
| 383 | You could just leave the formats alone and sum, but you may find that your sum's give you a somewhat bizarre result: A1: 04:08:53 (4 days, 8 hours, 53 minutes) A2: 03:16:07 (3 days, 16 hours, 7 minutes) A3: =A1 + A2 === 07:25:00 (7 days, 25 hours) If you want to convert the numbers to regular XL Date/Time format (days as integers and times as fractional days, here's one way: Since XL will interpret 4:8:53 as 4 hours, 8 minutes, 53 seconds, you need to do a bit of manipulation: A1: 04:08:53 B1: =A1*60 - 1.5*INT(A1*24) === 4.370138889 A2: 03:16:07 B2: =A2*60 - 1.5*INT(A2*24) === 3.671527778 B3: =SUM(B1:B2) === 8.041666667 or 8 days 1 hour. In article <10aac01c218a2$776c9ad0$9be62ecf@tkmsftngxa03, M. E. <mcook@magellanhealth.com wrote: I am trying to be able to SUM and AVERAGE time for a month. The time the employee is available may be so many DAYS (24hours = 1 day) so many HOURS (60 minutes in an hour) and so many MINUTES. SO lets say someone worked 4 Days 8 Hours and 53 Minutes In the cell we would format this for TIME and enter it as 4:8:53 I can't think of a way to write the formula that allows us to truncate this number at the colons and multiply and or divide by the appropriate factor (24 for the first colon and 60 for the second colon.) Microsoft Excel 97 SR-2 ANY HELP? Thanks! |
| 405 | Thanks to all for the suggestions. We wound up doing an macro. "Lloyd H. London" wrote: Is it possible, in Excel 97 to prevent a user from entering data in a cell until data has been completly entered in another cell. For example, I want to lock cell G44 until data in F24 has been entered, and then unlock G44. This needs to be done without user intervention. Thanks for any suggestions |
| 431 | Jenny, Not sure about your second question, but in regard to the first question, look in Help under Specifications for questions like this. For Excel 97 and 2000 you should find a 32,000 character limit for each cell: Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. HTH, Brian Jenny wrote: Are there any restrictions on the amount of data you can put into one cell in a worksheet? If so are there any ways to increase the amount of data you can insert? Tried all the usual ways but no luck! Also when converting a word table to a spreadsheet is there a global way to stop excel converting certain figures into dates or will we have to amend every affected cell? Grateful for any enlightenment! Jenny |
| 443 | I have posted a question relating this query titled "Printing date in Excel 97" (was on pg15 on 21/06). I was given a visual basic solution but I was wondering if it could be done using formulas. The VB way has been temperamental and does not work now. I want to be able to print an non-updateable date into a cell when data is enterred into another cell. E.g. data is entered into A3, then a date automatically appears in J3. I want to be able to do this are multiple rows. Can anyone help. Thanks in advance. |
| 489 | I am trying to troubleshoot a problem where the format cells dialog box will not appear when trying to format a cell with data in it or if the cell has had previous formatting applied to it. The dialog box appears normally when trying to format an empty cell or if the range selected included an empty cell. I've tried pasting the data into a clean workbook with no luck. Has anyone ever seen this behavior before? I am using Excel 97. Thanks in advance! Chris Lunde |
| 497 | Let me rephrase the first sentence: --Excel can only *open* Works spreadsheets that are saved as Works 2.0 files. (My thanks to the quality control team.) Debra Dalgleish wrote: Excel can only only Works spreadsheets that are saved as Works 2.0 files. Many computers come with a copy of MS Works. Maybe you can find someone who can open your file in Works, and save it as version 2.0. Then you'll be able to open it in Excel. Copy the file onto your hard drive -- don't work from the floppy disk, because it's very easy to damage the file that way. Connie wrote: I have an old but extensive Address Book made with a MicroSoft Works program that came with my computer. It is now only available on a floppy disk. I have tried to convert this floppy spread sheet file, to what appears to be the same spread sheet in Excel 97 (Book 1, Sheet 1) I've used MicroSoft Query with all the ODBC drivers installed but it will not recognize the .WKS OR .TXT format in which I have it. This is probably simple but so am I; I'm stumped! Please save me from a long input session with an old hard copy. |
| 507 | I think you can use the acronym: QCT Debra Dalgleish wrote: Let me rephrase the first sentence: --Excel can only *open* Works spreadsheets that are saved as Works 2.0 files. (My thanks to the quality control team.) Debra Dalgleish wrote: Excel can only only Works spreadsheets that are saved as Works 2.0 files. Many computers come with a copy of MS Works. Maybe you can find someone who can open your file in Works, and save it as version 2.0. Then you'll be able to open it in Excel. Copy the file onto your hard drive -- don't work from the floppy disk, because it's very easy to damage the file that way. Connie wrote: I have an old but extensive Address Book made with a MicroSoft Works program that came with my computer. It is now only available on a floppy disk. I have tried to convert this floppy spread sheet file, to what appears to be the same spread sheet in Excel 97 (Book 1, Sheet 1) I've used MicroSoft Query with all the ODBC drivers installed but it will not recognize the .WKS OR .TXT format in which I have it. This is probably simple but so am I; I'm stumped! Please save me from a long input session with an old hard copy. -- Dave Peterson ec35720@msn.com |
| 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 |
| 593 | Are the Excel 97 Help files available on the Microsoft site? I can find the 2000 Help text, but in spite of a lot of searching, I can't find the Excel 97 help. I particularly need the VBA help information. If they're available, I'd be grateful for a URL. Thanks. Anne |
| 594 | You must install the help files Anne. If you install Office custom the vba helpwill not be installed I believe.?? So run your setup again and install it Regards Ron "Anne Lambert" <AnneTLambert@hotmail.com schreef in bericht news:uvAYyupGCHA.1772@tkmsftngp09... Are the Excel 97 Help files available on the Microsoft site? I can find the 2000 Help text, but in spite of a lot of searching, I can't find the Excel 97 help. I particularly need the VBA help information. If they're available, I'd be grateful for a URL. Thanks. Anne |
| 596 | Thanks for this. But I don't want to *use* XL 97: I just want to read the help files. I use XL 2002, and I can't remember all that's changed over the years. Anne "Ron de Bruin" <rondebruin@kabelfoon.nl wrote in message news:O07bGzpGCHA.2992@tkmsftngp13... You must install the help files Anne. If you install Office custom the vba helpwill not be installed I believe.?? So run your setup again and install it Regards Ron "Anne Lambert" <AnneTLambert@hotmail.com schreef in bericht news:uvAYyupGCHA.1772@tkmsftngp09... Are the Excel 97 Help files available on the Microsoft site? I can find the 2000 Help text, but in spite of a lot of searching, I can't find the Excel 97 help. I particularly need the VBA help information. If they're available, I'd be grateful for a URL. Thanks. Anne |
| 598 | Hi Anne Type: What's new in Microsoft Excel? into the help -- "Anne Lambert" <AnneTLambert@hotmail.com wrote in message news:ODTBn7pGCHA.2448@tkmsftngp10... | Thanks for this. But I don't want to *use* XL 97: I just want to read the help files. I use XL 2002, and I can't remember all that's | changed over the years. | | Anne | | | "Ron de Bruin" <rondebruin@kabelfoon.nl wrote in message news:O07bGzpGCHA.2992@tkmsftngp13... | You must install the help files Anne. | If you install Office custom the vba helpwill not be installed I believe.?? | | So run your setup again and install it | | Regards Ron | | "Anne Lambert" <AnneTLambert@hotmail.com schreef in bericht | news:uvAYyupGCHA.1772@tkmsftngp09... | Are the Excel 97 Help files available on the Microsoft site? I can find | the 2000 Help text, but in spite of a lot of searching, I | can't find the Excel 97 help. I particularly need the VBA help | information. | | If they're available, I'd be grateful for a URL. | | Thanks. | | Anne | | | | | | | | |
| 600 | Hi Dave Thanks for this. But this won't distinguish (as one example of several) the changes that have been made to parameters to the Worksheet.Protect command since 97. I can access the details from the Excel 2000 help files on the MS site. I'm trying to find out if the text of the XL 97 help files is also available somewhere. Anne "" <DavidH@OzGrid.com wrote in message news:pEhR8.18$kP5.5272@vicpull1.telstra.net... Hi Anne Type: What's new in Microsoft Excel? into the help -- FREE EXCEL NEWSLETTER /News/2home.htm Get the OzGrid Add-in /Services/AddinExamples.htm If it's Excel, then it's us! "Anne Lambert" <AnneTLambert@hotmail.com wrote in message news:ODTBn7pGCHA.2448@tkmsftngp10... | Thanks for this. But I don't want to *use* XL 97: I just want to read the help files. I use XL 2002, and I can't remember all that's | changed over the years. | | Anne | | | "Ron de Bruin" <rondebruin@kabelfoon.nl wrote in message news:O07bGzpGCHA.2992@tkmsftngp13... | You must install the help files Anne. | If you install Office custom the vba helpwill not be installed I believe.?? | | So run your setup again and install it | | Regards Ron | | "Anne Lambert" <AnneTLambert@hotmail.com schreef in bericht | news:uvAYyupGCHA.1772@tkmsftngp09... | Are the Excel 97 Help files available on the Microsoft site? I can find | the 2000 Help text, but in spite of a lot of searching, I | can't find the Excel 97 help. I particularly need the VBA help | information. | | If they're available, I'd be grateful for a URL. | | Thanks. | | Anne | | | | | | | | |
| 604 | AFAIK, the Excel 97 Help files aren't online, but the VBA Programmer's Guide may help: /library/default.asp?url=/library/en-us/office97/html/web/fulltoc.asp Anne Lambert wrote: Hi Dave Thanks for this. But this won't distinguish (as one example of several) the changes that have been made to parameters to the Worksheet.Protect command since 97. I can access the details from the Excel 2000 help files on the MS site. I'm trying to find out if the text of the XL 97 help files is also available somewhere. Anne "" <DavidH@OzGrid.com wrote in message news:pEhR8.18$kP5.5272@vicpull1.telstra.net... Hi Anne Type: What's new in Microsoft Excel? into the help -- "Anne Lambert" <AnneTLambert@hotmail.com wrote in message news:ODTBn7pGCHA.2448@tkmsftngp10... | Thanks for this. But I don't want to *use* XL 97: I just want to read the help files. I use XL 2002, and I can't remember all that's | changed over the years. | | Anne | | | "Ron de Bruin" <rondebruin@kabelfoon.nl wrote in message news:O07bGzpGCHA.2992@tkmsftngp13... | You must install the help files Anne. | If you install Office custom the vba helpwill not be installed I believe.?? | | So run your setup again and install it | | Regards Ron | | "Anne Lambert" <AnneTLambert@hotmail.com schreef in bericht | news:uvAYyupGCHA.1772@tkmsftngp09... | Are the Excel 97 Help files available on the Microsoft site? I can find | the 2000 Help text, but in spite of a lot of searching, I | can't find the Excel 97 help. I particularly need the VBA help | information. | | If they're available, I'd be grateful for a URL. | | Thanks. | | Anne | | | | | | | | -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 605 | Hi Debra Yes, indeed. Thanks for this. Anne "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D15B24B.2040004@contextures.com... AFAIK, the Excel 97 Help files aren't online, but the VBA Programmer's Guide may help: /library/default.asp?url=/library/en-us/office97/html/web/fulltoc.asp Anne Lambert wrote: Hi Dave Thanks for this. But this won't distinguish (as one example of several) the changes that have been made to parameters to the Worksheet.Protect command since 97. I can access the details from the Excel 2000 help files on the MS site. I'm trying to find out if the text of the XL 97 help files is also available somewhere. Anne "" <DavidH@OzGrid.com wrote in message news:pEhR8.18$kP5.5272@vicpull1.telstra.net... Hi Anne Type: What's new in Microsoft Excel? into the help -- FREE EXCEL NEWSLETTER /News/2home.htm Get the OzGrid Add-in /Services/AddinExamples.htm If it's Excel, then it's us! "Anne Lambert" <AnneTLambert@hotmail.com wrote in message news:ODTBn7pGCHA.2448@tkmsftngp10... | Thanks for this. But I don't want to *use* XL 97: I just want to read the help files. I use XL 2002, and I can't remember all that's | changed over the years. | | Anne | | | "Ron de Bruin" <rondebruin@kabelfoon.nl wrote in message news:O07bGzpGCHA.2992@tkmsftngp13... | You must install the help files Anne. | If you install Office custom the vba helpwill not be installed I believe.?? | | So run your setup again and install it | | Regards Ron | | "Anne Lambert" <AnneTLambert@hotmail.com schreef in bericht | news:uvAYyupGCHA.1772@tkmsftngp09... | Are the Excel 97 Help files available on the Microsoft site? I can find | the 2000 Help text, but in spite of a lot of searching, I | can't find the Excel 97 help. I particularly need the VBA help | information. | | If they're available, I'd be grateful for a URL. | | Thanks. | | Anne | | | | | | | | -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 668 | Excel 97 SR1. I have a column of data created by formula. When the data cannot be calculated the cell contains "". How can I prevent the empty cells from plotting as zeros on a scatter plot. |
| 669 | I have a spreadsheet with several combo boxes. I often get the message "Not Enough System Resources to Display Completely" when I click on one of the combo boxes to select an item from the drop-down list. I have tried it on my machine at work (256 MB RAM, Windows NT, running Excel 97) and my laptop (128 MB RAM, Windows XP Professional, running Excel XP), and I get the same error on both machines. I am struggling to find a solution, wondering if this has happened to anyone else and if there is a solution. Any help is very much appreciated. Thanks, Dan Winterton |
| 670 | Change your formula to return an #N/A error instead of an empty string. For example, =IF(A1<=0,NA(),A1-B1) Stan Hilliard wrote: Excel 97 SR1. I have a column of data created by formula. When the data cannot be calculated the cell contains "". How can I prevent the empty cells from plotting as zeros on a scatter plot. -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 673 | On Mon, 24 Jun 2002 21:41:33 -0400, Debra Dalgleish <dsd@contextures.com wrote: Change your formula to return an #N/A error instead of an empty string. For example, =IF(A1<=0,NA(),A1-B1) Stan Hilliard wrote: Excel 97 SR1. I have a column of data created by formula. When the data cannot be calculated the cell contains "". How can I prevent the empty cells from plotting as zeros on a scatter plot. Thanks, that worked for the chart. Is there a way that I can prevent the #NA from showing in the cells? (Only for cosmetic purposes.) |
| 674 | You can use conditional formatting. For example, if this formula is in cells C1:C10, 1. Select the cells to be formatted 2. Choose FormatConditional Formatting 3. From the dropdown, choose Formula Is 4. In the Formula box, type a formula that refers to the first cell in the selection, e.g.: =ISERROR(C1) 5. Click the Format button. 6. On the Font tab, select White as the font colour (or any colour that matches the cell background) 7. Click OK, click OK Stan Hilliard wrote: On Mon, 24 Jun 2002 21:41:33 -0400, Debra Dalgleish <dsd@contextures.com wrote: Change your formula to return an #N/A error instead of an empty string. For example, =IF(A1<=0,NA(),A1-B1) Stan Hilliard wrote: Excel 97 SR1. I have a column of data created by formula. When the data cannot be calculated the cell contains "". How can I prevent the empty cells from plotting as zeros on a scatter plot. Thanks, that worked for the chart. Is there a way that I can prevent the #NA from showing in the cells? (Only for cosmetic purposes.) -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 677 | On Mon, 24 Jun 2002 20:40:43 -0500, Stan Hilliard <usenetreplyMS@samplingplansNOTSPAM.com wrote: Excel 97 SR1. I have a column of data created by formula. When the data cannot be calculated the cell contains "". How can I prevent the empty cells from plotting as zeros on a scatter plot. While I was working with the program, it started giving the error "EXCEL caused an invalid page fault in module MSO97.DLL at 0167:30705766." This happens whenever I right click on an axis or area and try to format. Can this be fixed? |
| 679 | Dear MS Support Team, I am having problem with one of the excel s/sheet I used until Friday = evening. I am using MS-Excel 97 SR-1 and this s/sheet worked perfectly = until Friday evening. It is a very simple data-only s/sheet..no macros/ = scripts/ program at all. I saved this successfully on my 'C' drive on = Friday night and tried to open it this morning but got a message box = (attached in the file) with the following error - "Error Message : = Address: excel.exe - Application Error" It doesn't even allow me to open the s/sheet. I have checked this file = for virus and there are none. Would appreciate if you can help me in this matter as I spent = considerable amount of time preparing this s/sheet. Regards, Ash |
| 684 | Hi Dawn: I don't believe that this is possible, at least through Excel 97. -- Regards, Vasant. **No direct emails please--keep discussion in newsgroup.** "Dawn" <dsirras@attbi.com wrote in message news:11ca201c21bf0$f914dbf0$b1e62ecf@tkmsftngxa04... Does anyone know if it is possible to allow sheets to be re-ordered in a protected workbook but NOT added, deleted or renamed? |
| 685 | This is primarily peer to peer support. If you want to talk to microsoft, try using and see what your options are. You probably have a corrupt file problem. You probably need to go to your back up copy. If you have macros in the sheet, try holding down the shift key while you open the file Ashu <ashuintokyo@hotmail.com wrote in message news:1225001c21bef$d031bf10$39ef2ecf@TKMSFTNGXA08... Dear MS Support Team, I am having problem with one of the excel s/sheet I used until Friday evening. I am using MS-Excel 97 SR-1 and this s/sheet worked perfectly until Friday evening. It is a very simple data-only s/sheet..no macros/ scripts/ program at all. I saved this successfully on my 'C' drive on Friday night and tried to open it this morning but got a message box (attached in the file) with the following error - "Error Message : Address: excel.exe - Application Error" It doesn't even allow me to open the s/sheet. I have checked this file for virus and there are none. Would appreciate if you can help me in this matter as I spent considerable amount of time preparing this s/sheet. Regards, Ash |
| 686 | Make sure the zoom is set to 100% Not being at 100% is a common cause of memory problems, but not an exclusive cause. Dan <daniel_winterton@hk.ml.com wrote in message news:101b801c21be8$348047a0$36ef2ecf@tkmsftngxa12... I have a spreadsheet with several combo boxes. I often get the message "Not Enough System Resources to Display Completely" when I click on one of the combo boxes to select an item from the drop-down list. I have tried it on my machine at work (256 MB RAM, Windows NT, running Excel 97) and my laptop (128 MB RAM, Windows XP Professional, running Excel XP), and I get the same error on both machines. I am struggling to find a solution, wondering if this has happened to anyone else and if there is a solution. Any help is very much appreciated. Thanks, Dan Winterton |
| 698 | Hi, Some things to do: Options to try and open a corrupt file - Set calculation to manual - open the file, but disable macros (assuming you've set macro security to medium: Tools, Macro, security) - As soon as you've clicked the disable macros button, press control-pageup or control-pagedown, thus changing sheets. If that does not work, try creating a link to the file: ='c:\my documents\[MyFileName.xls]Sheet1'!A1 and copy right and down. This at least gets you the worksheets values. Sometimes the Excel viewer (or Word) enables you to open the file and copy information out of it. Also, Excel XP can sometimes repair XL files with trouble. Lastly: Download the office suite from www dot sun dot com slash staroffice (awkward spelling to hopefully avoid another autodeletion of posting...) it's a killer app for file recovery. Regards, Jan Karel Pieterse Excel TA/MVP -----Original Message----- Dear MS Support Team, I am having problem with one of the excel s/sheet I used until Friday evening. I am using MS-Excel 97 SR-1 and this s/sheet worked perfectly until Friday evening. It is a very simple data-only s/sheet..no macros/ scripts/ program at all. I saved this successfully on my 'C' drive on Friday night and tried to open it this morning but got a message box (attached in the file) with the following error - "Error Message : Address: excel.exe - Application Error" It doesn't even allow me to open the s/sheet. I have checked this file for virus and there are none. Would appreciate if you can help me in this matter as I spent considerable amount of time preparing this s/sheet. Regards, Ash . |
| 705 | Dear All I am using Excel 97. Is there any way that, as in an Access database, that an Excel workbook can be opened by many users and updated? If this requires DAO/ADO programming or general Excel functions please offer some advice on the way to target the problem. Alastair MacFarlane |
| 711 | Dear guys, For Excel 97 Version I would like to know is there anymore web query files available to download or find? Urgent, Please help Thanks very much |
| 728 | I am using Excel 97 and I have a list of hex numbers. I would like to load them into column A and have Excel recognize them as hex numbers. I would then like to add the entire column together as hex numbers in order to generate a checksum. Is there a way to do this? Thanks, Tony -- For replies, please remove the * from my email address. |
| 729 | Hi Tony: Look at the HEX2DEC and DEC2HEX functions. You need the Analysis Toolpak installed to use these. -- Regards, Vasant. **No direct emails please--keep discussion in newsgroup.** "Tony P." <principe@*.pop.cle.ab.com wrote in message news:OxJ2r9EHCHA.2544@tkmsftngp08... I am using Excel 97 and I have a list of hex numbers. I would like to load them into column A and have Excel recognize them as hex numbers. I would then like to add the entire column together as hex numbers in order to generate a checksum. Is there a way to do this? Thanks, Tony -- For replies, please remove the * from my email address. |
| 736 | If your friend saves the Works database as a text file, you'll be able to open it in Excel. If it's a Works spreadsheet, save it as Works 2.0, and you can open it in Excel. Ken wrote: Hi, I have Excel 97. A friend has Works database. Can I download and open a Works database file in Excel? I know U can convert if you can open it as works doc first. I do not have works prog. Thanks ken -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 758 | If I remember rightly, formulas cannot look at keyboard shortcuts (unless I'm mistaken). I understand what you mean, but I've tried that and it does not work. Any other suggestions? Thank you for your suggestions and continuing help. -----Original Message----- Steven if I understand your question correctly this is what you do: in J3 type =A3, then in A3 type Ctrl + ; This will enter today's fixed date. I hope that is what you want. Gilles Desjardins "Steven" <picabrillo@hotmail.com wrote in message news:10d7801c2190e$55815110$9be62ecf@tkmsftngxa03... I have posted a question relating this query titled "Printing date in Excel 97" (was on pg15 on 21/06). I was given a visual basic solution but I was wondering if it could be done using formulas. The VB way has been temperamental and does not work now. I want to be able to print an non-updateable date into a cell when data is enterred into another cell. E.g. data is entered into A3, then a date automatically appears in J3. I want to be able to do this are multiple rows. Can anyone help. Thanks in advance. . |
| 769 | I'm trying to group together a set of ActiveX option buttons using the Frame control. Unfortunately, the button which inserts a frame doesn't seem to be there! I can't seem to find it anywhere (it's not in the controls toolbar, and when I try to add it in by customising the toolbar, it's not there either). I can find the Frame button in the "Forms" toolbar, but this is not the correct frame - doesn't work because it's not ActiveX. I'm getting very frustrated here, can anyone help? I'm using excel 97. Thanks in advance, Steve |
| 770 | I'm trying to group together a set of ActiveX option buttons using the Frame control. Unfortunately, the button which inserts a frame doesn't seem to be there! I can't seem to find it anywhere (it's not in the controls toolbar, and when I try to add it in by customising the toolbar, it's not there either). I can find the Frame button in the "Forms" toolbar, but this is not the correct frame - doesn't work because it's not ActiveX. I'm getting very frustrated here, can anyone help? I'm using excel 97. Thanks in advance, Steve |
| 810 | Hi Reg, Would help if you indicated how unwanted rows are to be distinguished. You would probably want to use a macro. Some non programming techniques that might be useful are numbering an unused column with constant numbers using the fill handle, and sorting and deleting. Not knowing what you really want to delete the following works without a loop but the cells in Column A must be empty (no spaces, no formulas). [Dana DeLouis] Sub DelRowsWithEmptyColumnA() On Error Resume Next ' In case there are no blanks Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete ActiveSheet.UsedRange 'Resets UsedRange for Excel 97 End Sub Some more examples of macros can be found in "Deleting Rows" about halfway down Delete Cells/Rows in Range, based on empty cells /dmcritchie/excel/delempty.htm#rows HTH, Assistance with macros on my getstarted.htm page. , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Reg Sinha" <reginald.sinha@opbu.xerox.com wrote in message news:3D19CD32.CD80B40B@opbu.xerox.com... Dear All, I have a Excel file converted from a Crystal Report and it has unwanted rows which I wish to delete. Any ideas would be appreciated. Thanks Reg |
| 812 | Thanks David. I will visit your website. The rows to be deleted are blank rows without any formulas or text. Is this useful? wrote: Hi Reg, Would help if you indicated how unwanted rows are to be distinguished. You would probably want to use a macro. Some non programming techniques that might be useful are numbering an unused column with constant numbers using the fill handle, and sorting and deleting. Not knowing what you really want to delete the following works without a loop but the cells in Column A must be empty (no spaces, no formulas). [Dana DeLouis] Sub DelRowsWithEmptyColumnA() On Error Resume Next ' In case there are no blanks Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete ActiveSheet.UsedRange 'Resets UsedRange for Excel 97 End Sub Some more examples of macros can be found in "Deleting Rows" about halfway down Delete Cells/Rows in Range, based on empty cells /dmcritchie/excel/delempty.htm#rows HTH, Assistance with macros on my getstarted.htm page. , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Reg Sinha" <reginald.sinha@opbu.xerox.com wrote in message news:3D19CD32.CD80B40B@opbu.xerox.com... Dear All, I have a Excel file converted from a Crystal Report and it has unwanted rows which I wish to delete. Any ideas would be appreciated. Thanks Reg |
| 825 | Hi, Is there a function in Excel 97 that is equivalent to Lotus 1-2-3's @cellpointer function which returns information of the current cell ? Thanks Andy |
| 844 | Lookup the "Cell" function in XL Help. It can tell you anything you could possibly need to know about a cell. HTH RD "Andy" <atkchung@hkbn.net wrote in message news:1384301c21d26$bed9e930$35ef2ecf@TKMSFTNGXA11... Hi, Is there a function in Excel 97 that is equivalent to Lotus 1-2-3's @cellpointer function which returns information of the current cell ? Thanks Andy |
| 908 | In Excel 97 the ability to paste is inermittent. Sometimes it appears in the "Open" dialog box after copy or cut, then somtimes it doesn't - ???? Basically, I want to move files from one folder to another, without having to exit Excel, then go into explorer/my computer..... Thanks for any suggestions! |
| 1131 | illeagle operation as in legal beagle ? Since a zip drive is much more reliable than a floppy you probably aren't putting your data at as much risk as using a floppy, but your hard disk would be better. If you are going to remove the zip drive then you must use the hard drive. Note workaround to close files before taking removable media offline. ---- XL97: Ejecting Removable Media Causes Excel Page Fault (Q165205) /default.aspx?scid=kb;en-us;Q165205 When you eject the disk for removable media while a file from Microsoft Excel 97 is open; you may receive the following error message: Excel caused an invalid page fault in module EXCEL.EXE at 0137:3010E242 Note: The file does not have to be opened from the disk ejected. WORKAROUND To work around this problem, close the file in Microsoft Excel before ejecting the disk from the removable media. ---- XL2000: Files Corrupted on Save: How to Troubleshoot Source of Problem (Q213951) /default.aspx?scid=kb;EN-US;q213951 Microsoft Excel uses a technique called "back seeking" when reading and writing files. "Back seeking" means that when Microsoft Excel opens a file and reads from it, it does not necessarily read or write in a sequential manner. It may start at the first record in the file, jump to the fifteenth record, go back to the third record, and so on. This "jumping back" part may be what is causing the intermittent corruption of files especially when you are saving to a floppy disk drive. Microsoft Excel is one of a few programs that uses this technique when reading and writing files. Often these disk problems appear to exist only in Microsoft Excel. Having the floppy disk drive heads realigned should correct this problem. --- Excel opens the file on your zip drive and stores the old copy in some nonsense 8 letter filename without a file extension. So now you have two copies of your file out there. With a floppy besides being unreliable they are smaller and may run out of space. When your data is saved the old copy is removed afterwards. If you do not save then the old copy remains. I may be incorrect as which file gets the nonsense name and which file is renamed, but the effect is about the same either way. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "spookn" <spook@attnospam.net wrote in message news:O5hWUQFICHA.2496@tkmsftngp08... Hi, I realize this is a little generic of a question, but... I am volunteering at a library and came across this problem. I am not sure this question belongs here, but I wasn't sure of where it should go. While on the one PC, if you are using Excel (quite often) and remove a zip disk, it will shut off excel (without saveing of course) and give a illeagle opperation window, with the excel icon at the top-indicating that excel is the culprit I guess. If I remember correctly, you get a illeagle operation when two programs are trying for the same resourse? I know that is not much info to go on. But it happens every time, be using excel, with a zip disk in the dr, remove the disk and excel goes off and the illeagle op window comes up. I am hopeing someone has an idea for me to try. -- Peace be with you |
| 1145 | I've spent most of the weekend working on a new workbook. It is mainly arithmetic and custom views at the moment, but I've had to use one of the custom cell formats as there is no option for parentheses round negative numbers. I have Excel 2000. At the office we have Excel 97. What are the major differences I'll notice when I use the new workbook in the office? Thanks Magnus |
| 1146 | Hi Magnus <<< no option for parentheses round negative numbers "FormatCellsNumberCustom" and then enter this format to give you brackets (and red font) for negative numbers. #,##0.00 ;[Red](#,##0.00) Should work in 97 and 2000 -- Regards William willwest22@yahoo.com "Magnus Moose" <magnus@moose-ville.fsnet.co.ku wrote in message news:MPG.17896d8f6982d70d989692@news.freeserve.com... | | I've spent most of the weekend working on | a new workbook. It is mainly arithmetic | and custom views at the moment, but I've had | to use one of the custom cell formats as there | is no option for parentheses round negative numbers. | I have Excel 2000. | | At the office we have Excel 97. | What are the major differences | I'll notice when I use the new workbook | in the office? | | Thanks | Magnus |
| 1226 | An annoyance, not critical, but puzzling. I've seen this on a PC running NT with Excel 97, Windows 2000 and Excel 97, and Windows 98 and Excel 2000. (First two at work after migration from NT to 2000, and the third is my config at home) On occasion, within a workbook, when opening it up I get a 'shadow' of the workbook that I opened. One shows the file name with a (1) and the other with a (2). Entries in one book will populate the second. If I attempt to close the second workbook they both close. The only way out is to copy the worksheet into a new workbook. Any ideas as to how this is happening and if there's an easier fix? Michael |
| 1228 | But you said the formatting was different in the 2 windows... were you wrong on that point? On Mon, 1 Jul 2002 12:38:58 -0500, "DRB" <drb@barkto.com wrote: Bingo! Overlooking the obvious, that's me... "Peo Sjoblom" <terre08@mvps.org wrote in message news:#jZXTwRICHA.2612@tkmsftngp08... If it wasn't for the different formatting I'd say that somebody opened two windows of the same file and saved it (windownew window), if that was the case you can open the file, press ctrl+F4 and save the file.. -- Regards, Peo Sjoblom "DRB" <drb@barkto.com wrote in message news:uzu$jmRICHA.1784@tkmsftngp12... I have a user with an Excel 97 workbook, and when we open it (in XL97 or XL2000) it opens 2 copies- but with different formatting. If I try to close on of the two copies, it closes both. I have macros turned off, so that wouldn't appear to be the answer. Any ideas? This is weird. David |
| 1233 | All you did was somehow open a second window of that particular WB. <Window <NewWindow Just click on the second "X" from the top in the upper right of your screen and then <Save HTH RD "Michael" <selyf@hotmail.com wrote in message news:Oy8Es1VICHA.1748@tkmsftngp09... An annoyance, not critical, but puzzling. I've seen this on a PC running NT with Excel 97, Windows 2000 and Excel 97, and Windows 98 and Excel 2000. (First two at work after migration from NT to 2000, and the third is my config at home) On occasion, within a workbook, when opening it up I get a 'shadow' of the workbook that I opened. One shows the file name with a (1) and the other with a (2). Entries in one book will populate the second. If I attempt to close the second workbook they both close. The only way out is to copy the worksheet into a new workbook. Any ideas as to how this is happening and if there's an easier fix? Michael |
| 1245 | Just a guess, but maybe the second window had gridlines displayed. Maybe that was enough to make the OP think that the formats were different. (But that comment was enough for me not to guess (too?)) Myrna Larson wrote: But you said the formatting was different in the 2 windows... were you wrong on that point? On Mon, 1 Jul 2002 12:38:58 -0500, "DRB" <drb@barkto.com wrote: Bingo! Overlooking the obvious, that's me... "Peo Sjoblom" <terre08@mvps.org wrote in message news:#jZXTwRICHA.2612@tkmsftngp08... If it wasn't for the different formatting I'd say that somebody opened two windows of the same file and saved it (windownew window), if that was the case you can open the file, press ctrl+F4 and save the file.. -- Regards, Peo Sjoblom "DRB" <drb@barkto.com wrote in message news:uzu$jmRICHA.1784@tkmsftngp12... I have a user with an Excel 97 workbook, and when we open it (in XL97 or XL2000) it opens 2 copies- but with different formatting. If I try to close on of the two copies, it closes both. I have macros turned off, so that wouldn't appear to be the answer. Any ideas? This is weird. David -- Dave Peterson ec35720@msn.com |
| 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. |
| 1342 | Hello everyone I have Excel 97 and have created a Pivot Table from columns of data. One of them is headed "Month" and, when I put this into the <Page of the Pivot Table, it presents me with a list of months from Jan to Dec as well as <All. I'd like to be able to add further to this list so the table will present aggregated data, such as Quarter1, Quarter2 etc. which are simply the data from Jan, Feb and Mar added and also Apr, May and Jun added etc. I thought I might be able to do this by using a Calculated Item but I've not been able to do it. Is there some other way or am I wasting my time? Thanks in anticipation. David |
| 1344 | Hi Dave Drag the Page Field to the inner Row area, right click and select Group.... It will require that the dates are true dates and not simply text. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "David Fodden" <david.fodden@panp-tr.northy.nhs.uk wrote in message news:14c0501c2226b$27f79fe0$19ef2ecf@tkmsftngxa01... | Hello everyone | | I have Excel 97 and have created a Pivot Table from | columns of data. One of them is headed "Month" and, when | I put this into the <Page of the Pivot Table, it presents | me with a list of months from Jan to Dec as well as | <All. I'd like to be able to add further to this list so | the table will present aggregated data, such as Quarter1, | Quarter2 etc. which are simply the data from Jan, Feb and | Mar added and also Apr, May and Jun added etc. I thought | I might be able to do this by using a Calculated Item but | I've not been able to do it. Is there some other way or | am I wasting my time? | | Thanks in anticipation. | | David | |
| 1347 | Thanks for that. I got hold of a cleaner for 97 and that seems to have done the trick for now. Cheers -----Original Message----- It sounds like your file(s) got corrupted. Excel 2000 has a detect and repair feature, but I don't think Excel 97 has one. I've run into similar problems many times. I always fixed it by copying the data to a new spreadsheet and deleting the corrupted one. It can be a little work to format the new spreadsheet to be exactly like the previous one, but at least Excel won't crash and you won't lose any data. One word of warning before using the "Detect and Repair" feature in any MS program is to make a backup of your file before running it. Sometimes MS programs fix problems by deleting data. I've seen this happen numerous times when using Outlook's Detect and Repair. -----Original Message----- Hi Can anyone help with the aforementioned error message? The body of the error message states: The instruction at "0x302d75f8" referenced memory at "0x00000000". The memory could not be "read". This is from Excel 97, running Service pack 2b on Win NT4.0 SP6a. Its one of our users who keeps getting it and all she is doing is copying a Worksheet from one file into another. She can copy this sheet into a blank workbook, but always gets the same message when trying to put it into one in particular. She also gets the same types of messages while working with different spreadsheets and its usually around twice a day. She doesn't use Macros, only VLookups. Any help would be greatly appreciated. Martin . . |
| 1354 | Problem is this...I can't reproduce the problem on demand in order to test what you're suggesting. The way you describe it is what I see, a version :1 and version :2 of the same workbook. When I close one workbook they both close. I can't seem to close just one and leave a single version. When one goes, they both go. Thanks for your ideas, but there seems to be something else going on. I really wish I could recreate it rather than waiting for it to happen again. Michael "RagDyer" <PhnxDye@pacbell.net wrote in message news:OGISIykICHA.3836@tkmsftngp10... In one of these WBs, click on <Window. At the bottom of the drop down window, you should see a list of open WBs. If you see the WB name displayed as: "workbook".xls:1 "workbook".xls:2 then you *do* have a single WB with a *new* window displaying. Since the WB opened in this condition, that means it was *saved* while the additional window was open. You have to close *one* of the windows *only*, and then *save* the WB while a single version exists. If you close them both, then *no* change will occur. Are you sure that you clicked on the *second* "X" from the top *once*. The top line of your screen should now display the name of the WB without any number appended to it (if you only had 2 windows open in the first place). (An alternative to clicking on the "X", is to do a <Ctrl + F4 *once*) NOW, <Save and then close. When you re-open, you should have a single copy (window) displaying. I don't know what else to say! HTH RD "Michael" <selyf@hotmail.com wrote in message news:O0kVoojICHA.2060@tkmsftngp11... No, that's not it. I'm quite certain I opened only one copy. Clicking on the X in either copy shuts down both. They're shadows of each other, not a second version. Once the workbook takes on that behavior it seems to continue acting this way until I create a new workbook. Michael "RagDyer" <PhnxDye@pacbell.net wrote in message news:eyTGeIWICHA.2400@tkmsftngp09... All you did was somehow open a second window of that particular WB. <Window <NewWindow Just click on the second "X" from the top in the upper right of your screen and then <Save HTH RD "Michael" <selyf@hotmail.com wrote in message news:Oy8Es1VICHA.1748@tkmsftngp09... An annoyance, not critical, but puzzling. I've seen this on a PC running NT with Excel 97, Windows 2000 and Excel 97, and Windows 98 and Excel 2000. (First two at work after migration from NT to 2000, and the third is my config at home) On occasion, within a workbook, when opening it up I get a 'shadow' of the workbook that I opened. One shows the file name with a (1) and the other with a (2). Entries in one book will populate the second. If I attempt to close the second workbook they both close. The only way out is to copy the worksheet into a new workbook. Any ideas as to how this is happening and if there's an easier fix? Michael |
| 1360 | You can reproduce this by opening an existing workbook (or just starting a new one) and then clicking Window|New Window. Then you can do Window|Arrange|Tiled (if you like). Then you can check to see that RD's advice will work. Try RagDyer's advice (about the ctrl-F4) once more. Watch the title bar. You should see the :1 or :2 disappear when one of the windows close. Michael wrote: Problem is this...I can't reproduce the problem on demand in order to test what you're suggesting. The way you describe it is what I see, a version :1 and version :2 of the same workbook. When I close one workbook they both close. I can't seem to close just one and leave a single version. When one goes, they both go. Thanks for your ideas, but there seems to be something else going on. I really wish I could recreate it rather than waiting for it to happen again. Michael "RagDyer" <PhnxDye@pacbell.net wrote in message news:OGISIykICHA.3836@tkmsftngp10... In one of these WBs, click on <Window. At the bottom of the drop down window, you should see a list of open WBs. If you see the WB name displayed as: "workbook".xls:1 "workbook".xls:2 then you *do* have a single WB with a *new* window displaying. Since the WB opened in this condition, that means it was *saved* while the additional window was open. You have to close *one* of the windows *only*, and then *save* the WB while a single version exists. If you close them both, then *no* change will occur. Are you sure that you clicked on the *second* "X" from the top *once*. The top line of your screen should now display the name of the WB without any number appended to it (if you only had 2 windows open in the first place). (An alternative to clicking on the "X", is to do a <Ctrl + F4 *once*) NOW, <Save and then close. When you re-open, you should have a single copy (window) displaying. I don't know what else to say! HTH RD "Michael" <selyf@hotmail.com wrote in message news:O0kVoojICHA.2060@tkmsftngp11... No, that's not it. I'm quite certain I opened only one copy. Clicking on the X in either copy shuts down both. They're shadows of each other, not a second version. Once the workbook takes on that behavior it seems to continue acting this way until I create a new workbook. Michael "RagDyer" <PhnxDye@pacbell.net wrote in message news:eyTGeIWICHA.2400@tkmsftngp09... All you did was somehow open a second window of that particular WB. <Window <NewWindow Just click on the second "X" from the top in the upper right of your screen and then <Save HTH RD "Michael" <selyf@hotmail.com wrote in message news:Oy8Es1VICHA.1748@tkmsftngp09... An annoyance, not critical, but puzzling. I've seen this on a PC running NT with Excel 97, Windows 2000 and Excel 97, and Windows 98 and Excel 2000. (First two at work after migration from NT to 2000, and the third is my config at home) On occasion, within a workbook, when opening it up I get a 'shadow' of the workbook that I opened. One shows the file name with a (1) and the other with a (2). Entries in one book will populate the second. If I attempt to close the second workbook they both close. The only way out is to copy the worksheet into a new workbook. Any ideas as to how this is happening and if there's an easier fix? Michael -- Dave Peterson ec35720@msn.com |
| 1381 | Hello all! I have a problem that hopefully someone can help me with. One of my co-workers has a problem with Excel 97 that when she goes to use any menu item that brings up a prompt box (mainly the page setup item) her screen does not want to refresh (she cannot see her data, row and column headings, common menu items, etc) but if you take the mouse and move over the spots where the screen didn't refresh, some of the data comes back while some only have the outline of the cell or the outline of the menu bar. It has on occasion locked up and lost data. It appears as if not enough RAM is installed or needs a upgrade. They have REPLACED the RAM but I do not think they have upgraded it. We use Novell and it is on a WinNT system. Any ideas where to look? Thanks, Eric |
| 1384 | I recently installed Excel 97 on to my new desk top with Windows XP Home Edition. How when I view Excel and click on page view an error message "There is no printer installed" appears. I can't see page view because of this error message. It also occurs when I click "Header and Footer". Any suggestions? |
| 1385 | The way the page prints (and the way printpreview shows it) is dependent on the printer driver you have installed. Every printer is a little different--usually in margin size. Maybe you can add a printer driver (without actually having the physical printer). Then you can use printpreview. === If you really have a printer connected, try reinstalling it (via control panel). Bobby wrote: I recently installed Excel 97 on to my new desk top with Windows XP Home Edition. How when I view Excel and click on page view an error message "There is no printer installed" appears. I can't see page view because of this error message. It also occurs when I click "Header and Footer". Any suggestions? -- Dave Peterson ec35720@msn.com |
| 1437 | Thanks Dave I got it to work but now have two drop down lists in the <Page area. One is for the individual months (plus <All) and the other is for the grouped months (plus <All). Is it possible to amalgamate the lists into just one drop down list? I suspect not but there's no harm in asking. I can certainly live with what I have, thanks to your expertise! D. "" <DavidH@OzGrid.com wrote in message news:XdzU8.1$iK.4471@vicpull1.telstra.net... Hi Dave Drag the Page Field to the inner Row area, right click and select Group.... It will require that the dates are true dates and not simply text. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "David Fodden" <david.fodden@panp-tr.northy.nhs.uk wrote in message news:14c0501c2226b$27f79fe0$19ef2ecf@tkmsftngxa01... | Hello everyone | | I have Excel 97 and have created a Pivot Table from | columns of data. One of them is headed "Month" and, when | I put this into the <Page of the Pivot Table, it presents | me with a list of months from Jan to Dec as well as | <All. I'd like to be able to add further to this list so | the table will present aggregated data, such as Quarter1, | Quarter2 etc. which are simply the data from Jan, Feb and | Mar added and also Apr, May and Jun added etc. I thought | I might be able to do this by using a Calculated Item but | I've not been able to do it. Is there some other way or | am I wasting my time? | | Thanks in anticipation. | | David | |
| 1480 | I recently upgraded to Windows 2000 from Windows 98SE. Most of my Microsoft Office 97 works fine (Word, Access, Power Point), but I get a message on Excel that says, "C:\Program Files\Microsoft Office\Microsoft\Excel.exe is not a valid Win 32 application." The funny thing is that when I go to the CD, I can bring up Excel 97 just fine. How can I make the Program Files behave similarly? I've tried reinstalling Excel 97 from the CD with no success. brucdoe |
| 1542 | I have the MS Press Step by Step Excel 97 Visual basic manual and CD. Will this work with Excel 2000, or do I have to get another book? Thanks Gordon |
| 1543 | Hi Gordon, Everything that works in Excel 97 will work in Excel 2000. There were some new features introduced in Excel 2000 that your Excel 97 book won't cover, obviously, but otherwise you should be fine with it. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals / * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Gordon Burgess-Parker" <gordon@burgessparker.freeserve.co.uk wrote in message news:ag3idt$iktbd$1@ID-108938.news.dfncis.de... I have the MS Press Step by Step Excel 97 Visual basic manual and CD. Will this work with Excel 2000, or do I have to get another book? Thanks Gordon |
| 1545 | Rob Bovey <Rob_Bovey@msn.com after due cogitation scribbled: Hi Gordon, Everything that works in Excel 97 will work in Excel 2000. There were some new features introduced in Excel 2000 that your Excel 97 book won't cover, obviously, but otherwise you should be fine with it. * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Gordon Burgess-Parker" <gordon@burgessparker.freeserve.co.uk wrote in message news:ag3idt$iktbd$1@ID-108938.news.dfncis.de... I have the MS Press Step by Step Excel 97 Visual basic manual and CD. Will this work with Excel 2000, or do I have to get another book? Thanks Gordon Thankyou for such a prompt reply! Gordon |
| 1623 | The following article describes the problem, and suggests a workaround. It's written for Excel 2000, but should be similar in Excel 97: XL2000: Window Options Are Not Saved in a Workspace File (Q214297) /default.aspx?scid=kb;EN-US;q214297 Rachel wrote: I just tried using workspace to save a bunch of workbooks that I would like to be opened at the same time. It worked well. However, I notice that one of the workbooks where my gridlines are turned-off when I opened it using the workspace it turns it on. Why is it doing that? What are the other format that workspace changes? I am using Excel 97 under win 2000. Tahnk you in advance for your help -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 1678 | In my Excel 97 there are 65,000 rows; I need about 250,000 rows. How can I increase the capacity of my Excel to get more rows? |
| 1685 | Bill, 65536 is the limit. There is no way you can have more rows on a single sheet. You can use multiple sheets if it suits you. Or, you can make use of MS-Access for managing your data. -- Regards, Murthy "Bill DeTar" <gr33@msn.com wrote in message news:28b301c22614$8f831890$9de62ecf@tkmsftngxs01... In my Excel 97 there are 65,000 rows; I need about 250,000 rows. How can I increase the capacity of my Excel to get more rows? |
| 1704 | Hi Aileen, I hope you are opening fresh copies of the file as you experiment in recovering the file. What is the file extension and what do you see? Do you see spreadsheet gridlines and all data in column A, is your data lined up in columns with square bullets signifying where a line should break within a cell. Are you seeing this in Excel or in notepad or something else. If you see a common character between where each cell should be you can use Text to Columns if you are in Excel. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Aileen Cruz" <ailncrz@cox-internet.com wrote in message news:165ad01c2268f$4a426800$39ef2ecf@TKMSFTNGXA08... I had a worksheet with rows and columns that I created with genealogical information (dates, names, etc.) on Excel 97. Somehow these files were lost and I retrieved them back. But then I could not open them. They did not look the same. I lost all formats and the information is there but I cannot read it, it is all scrambled with symbols. Then I switched from Windows 98 to Windows XP and still I cannot open my file and make it look legible. Any suggestions on how I can accomplish this? I need help with this. Thanks for any help someone might give. |
| 1705 | Aileen Sounds like someone saved them while using Word and they got saved in Word format. This can happen even if they have the .XLS extension. If this is the case, you probably have lost them for good. HTH Gord Dibben Excel MVP - XL97 SR2 On Mon, 8 Jul 2002 07:53:58 -0700, "Aileen Cruz" <ailncrz@cox-internet.com wrote: I had a worksheet with rows and columns that I created with genealogical information (dates, names, etc.) on Excel 97. Somehow these files were lost and I retrieved them back. But then I could not open them. They did not look the same. I lost all formats and the information is there but I cannot read it, it is all scrambled with symbols. Then I switched from Windows 98 to Windows XP and still I cannot open my file and make it look legible. Any suggestions on how I can accomplish this? I need help with this. Thanks for any help someone might give. |
| 1711 | Anon You are stuck with the column width you set using Data Validation. Try a ListBox from the Forms Toolbar. This could be formatted the width you want. HTH Gord Dibben Excel MVP - XL97 SR2 On Mon, 8 Jul 2002 16:22:02 +0100, "Anonymous" <none wrote: Excel 97 Using data validation, I have created a drop-down list box. The width of this box seems to be determined by the column width. However, my columns are narrow, the cells in question being formatted so that their contents display at 90 degrees. Thus, in the drop-down box, I can see only the first 2 or 3 characters of much longer entries (some of which begin with the same 2 or 3 characters!) Is there any way of altering the width of the drop-down list box? |
| 1731 | Recently Excel 97 was reinstalled after a hard drive crash. Prior to the reinstallation, under the File menu there was a "Send To" menu. That menu is no longer available after the reinstall. I have tried Resetting the menu and I've even made a copy of my toolbar and placed it on this computer, but that option is still not available. Could anyone tell me is there a setting to make this option available. Thanks Valerie |
| 1735 | Sounds like the feature hasn't been installed in the second round. Get the installation package on an Excel/Office CD or a network/harddrive and try to install it with the missing e-mailing options checked. Jouni "Valerie" <usefornews@hotmail.com wrote in message news:u6JOZTsJCHA.1596@tkmsftngp13... Recently Excel 97 was reinstalled after a hard drive crash. Prior to the reinstallation, under the File menu there was a "Send To" menu. That menu is no longer available after the reinstall. I have tried Resetting the menu and I've even made a copy of my toolbar and placed it on this computer, but that option is still not available. Could anyone tell me is there a setting to make this option available. Thanks Valerie |
| 1767 | Maybe you could merge 2-3 adjacent cells. And then use Data|Validation against that larger merged cell. Be aware that Merged cells aren't very nice in xl97 (but much nicer in xl2002). Try to delete a single column that contains part of a merged cell. Try to insert a new column in the middle of the cell's merged area. If you're aware of the "features", maybe you won't even care! Anonymous wrote: Excel 97 Using data validation, I have created a drop-down list box. The width of this box seems to be determined by the column width. However, my columns are narrow, the cells in question being formatted so that their contents display at 90 degrees. Thus, in the drop-down box, I can see only the first 2 or 3 characters of much longer entries (some of which begin with the same 2 or 3 characters!) Is there any way of altering the width of the drop-down list box? -- Dave Peterson ec35720@msn.com |
| 1806 | Excel 2002 uses the same fileformat as 97 and 2000.. -- Regards, Peo Sjoblom "Tng Hau" <thau@gwbakeries.com wrote in message news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. |
| 1807 | -- --- HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Tng Hau" <thau@gwbakeries.com wrote in message news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. |
| 1808 | LOL. That was the second one today David -- Regards, Peo Sjoblom "" <dmcritchie@msn.com wrote in message news:uLcQkt3JCHA.2340@tkmsftngp12... -- --- HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Tng Hau" <thau@gwbakeries.com wrote in message news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. |
| 1812 | That's what I thought. But why did we get the message about "This file was created using a later version of Excel ....". Why did it keep coming up even after we clicked yes (to lose any new information)? -----Original Message----- Excel 2002 uses the same fileformat as 97 and 2000.. -- Regards, Peo Sjoblom "Tng Hau" <thau@gwbakeries.com wrote in message news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. . |
| 1813 | the only way I heve solved it to copy the sheets and modules to a new workbook in Excel 97 and save that one. Regards Ron "Tng Hau" <thau@gwbakeries.com schreef in bericht news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. |
| 1821 | Thanks. I thought about that. But I have a lot of macros and forms and range names that could become a litte messy. -----Original Message----- the only way I heve solved it to copy the sheets and modules to a new workbook in Excel 97 and save that one. Regards Ron "Tng Hau" <thau@gwbakeries.com schreef in bericht news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. . |
| 1824 | Do a save as and in the file type box - what is listed there? Microsoft excel workbook (.xls)? "Tng Hau" <thau@gwbakeries.com wrote in message news:1491901c22784$c6a69f10$2ae2c90a@hosting.microsoft.com... : Thanks. I thought about that. But I have a lot of macros : and forms and range names that could become a litte messy. : : -----Original Message----- : the only way I heve solved it to copy the sheets and : modules to a new : workbook in Excel 97 and save that one. : : Regards Ron : : "Tng Hau" <thau@gwbakeries.com schreef in bericht : news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... : I am the only one in my office so far to have the XP : version of Excel. My problem is that any file I saved : in : XP will be upgraded to the XP. When other users use my : files and try to save them, they would get a message : saying the file was created using a later version of : Excel, if you click yes you will lose the new : information, : I told the users to go ahead click yes. But the message : keeps coming back no matter how many times they do that. : Does any one how to get rid of that? I could not find : anything in the Excel XP help or in the Knowledge Base : to : help me solve this problem. Excel XP does not have an : option to save file as Excel 97 type. It only has : a "Excel 97-2000 & 5.0/95 workbook" which doubles the : size : of the file. Thanks. : : : . : |
| 1827 | no problem open the workbook and a new one rightclick on a sheetab and choose select all sheets select move or copy and choose in "to book" the new workbook. select copy!! also then OK now all sheets ar in the new workbook hit alt f11 in the VBA editor you can drag and drop the modules and userforms to the new workbook. only the code that is under thisworkbook you must copy in the thisworkbook of the new file. Regards Ron "Tng Hau" <thau@gwbakeries.com schreef in bericht news:1491901c22784$c6a69f10$2ae2c90a@hosting.microsoft.com... Thanks. I thought about that. But I have a lot of macros and forms and range names that could become a litte messy. -----Original Message----- the only way I heve solved it to copy the sheets and modules to a new workbook in Excel 97 and save that one. Regards Ron "Tng Hau" <thau@gwbakeries.com schreef in bericht news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. . |
| 1831 | Hi Peo, Demonic possession of Mouse button. Try to select something to look at and it sends out a reply. Try to drag spam to delete file and it opens the spam emailings. There were a lot more than two empty replies that tried to go out, but I don't let replies get sent immediately so caught most of them by immediately going off line and then deleting or reworking into a reply. Can't even simulate it happening offline. The mark of a true demon possession by making sure it is not predictable. Since I saw the empty reply was going to reply that the formats were same from Excel 97 and up. But then noticed that was already acknowledged in his advice to users to ignore the message, so tried to kill the reply. That reply I did manage to eliminate without it actually going out. What's really been troubling today is difficulty selecting the exact words for copying. Picking up extra characters like single quote to left, or words both left and right of what I wanted to select. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Peo Sjoblom" <terre08@mvps.org wrote in message news:eqaeHw3JCHA.2160@tkmsftngp10... LOL. That was the second [empty] one today David |
| 1843 | Show the forms toolbar. Drag a combobox to somewhere nice on the worksheet. (If you use the Alt or Shift key, you may be able to position it nicely. But this combobox doesn't sit in the cell like data|Validation. It kind of sits on top of the worksheet. Right click on it and choose Format Control|Control Tab. You'll see a box called "input range". Type a1:p1 (or click in the box and use the mouse to point at that range). In the "Cell link" box, point at an empty cell. (I used B1). Try it out. But watch B1. It changes when you use the dropdown. But it changes to a number representing how deep into your range you selected. If you want the value (and I bet you do) of the thing you selected, you could use something like: =OFFSET(A1,B1-1,0) or maybe: =IF(B1="","",OFFSET(A1,B1-1,0)) (Start in A1, go down as far as you need in the same column.) (You could use other formulas that evaluate just as well, too.) Sometimes I put this formula under the combobox toolbar. Then when I refer to it, I can just use the address for the cell that "looks like" it's holding the combobox. Now try this. Go back to the linked cell (B1 in my example). Enter 5. Look at your dropdown. Pretty neat, huh? I think that this is the quickest way to "reset" the combobox to show nothing. Anonymous wrote: Thanks for this; it looks like an interesting suggestion. Unfortunately I haven't used forms before and I seem to be having trouble accomplishing what I want. I have 16 cells, let's say A1 to P1. I want to be able to insert data into each one (separately), selected from a (single) pre-defined list. I applied data validation to these cells, having defined a validation list. Then, whenever I selected one of these cells, the drop-down list appeared. How do I go about doing something similar with a ListBox from the Forms Toolbar? "Gord Dibben" <gdibben@shaw.ca wrote in message news:hnrjiuc5nomm5labcrphopgq0si6f1t7it@4ax.com... Anon You are stuck with the column width you set using Data Validation. Try a ListBox from the Forms Toolbar. This could be formatted the width you want. HTH Gord Dibben Excel MVP - XL97 SR2 On Mon, 8 Jul 2002 16:22:02 +0100, "Anonymous" <none wrote: Excel 97 Using data validation, I have created a drop-down list box. The width of this box seems to be determined by the column width. However, my columns are narrow, the cells in question being formatted so that their contents display at 90 degrees. Thus, in the drop-down box, I can see only the first 2 or 3 characters of much longer entries (some of which begin with the same 2 or 3 characters!) Is there any way of altering the width of the drop-down list box? -- Dave Peterson ec35720@msn.com |
| 1849 | You wouldn't have just the Excel Viewer, would you? It's limitations can be found here. Excel 97/2000 Viewer: Spreadsheet Files /downloads/2000/xlviewer.aspx (Side note: I didn't think Microsoft offers an Excel XP viewer yet...) -- Dana DeLouis Windows XP & Office XP = = = = = = = = = = = = = = = = = "Leanne" <lusciouslea@uboot.com wrote in message news:1656701c22689$35999d70$39ef2ecf@TKMSFTNGXA08... I'm actaually getting a headache from this, how do I download the WHOLE excel product because, for some reason, I don't have it! So how do I get it? |
| 1851 | Hi Group, Does anyone know if the book Excel 97 SDK (I don´t have the correct title but it was published at MS Press) is still available and if not where I can find similar information? TIA, Mikael W |
| 1853 | There have been posts that say that say that applying SR2 to xl97 will fix the changing columnwidth problem. But others have said that it didn't help. Under Help|About MS Excel, what version are you running? If not SR2, you may want to visit the ms site and installing it. (It couldn't hoit!) Carlos B wrote: Hi Everyone, Hopefully someone can help me, Im getting a headache from this problem. I have a bunch of spreadsheets that are on a network. Those sheets are all locked so that none of the format changes and users can only enter info. When a user goes in sometimes and exits, the next person will go into it and the spreadsheet will change format. The fonts will change size, style, the columns will get messed up etc. How can I avoid this? It is locked so this doesnt happen. Is this a bug in Excel 97?? If so, what is the fix? Thanks in advance!!! -- Dave Peterson ec35720@msn.com |
| 1854 | Hi Tng, Excel 97 through XP should be compatible, or should they, well maybe not, here is a little item (if 13MB is little) that I found looking for an XP viewer. Glad it's not my problem. Office XP Converter Pack (13 MB download) /downloads/2002/ConvPack.aspx The Office XP Converter Pack can be useful to users or organizations that use Microsoft Office XP in a mixed environment with previous versions of Office, including Office for the Macintosh or other Office-related productivity applications. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Tng Hau" <thau@gwbakeries.com wrote in message news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. |
| 1868 | When I open an Excel 97 document by double-clicking (or Right-click Open) on the file via Windows Explorer, I get the following error message: "A document with the name "myspreadsheet.xls" is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that's currently open, or rename one of the documents." I definitely don't have two documents open with the same name. This happens despite the following: -I created a blank .xls on the same computer and then tried opening it. File was saved on remote NTFS volume as well as a Netware volume. Still got the error message. After clicking on OK of the Error, things go normally. -If Excel remains open, any other document, including the one opened first, can be opened WITHOUT the error. -The error does NOT happen if I had the file saved on the local volume, or if I did a File Open from inside Excel to open it. -Attachments to e-mail messages show the same error when tried to open, regardless of what the e-mail client is (Outlook 2002, Eudora, etc.) -I am using Netware Client 4.83 on a Windows 2000 SP2 machine. My Excel is 97 with SR2. What's going on? I was able to replicate this on another machine with the same configuration. Any insight? Thanks. |
| 1869 | Thanks everyone. This is what I ended up doing. I had to tweak the VBA codes because many of the form objects (combo boxes, list boxes etc. were created with different names). Everyting is fine now. But I think this is a bug (in Excel 97). As soon as the file is re-saved to 97 format, that annoying message should completely disappear. Also, I think Excel XP should have Excel 97 as one of the formats (not the 97-2000,5.0/95 combo format) listed in the save as type. -----Original Message----- no problem open the workbook and a new one rightclick on a sheetab and choose select all sheets select move or copy and choose in "to book" the new workbook. select copy!! also then OK now all sheets ar in the new workbook hit alt f11 in the VBA editor you can drag and drop the modules and userforms to the new workbook. only the code that is under thisworkbook you must copy in the thisworkbook of the new file. Regards Ron "Tng Hau" <thau@gwbakeries.com schreef in bericht news:1491901c22784$c6a69f10 $2ae2c90a@hosting.microsoft.com... Thanks. I thought about that. But I have a lot of macros and forms and range names that could become a litte messy. -----Original Message----- the only way I heve solved it to copy the sheets and modules to a new workbook in Excel 97 and save that one. Regards Ron "Tng Hau" <thau@gwbakeries.com schreef in bericht news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. . . |
| 1902 | Hi Try going to Start/Run and put regserver/excel.exe then OK. This should solve your problem. Regards BrianB ------------------------------------------------------------------------------- "Parhez Sattar" <pxs01@grh.org wrote in message news:<16c2901c227a4$04c6ea60$19ef2ecf@tkmsftngxa01... When I open an Excel 97 document by double-clicking (or Right-click Open) on the file via Windows Explorer, I get the following error message: "A document with the name "myspreadsheet.xls" is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that's currently open, or rename one of the documents." I definitely don't have two documents open with the same name. This happens despite the following: -I created a blank .xls on the same computer and then tried opening it. File was saved on remote NTFS volume as well as a Netware volume. Still got the error message. After clicking on OK of the Error, things go normally. -If Excel remains open, any other document, including the one opened first, can be opened WITHOUT the error. -The error does NOT happen if I had the file saved on the local volume, or if I did a File Open from inside Excel to open it. -Attachments to e-mail messages show the same error when tried to open, regardless of what the e-mail client is (Outlook 2002, Eudora, etc.) -I am using Netware Client 4.83 on a Windows 2000 SP2 machine. My Excel is 97 with SR2. What's going on? I was able to replicate this on another machine with the same configuration. Any insight? Thanks. |
| 1924 | Excel 97 I seem to remember reading somewhere that you can write "custom functions", but I can't remember the correct terminology for this and thus can't find it in Help! What I want is to define a complicated formula once, and be able to use it many times with different arguments. That way, any editing needs to be done in only one place. Can Excel do this, or have I remembered wrongly? |
| 1939 | hi! I am working on Excel 97. I have a list of 3 different stores that repeats for a total of 224 lines. Ex. store1 store2 store3 store1 store2 store3 ... I want to print (or display, whatever the technical word might be) each store by themselves. Ex. store1 store1 ... store2 store2 ... I have been reading some previous posts and it seems that arrays might be the way to go, however, I am still at a loss. Does anyone have any ideas or solutions? I would appreciate any help possiible? Also, would it be a very different solution if the number of stores changed from 3 to 7? Thank you in advance to all. -AP |
| 1945 | Alex, Autofilter is one way to go. Also, would it be a very different solution if the number of stores changed from 3 to 7? Nope. Regards from Virginia Beach, EarlK ------------------------------------------------------------- "alex" <popps85@yahoo.com wrote in message news:a4d37b64.0207101202.51eb7ac5@posting.google.com... hi! I am working on Excel 97. I have a list of 3 different stores that repeats for a total of 224 lines. Ex. store1 store2 store3 store1 store2 store3 ... I want to print (or display, whatever the technical word might be) each store by themselves. Ex. store1 store1 ... store2 store2 ... I have been reading some previous posts and it seems that arrays might be the way to go, however, I am still at a loss. Does anyone have any ideas or solutions? I would appreciate any help possiible? Thank you in advance to all. -AP |
| 1960 | alex I would first sort the data then run this Macro after selecting the range of data in the column with the stores. No difference if there are 3 stores or 7 stores. The key is to sort first. Sub InsertRow_At_Change() Dim i As Integer For i = Selection.Rows.Count To 1 Step -1 If Selection(i).Row = 1 Then Exit Sub If Selection(i) < Selection(i - 1) And Not IsEmpty(Selection(i - 1))Then With Selection(i).Resize(1, 1) .EntireRow.Insert End With End If Next End Sub HTH Gord Dibben Excel MVP - XL97 SR2 On 10 Jul 2002 13:02:46 -0700, popps85@yahoo.com (alex) wrote: hi! I am working on Excel 97. I have a list of 3 different stores that repeats for a total of 224 lines. Ex. store1 store2 store3 store1 store2 store3 ... I want to print (or display, whatever the technical word might be) each store by themselves. Ex. store1 store1 ... store2 store2 ... I have been reading some previous posts and it seems that arrays might be the way to go, however, I am still at a loss. Does anyone have any ideas or solutions? I would appreciate any help possiible? Also, would it be a very different solution if the number of stores changed from 3 to 7? Thank you in advance to all. -AP |
| 1987 | Assuming your data is in Column A you could insert a column and use =RIGHT(A1,1) in the new column then sort by this column which will have a store number in it. "EarlK" <earlk@livenet.net wrote in message news:#9emnwFKCHA.1468@tkmsftngp13... Alex, Autofilter is one way to go. Also, would it be a very different solution if the number of stores changed from 3 to 7? Nope. Regards from Virginia Beach, EarlK ------------------------------------------------------------- "alex" <popps85@yahoo.com wrote in message news:a4d37b64.0207101202.51eb7ac5@posting.google.com... hi! I am working on Excel 97. I have a list of 3 different stores that repeats for a total of 224 lines. Ex. store1 store2 store3 store1 store2 store3 ... I want to print (or display, whatever the technical word might be) each store by themselves. Ex. store1 store1 ... store2 store2 ... I have been reading some previous posts and it seems that arrays might be the way to go, however, I am still at a loss. Does anyone have any ideas or solutions? I would appreciate any help possiible? Thank you in advance to all. -AP |
| 2015 | Sometimes two add-ins fail to load when opening Excel via keyboard shortcuts to xls files with error - "Cannot open Microsoft Excel 97 Add-in for editing. Please edit the source document instead" Pressing enter twice and XL & the file open normally, except for the two add-ins (although they remain checked in the addin list). Opens normally via shortcut icons or explorer to xls files, also first opening XL then the keyboard shortcut. If I deselect the two failing add-ins, everything works normally next time I open from a shortcut. Whether or not add-ins fail to load on keyboard shortcut opening, seems (not totally sure) to be related to the order in which the add-ins were previously de & reselected. But bizarre as to why the problem only occurs with keyboard shortcut and not icon shortcut opening etc. Hardly the most serious XL problem I've ever had but slightly irritating, so any ideas appreciated. Sandy PS "Jean" reported a similar unresolved issue in this newsgroup and I've followed all the checks suggested by Nick & Jimmy; ref Subject: "Excel 97 : cannot open add-in for editing", Date: 25 Jan 2002 |
| 2016 | The following pages have some introductory info. If you keep the client info in one list it will probably be easier to manage, and to create reports. Using Access 2002 or Excel 2002 to Manage Your Data /assistance/2002/articles/oStoreDataAcEx.aspx Using Excel 97 for List Management /cits/learning/docs/pdf/s13.pdf PivotTable Reports 101 for Excel 2002, Part 1 /assistance/2002/articles/xlconPT101.aspx Joan wrote: Are there any online sites with info on databases in excel. I have lots of books,but the database format doesn't feature alot. What are the accepted rules when making one eg. for a client details. Should you just have say a sheet for each different town they in or just one big sheet and filter out info?? Are there any examples on the net?? Many thanks -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2034 | If you care to include the formula, indicating which part is subject to change, a solution involving a defined name may be available. An overly simple illustration: if the formula were Sum($A$1:$C$3)*Sum($E$1:$E$4)+n (n an integer), then zzz could be defined to refer to Sum($A$1:$C$3)*Sum($E$1:$E$4), and =zzz+n would give your result. Alan Beban Anonymous wrote: Excel 97 I seem to remember reading somewhere that you can write "custom functions", but I can't remember the correct terminology for this and thus can't find it in Help! What I want is to define a complicated formula once, and be able to use it many times with different arguments. That way, any editing needs to be done in only one place. Can Excel do this, or have I remembered wrongly? |
| 2043 | In Excel 97 I could use a custom format such as 000 to force a 1 to be 001. This is very important to a number of our codes. I can't use text for this purpose because numbers don't sort correctly as text, ie 021 wii before 003. In Excel 2000 this no longer works. Is there another way to do this?? Thanks Karren |
| 2061 | My toolbar file in Excel 97 and Windows 98SE is: C:\WINDOWS\UserName8.xlb My toolbar file in Excel 2000 and Windows 98SE is: C:\WINDOWS\Application Data\Microsoft\Excel\Excel.xlb This is UN-tested: Find the Excel.xlb file on the destination machine. Rename the Excel.xlb file on the destination machine to Excel.bak (or something else that isn't used) Copy the xxxx8.xlb file from the source machine. Paste the xxxx8.xlb file in the same location as the Excel.bak Rename the xxxx8.xlb to Excel.xlb "Tom S" <Sinskit@usa.redcross.org wrote in message news:173d301c2290b$47e4c7f0$b1e62ecf@tkmsftngxa04... How do I convert an Excel 97 file with vba code and custom menus to excel 2002. The MS Knowledge Base web site says custom toolbars will not be migrated. Then to open the *8.xlb file to view the toolbars in 2002. Problem is my computer with Windows 2000 on it does not have a *8.xlb file to open. |
| 2072 | It might be just a little bit easier to format that *empty* cell as you wish, prior to copying. HTH RD "Karren" <kbeedonohoe@stny.rr.com wrote in message news:17a3501c2291b$b6e10050$19ef2ecf@tkmsftngxa01... Deborah, THANKS It worked!!! Karren -----Original Message----- To change the data into numbers: 1. Select an empty cell 2. Click the Copy button 3. Select the column of numbers 4. Choose EditPaste Special 5. Select Add, click OK Then apply the custom number format of 000 Karren wrote: Tim, When the data is brought into excel from an Oracle Database or Access, I lose the leading 0's. With the cells set to number and the formatting set to 000 or however many digits I needed, the 0's would re-appear in the cells. Now this no longer works. I don't know where to go to Complain or how maybe something else will do the same thing. As Text I can't get my leading 0's to come back. Karren -----Original Message----- It sounds like some of your data is numbers and some is text. A change in format won't affect text. (If they were all text with leading zeros, they would sort correctly, but there are other reasons for preferring numbers over text.) Tim C "Karren" <kbeedonohoe@stny.rr.com wrote in message news:1721b01c228f0$5973ab50$b1e62ecf@tkmsftngxa04... In Excel 97 I could use a custom format such as 000 to force a 1 to be 001. This is very important to a number of our codes. I can't use text for this purpose because numbers don't sort correctly as text, ie 021 wii before 003. In Excel 2000 this no longer works. Is there another way to do this?? Thanks Karren . -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html . |
| 2096 | Many thanks, those articles are great. I have bookmarked the microsoft office assistance site, sad to say I hadn't even looked there..talk about missing the obvious. "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D2D6C43.8010008@contextures.com... The following pages have some introductory info. If you keep the client info in one list it will probably be easier to manage, and to create reports. Using Access 2002 or Excel 2002 to Manage Your Data /assistance/2002/articles/oStoreDataAcEx.aspx Using Excel 97 for List Management /cits/learning/docs/pdf/s13.pdf PivotTable Reports 101 for Excel 2002, Part 1 /assistance/2002/articles/xlconPT101.aspx Joan wrote: Are there any online sites with info on databases in excel. I have lots of books,but the database format doesn't feature alot. What are the accepted rules when making one eg. for a client details. Should you just have say a sheet for each different town they in or just one big sheet and filter out info?? Are there any examples on the net?? Many thanks -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2108 | Dave, You are, or should I say Myrna is right. But how did you remember yet alone relate that thread to my posting, not immediately obvious. Thanks for picking it up. Assigning anything but Shift to my keyboard shortcuts allows all add-ins to load normally. Also as I hinted before, the problem is indeed related to the order in which add-ins had previously been de & reselected. I can now recreate and solve the problem and allow Shift in shortcuts. For anyone else troubleshooting the "orders" are not in reverse, instead somewhat illogical in my case. I had recently installed ASAP-utilities (www.asap- utilities.nl) which has many Ctrl+Shift shortcuts to macros, duplicating all my *.xls file shortcuts. De & reselecting caused both this and XL original Analysis ToolPak to fail. Odd, as the latter contains no shortcuts. Thanks again. Regards, Sandy -----Original Message----- A couple of years ago, there was a discussion about why a macro would not fire when it was started by using a shortcut key (assigned to a macro in excel). This is part of what Myrna Larson wrote then. I'm not sure if it fits your case, but it sounds pretty close: ===== From Myrna: It has to do with the fact that the shortcut key uses SHIFT. Excel "remembers" that the shift key was used to start the macro and behaves as though it's still depressed when the 2nd file is opened. Opening a file with the shift key down suppresses the running of a macro, and evidently also aborts one that is already running. In my book, this is a bug. In my case, the shortcut key was CTRL+SHIFT+U. The only workaround that I found was to use CTRL+U instead, i.e. assign a shortcut key that doesn't use the SHIFT key. ===== You can read the whole thread at: /groups? threadm=u7ufks038r9jjaaa3jrt2c3cpilu7rshja%404ax.com Sandy V wrote: Sometimes two add-ins fail to load when opening Excel via keyboard shortcuts to xls files with error - "Cannot open Microsoft Excel 97 Add-in for editing. Please edit the source document instead" Pressing enter twice and XL & the file open normally, except for the two add-ins (although they remain checked in the addin list). Opens normally via shortcut icons or explorer to xls files, also first opening XL then the keyboard shortcut. If I deselect the two failing add-ins, everything works normally next time I open from a shortcut. Whether or not add-ins fail to load on keyboard shortcut opening, seems (not totally sure) to be related to the order in which the add-ins were previously de & reselected. But bizarre as to why the problem only occurs with keyboard shortcut and not icon shortcut opening etc. Hardly the most serious XL problem I've ever had but slightly irritating, so any ideas appreciated. Sandy PS "Jean" reported a similar unresolved issue in this newsgroup and I've followed all the checks suggested by Nick & Jimmy; ref Subject: "Excel 97 : cannot open add- in for editing", Date: 25 Jan 2002 -- Dave Peterson ec35720@msn.com . |
| 2119 | In Works, he can save the files as Excel 2000 files. 1. Choose FileSave As 2. From the Save As Type drodown, choose Excel 97-2000 (*.xls) 3. Click Save Trevor wrote: I have a student who is on an Excel 2000 course, but only has Works 2002 installed on his PC at home. This causes a problem in that he cannot open any files he creates at home as they are saved as wks files that Excel 2000 cannot read. I know there is a converter program to open Works 2002 WPS wordprocessor files, but cannot find any similar program for the Works spreadsheets. Can any one help???? Thanks Trevor -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2150 | I have Excel 97 SR-1. I can undo changes made before a save in Word 97 SR-1 but not in Excel. When I save a spreadsheet I lose the ability to undo changes made before the save. Is there a way in Excel to undo pre-save changes? Thanks, Roy |
| 2152 | Q120596 -- XL: Importing Text Files Larger Than 16384 Rows Breaks files longer than sheet limit into more sheets. (Also covers Microsoft Excel 97 and up which have a limit of 65,536 rows) /support/kb/articles/q120/5/96.asp HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm <maictab@aol.com wrote in message news:15aac01c229ad$6fc5cbf0$36ef2ecf@tkmsftngxa12... How do I export records from an Access Query that exceeds 65000 records to Excel if the limit on one sheet in Excel is 65000? Is there a way to put a check in place that staes if records 64000 move to next sheet? Or is there a parameter I can put on the query that says send Field "A" to sheet1 and Field "B" to sheet2? I attached a Access DB with a test query that exceeds 65000 records. |
| 2160 | Has anyone had any experience with performance problems moving from Excel 79 to 2002? My specific problem appears to be related to very large spreadsheets that contain macros. In Excel 97 the module runs in 3 minutes. In Excel 2002 the module takes 24 minutes. Others have complained that performance is poor even in spreadsheets not containing macros. Any help? |
| 2163 | What are the system specs how was in installed (Clean build?) Most importantly how much memory is in your machines? -----Original Message----- Has anyone had any experience with performance problems moving from Excel 79 to 2002? My specific problem appears to be related to very large spreadsheets that contain macros. In Excel 97 the module runs in 3 minutes. In Excel 2002 the module takes 24 minutes. Others have complained that performance is poor even in spreadsheets not containing macros. Any help? . |
| 2234 | Hi Andonny, See these articles in the Microsoft Knowledge Base: Q153090 How To Pass a Visual Basic Array to an Excel Worksheet /default.aspx?scid=kb;en-us;Q153090 Q177991 XL: Limitations of Passing Arrays to Excel Using Automation /default.aspx?scid=kb;en-us;Q177991 Q146406 XL: How to Retrieve a Table from Access into Excel Using DAO /default.aspx?scid=kb;en-us;Q146406 Q247412 INFO: Methods for Transferring Data to Excel from Visual Basic /default.aspx?scid=kb;en-us;Q247412 Q75376 XL: Maximum Array Size in Microsoft Excel /default.aspx?scid=kb;en-us;Q75376 Q166342 XL97: Maximum Array Size in Microsoft Excel 97 /default.aspx?scid=kb;en-us;Q166342 Q153307 HOWTO: Call Microsoft Excel Macros that Take Parameters /default.aspx?scid=kb;en-us;Q153307 Q163435 VBA: Programming Resources /default.aspx?scid=kb;en-us;Q75376 HTH --- Orlando Magalhăes Filho (So that you get best and rapid solution and all may benefit from the discussion, please reply within the newsgroup, not in email) "Andonny" <wje@multiline.com.au escreveu na mensagem news:eYJ0IAwKCHA.1988@tkmsftngp08... Hi, I am looking for a site where I could learn about arrays when used in functions and also used in visual balsic routines. Specially when setting ranges. I am aware of the pitfalls when using arrays but I still would like to learn more about them. Thanks for your help Andonny |
| 2306 | Help...I receive this message when trying to open a previously saved excel file. Am using Excel 97 SR2 with Windows 97. |
| 2332 | Could you by chance opened the file in Word (and then saved)? If yes, then you're probably in trouble. You might be able to get back one sheets worth of data by reopening in Word and copy|pasting. Do you have a backup copy? mark wrote: Help...I receive this message when trying to open a previously saved excel file. Am using Excel 97 SR2 with Windows 97. -- Dave Peterson ec35720@msn.com |
| 2436 | Deb: What does it sound like when YOU pronounce File|Open??? Debra Dalgleish wrote: Sounds like Speech Recognition is turned on (and the louder you curse, the worse things get <g) Choose ToolsSpeechSpeech Recognition (if it had a check mark, it was turned on) Bob in Kansas wrote: Also, I have checked mouse & keyboard connections, running Pentium 4/1.6 with 512 MB RAM & these problems not occurring in any other application. Bob in Kansas Am running Office XP. Using Excel everything was fine until a week ago I opened an Excel 97 file my son sent to me. Now my Excel is acting as if I am infected with a MACRO virus. I started noticing that about 5 - 10 seconds after opening my Excel Workbook: 1. The File Menu drop down would open without my prompting then 2. The Window Menu drop down then 3. The File Menu drop down and the Open File Submenu then 4 Clear text phrases (incomplete sentences but ungarbled) would start being entered in whatever cell I had selected. This would over-write any data already in the cell. E.g., he know whose who shall not begin shall begin with . . . The above would happen without my touching the keyboard or mouse. I suspected a Macro virus but Macro security Level is set to 'High' and Tools/Macros lists NO macros. I suspected the windows recorder was playing something back but it's not active. The only active application process when this is occuring is 'Microsoft Excel' I suspected someone has backdoored me and had partial control of my PC but this is occuring even when I am off line. Have been running NAV 2002 and it is updated automatically and I have manually scanned my System, Program & data files. No virus found. I did an Office XP repair which reinstalls the Office XP Suite. This fixed the text over-writing - problem #4 above but the other problems are interrupting my data entry and are annoying in the least. I manually uninstalled Excel and then reinstalled it. Problems 1 thru 3 still occuring. I sent my son a copy of my workbook which he opened in Excel 97 and he can NOT duplicate the problem. I don't know what else to try. Anyone have any suggestions? Thank you. Bob in Kansas -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Dave Peterson ec35720@msn.com |
| 2441 | Some people report that if they upgrade to xl97sr2, this problem goes away. (Others report no affect...) Susan wrote: In Excel 97 is it possible that after I have made changes to the width of a column, save and closed it, that when I re-open the document the column reverts back to the previous size? I have a user that I work with that this happens to from time to time. -- Dave Peterson ec35720@msn.com |
| 2443 | No problems with FileOpen, but every time I say 'about' the computer reboots! Dave Peterson wrote: Deb: What does it sound like when YOU pronounce File|Open??? Debra Dalgleish wrote: Sounds like Speech Recognition is turned on (and the louder you curse, the worse things get <g) Choose ToolsSpeechSpeech Recognition (if it had a check mark, it was turned on) Bob in Kansas wrote: Also, I have checked mouse & keyboard connections, running Pentium 4/1.6 with 512 MB RAM & these problems not occurring in any other application. Bob in Kansas Am running Office XP. Using Excel everything was fine until a week ago I opened an Excel 97 file my son sent to me. Now my Excel is acting as if I am infected with a MACRO virus. I started noticing that about 5 - 10 seconds after opening my Excel Workbook: 1. The File Menu drop down would open without my prompting then 2. The Window Menu drop down then 3. The File Menu drop down and the Open File Submenu then 4 Clear text phrases (incomplete sentences but ungarbled) would start being entered in whatever cell I had selected. This would over-write any data already in the cell. E.g., he know whose who shall not begin shall begin with . . . The above would happen without my touching the keyboard or mouse. I suspected a Macro virus but Macro security Level is set to 'High' and Tools/Macros lists NO macros. I suspected the windows recorder was playing something back but it's not active. The only active application process when this is occuring is 'Microsoft Excel' I suspected someone has backdoored me and had partial control of my PC but this is occuring even when I am off line. Have been running NAV 2002 and it is updated automatically and I have manually scanned my System, Program & data files. No virus found. I did an Office XP repair which reinstalls the Office XP Suite. This fixed the text over-writing - problem #4 above but the other problems are interrupting my data entry and are annoying in the least. I manually uninstalled Excel and then reinstalled it. Problems 1 thru 3 still occuring. I sent my son a copy of my workbook which he opened in Excel 97 and he can NOT duplicate the problem. I don't know what else to try. Anyone have any suggestions? Thank you. Bob in Kansas -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2444 | Very funny! Debra Dalgleish wrote: No problems with FileOpen, but every time I say 'about' the computer reboots! Dave Peterson wrote: Deb: What does it sound like when YOU pronounce File|Open??? Debra Dalgleish wrote: Sounds like Speech Recognition is turned on (and the louder you curse, the worse things get <g) Choose ToolsSpeechSpeech Recognition (if it had a check mark, it was turned on) Bob in Kansas wrote: Also, I have checked mouse & keyboard connections, running Pentium 4/1.6 with 512 MB RAM & these problems not occurring in any other application. Bob in Kansas Am running Office XP. Using Excel everything was fine until a week ago I opened an Excel 97 file my son sent to me. Now my Excel is acting as if I am infected with a MACRO virus. I started noticing that about 5 - 10 seconds after opening my Excel Workbook: 1. The File Menu drop down would open without my prompting then 2. The Window Menu drop down then 3. The File Menu drop down and the Open File Submenu then 4 Clear text phrases (incomplete sentences but ungarbled) would start being entered in whatever cell I had selected. This would over-write any data already in the cell. E.g., he know whose who shall not begin shall begin with . . . The above would happen without my touching the keyboard or mouse. I suspected a Macro virus but Macro security Level is set to 'High' and Tools/Macros lists NO macros. I suspected the windows recorder was playing something back but it's not active. The only active application process when this is occuring is 'Microsoft Excel' I suspected someone has backdoored me and had partial control of my PC but this is occuring even when I am off line. Have been running NAV 2002 and it is updated automatically and I have manually scanned my System, Program & data files. No virus found. I did an Office XP repair which reinstalls the Office XP Suite. This fixed the text over-writing - problem #4 above but the other problems are interrupting my data entry and are annoying in the least. I manually uninstalled Excel and then reinstalled it. Problems 1 thru 3 still occuring. I sent my son a copy of my workbook which he opened in Excel 97 and he can NOT duplicate the problem. I don't know what else to try. Anyone have any suggestions? Thank you. Bob in Kansas -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Dave Peterson ec35720@msn.com |
| 2446 | You can export the document from Word to a HTML page, and read the table generated back to Excel. We've done it several time for a customer who's to stupid to remember that Excel is for Spreadsheets and Word for letters (must admit, they are blond). Jeroen "Dave Peterson" <ec35720@msn.com schreef in bericht news:3D335537.E91545BE@msn.com... Could you by chance opened the file in Word (and then saved)? If yes, then you're probably in trouble. You might be able to get back one sheets worth of data by reopening in Word and copy|pasting. Do you have a backup copy? mark wrote: Help...I receive this message when trying to open a previously saved excel file. Am using Excel 97 SR2 with Windows 97. -- Dave Peterson ec35720@msn.com |
| 2504 | When I double-click on a shortcut to an Excel spreadsheet on my hard drive, Excel 97 and the file open normally but then I get the the error message, "A document with the name <Filename is already open. You cannot open two documents with the same name, even if the documents are in different folders...." I assume that somehow, Excel is trying to open the same document twice. This only happens when I open using a shortcut to the spreadsheet or with the target icon itself. If I open Excel first and then open the spreadsheet from within the program, it loads OK. This problem occurs with every spreadsheet I have, so it does not to be related to the particular file I'm trying to open. I'm using WinXP Pro and Office 97 professional. I never had this problem before switching to XP. Ideas, anyone? Thanks. Jon |
| 2505 | Do you have your system to open documents based on single mouse clicks? "Jon Condra" <condraj1@comcast.net wrote in message news:455401c22d8d$b73e0950$9de62ecf@tkmsftngxs01... : When I double-click on a shortcut to an Excel spreadsheet : on my hard drive, Excel 97 and the file open normally but : then I get the the error message, "A document with the : name <Filename is already open. You cannot open two : documents with the same name, even if the documents are : in different folders...." : : I assume that somehow, Excel is trying to open the same : document twice. : : This only happens when I open using a shortcut to the : spreadsheet or with the target icon itself. If I open : Excel first and then open the spreadsheet from within the : program, it loads OK. This problem occurs with every : spreadsheet I have, so it does not to be related to the : particular file I'm trying to open. : : I'm using WinXP Pro and Office 97 professional. I never : had this problem before switching to XP. Ideas, anyone? : Thanks. : Jon |
| 2516 | I have a workbook "A" that contains links to many other workbooks. I'm finding that periodically, when I click a link to open, make changes to, save and then close workbook "B", Excel actually closes not only the linking book, but all other open workbooks as well. I have attempted to use the close command from the File menu, the close button on the toolbar and have even made a button with a couple lines of code to specifically ensure that the appropriate book is the active one, then close it. I have Excel 97 running in NT 4. I haven't been able to intentionally cause the problem to happen, nor can I identify any common elements that are present each time the problem occurs. Any advice or workarounds would be extremely welcome! Tom |
| 2519 | Hi Machine, a) Check that Excel 97 is at the SR2 level. b) check out the Slow Open/close section at /optspeedd.htm to see if anything there helps. c) See if you get the same problem when you copy the workbook to a local drive. d) If you still have the problem then you probably have a corrupt workbook: try opening it in Excel 2002 or rebuilding it. Charles Williams ______________________ Decision Models The Excel Calculation Site www.DecisionModels.com "machine" <machine@machine.com.it wrote in message news:YHcZ8.37053$Hj3.110860@newsfeeds.bigpond.com... hi guys...i really need someone to throw me a freakin' bone on this one. when i open an excel document on any PC in a particular network i maintain (workstations all NT and office 97), the cpu usage goes straight up to 100% and stays there and the application stops responding - no other applications open at all. there are other networks that i maintain that have exactly the same SOE yet they do not behave in this way. i'm not even sure where to start looking to get to the bottom of this one...so any and all suggestions are most welcome. hardware is mostly PII 550, 64MB...slow by todays standards, but it works (usually). all documents stored on network drives. office 97 installed on each individual machine...obviously. |
| 2520 | Excel 97 - Style 'currency' not found error My user in Excel 97 has three tool bar boxes that are giving this Style '' not found error. Any thoughts before I reinstall Excel? mick2767@hotmail.com |
| 2547 | You can merge it back into your workbook by using a workbook that still has this style. Format|Style|Merge (have both workbooks open) Or you can create it again yourself. Format|Style Type in a nice name (Currency) turn off all the check marks (except for Number) Then click Modify Click on Accounting on the number tab. (Taken from xl2002 currency style) Mick wrote: Excel 97 - Style 'currency' not found error My user in Excel 97 has three tool bar boxes that are giving this Style '' not found error. Any thoughts before I reinstall Excel? mick2767@hotmail.com -- Dave Peterson ec35720@msn.com |
| 2553 | Tim, Excel XP allows you to specify that users can (or can't) do sorts, autofilters, and all kinds of things when the sheet is protected. Unfortunately, it doesn't seem to include showing and hiding rows using the outline symbols, which is a bit ironic, since this isn't changing any data any more than a sort or autofilter, only visibility. If no one comes along with a better solution, and if you're showing and hiding entire levels (using the numbers at the top of the outline symbols, rather than individual groups), you can make macros like: Sub setup() ActiveSheet.Protect userinterfaceonly:=True End Sub This protects the sheet, but not from the ravages of a macro. It only has to be run once (and will last through closing and reopening of the workbook Now have a couple or three of: Sub Level1 ActiveSheet.Outline.ShowLevels RowLevels:=1 End Sub Sub Level2 ActiveSheet.Outline.ShowLevels RowLevels:=2 End Sub They go in a regular module. Now use the drawing toolbar to put buttons on the sheet, then use the right click to assign each to its respective macro. Be sure to put the buttons where they won't get squashed by the hiding of the outline section. Now those buttons can work the showing and hiding of the outline while the sheet is protected. Regards from Virginia Beach, EarlK ------------------------------------------------------------- "Tim McPhillips" <mcptjm@yahoo.com wrote in message news:197ca01c22dc6$101c4d60$19ef2ecf@tkmsftngxa01... I need help with some forecasting templates I am creating at work. I have worksheets that have three levels of outlines in the rows (to expand and contract detail). I would like to prevent the user from overwriting certain cells by locking cells and protecting the sheet. However, if I protect the sheet the outlines become inoperable. My company is on the cutting edge of technology with Excel 97 and I don't know if this problem has been addressed in later versions of Excel. Any suggested work-arounds? Any help would be appreciated. Tim McPhillips |
| 2561 | You can do something like this in VBA: ActiveSheet.EnableOutlining = True ActiveSheet.Protect contents:=True, userInterfaceOnly:=True But it has to be reset each time the workbook opens. (So put it in auto_open or workbook_open) Excel won't remember it between sessions. Tim McPhillips wrote: I need help with some forecasting templates I am creating at work. I have worksheets that have three levels of outlines in the rows (to expand and contract detail). I would like to prevent the user from overwriting certain cells by locking cells and protecting the sheet. However, if I protect the sheet the outlines become inoperable. My company is on the cutting edge of technology with Excel 97 and I don't know if this problem has been addressed in later versions of Excel. Any suggested work-arounds? Any help would be appreciated. Tim McPhillips -- Dave Peterson ec35720@msn.com |
| 2569 | No, I don't. This is the only application in which this happens. Further, my mouse settings are such that I couldn't be accidentally introducing another click (or two). -----Original Message----- Do you have your system to open documents based on single mouse clicks? "Jon Condra" <condraj1@comcast.net wrote in message news:455401c22d8d$b73e0950$9de62ecf@tkmsftngxs01... : When I double-click on a shortcut to an Excel spreadsheet : on my hard drive, Excel 97 and the file open normally but : then I get the the error message, "A document with the : name <Filename is already open. You cannot open two : documents with the same name, even if the documents are : in different folders...." : : I assume that somehow, Excel is trying to open the same : document twice. : : This only happens when I open using a shortcut to the : spreadsheet or with the target icon itself. If I open : Excel first and then open the spreadsheet from within the : program, it loads OK. This problem occurs with every : spreadsheet I have, so it does not to be related to the : particular file I'm trying to open. : : I'm using WinXP Pro and Office 97 professional. I never : had this problem before switching to XP. Ideas, anyone? : Thanks. : Jon . |
| 2573 | I just did an experiment that, I think, exonerates the mouse. Right-clicking on the icon or its shortcut and selecting "open", I get the very same error message. Therefore, the problem appears to be either in Excel, WinXP, or in their interaction. Jon "Layla" <Layla@clapton.com wrote in message news:O3Xwx5YLCHA.1468@tkmsftngp13... Do you have your system to open documents based on single mouse clicks? "Jon Condra" <condraj1@comcast.net wrote in message news:455401c22d8d$b73e0950$9de62ecf@tkmsftngxs01... : When I double-click on a shortcut to an Excel spreadsheet : on my hard drive, Excel 97 and the file open normally but : then I get the the error message, "A document with the : name <Filename is already open. You cannot open two : documents with the same name, even if the documents are : in different folders...." : : I assume that somehow, Excel is trying to open the same : document twice. : : This only happens when I open using a shortcut to the : spreadsheet or with the target icon itself. If I open : Excel first and then open the spreadsheet from within the : program, it loads OK. This problem occurs with every : spreadsheet I have, so it does not to be related to the : particular file I'm trying to open. : : I'm using WinXP Pro and Office 97 professional. I never : had this problem before switching to XP. Ideas, anyone? : Thanks. : Jon |
| 2605 | I had the same problem up until yesterday on my XP Home. Here is what fixed it. Start/Run excel.exe /regserver You might want to give it a try. Good Luck! "Jon Condra" <condraj1@comcast.net wrote in message news:455401c22d8d$b73e0950$9de62ecf@tkmsftngxs01... When I double-click on a shortcut to an Excel spreadsheet on my hard drive, Excel 97 and the file open normally but then I get the the error message, "A document with the name <Filename is already open. You cannot open two documents with the same name, even if the documents are in different folders...." I assume that somehow, Excel is trying to open the same document twice. This only happens when I open using a shortcut to the spreadsheet or with the target icon itself. If I open Excel first and then open the spreadsheet from within the program, it loads OK. This problem occurs with every spreadsheet I have, so it does not to be related to the particular file I'm trying to open. I'm using WinXP Pro and Office 97 professional. I never had this problem before switching to XP. Ideas, anyone? Thanks. Jon |
| 2610 | Thanks a lot...that fixed it. What does this command do? Jon "Jack Gillis" <jgilNOSPAM@widomaker.com wrote in message news:O1z2fZkLCHA.2604@tkmsftngp11... I had the same problem up until yesterday on my XP Home. Here is what fixed it. Start/Run excel.exe /regserver You might want to give it a try. Good Luck! "Jon Condra" <condraj1@comcast.net wrote in message news:455401c22d8d$b73e0950$9de62ecf@tkmsftngxs01... When I double-click on a shortcut to an Excel spreadsheet on my hard drive, Excel 97 and the file open normally but then I get the the error message, "A document with the name <Filename is already open. You cannot open two documents with the same name, even if the documents are in different folders...." I assume that somehow, Excel is trying to open the same document twice. This only happens when I open using a shortcut to the spreadsheet or with the target icon itself. If I open Excel first and then open the spreadsheet from within the program, it loads OK. This problem occurs with every spreadsheet I have, so it does not to be related to the particular file I'm trying to open. I'm using WinXP Pro and Office 97 professional. I never had this problem before switching to XP. Ideas, anyone? Thanks. Jon |
| 2639 | Using Excel 2002, I could only reproduce your symptoms when the period crossed into a second year and does not cross a 2/28-3/1 boundary, in which case Excel uses the shorter of the two years (365). I don't know if this is standard in the financial world, or an Excel thing. Tim C "Joe" <johnsonj@fhlbsf.com wrote in message news:19f9701c22eab$e2e551c0$19ef2ecf@tkmsftngxa01... I am using excel 97. I am using the YEARFRAC function to determine the interest payment period for financial instruments with Actual/Actual day counts. I entered "1" as the final argument, but the function does not account for lear year. Example, the fraction is the same for a 31 day period in 2003 as it is in 2004. What am I doing wrong? |
| 2640 | XL does account for leap year. You'll get different values if Feb 29 is inclusive of the date range. Otherwise, the values will be the same. =YEARFRAC("1/20/03","2/25/03",1) = .09863 =YEARFRAC("1/20/04","2/25/04",1) = .09863 but =YEARFRAC("2/15/03","3/20/03",1) = .09041 =YEARFRAC("2/15/04","3/20/04",1) = .09290 HTH Jason Atlanta, GA -----Original Message----- I am using excel 97. I am using the YEARFRAC function to determine the interest payment period for financial instruments with Actual/Actual day counts. I entered "1" as the final argument, but the function does not account for lear year. Example, the fraction is the same for a 31 day period in 2003 as it is in 2004. What am I doing wrong? . |
| 2853 | I think you're slightly confused about Windows and Office (excel in particular). Windows 3.1, Win95, Win98, WinME, WinNT, and WinXP are operating systems. That means they handle things like file structures (folders, subfolders, files)--not the actual data that is contained in the files, but how they're stored and accessed by the application. (But every new version of windows has more mini-applications built in. But Office (word, excel, etc) has never been included in any version of windows.) Application programs (like Word, Excel, Powerpoint, and tons of others) actually do the work of storing information in the file. So you question has become a couple of questions: If I use a different version of windows at work than I do at home, will I have trouble with my application files? The answer to that is probably not. I use WinNT at work and Win98 at home and have shared files between them (via floppy disk, cdrom, email) and never had a problem with differences in windows versions. The second question becomes: Will I have problems using my work Excel file at home? And my home files at work? (I guess that's two questions!) The answer to this is it depends. You say your home computer uses Office 2k (and therefore, excel 2k). But you don't say what version of Office you use at home. If you are using xl95 at home, then you might have problems. Excel 97 and above have an option to save to version 95 (and a combination of 95/97 that actually saves two versions in one file!). If you save in a common format, then you should be able to open your file at home, work on it and bring it back to work. The bad news is that xl97 (and xl2k and xl2002) all added something new to excel. If you rely on any of these newer features, then you should upgrade to at least the same version as you have work. But my bet is that you don't have xl95. (It's pretty old, now.) If you are using xl97/xl2k/xl2002 (office 97, office 2000, or office XP) at home, then you shouldn't have any problems. There's not too much difference between these three versions that should be show stoppers. (Although there might be. There are differerences that were introduced with each version that are not available in the previous version.) If you are using xl2002 (office XP) and you might be on what sounds like your new computer (since you're using Windows XP, it sounds pretty new), you probably won't have any problems at all. We use xl2000 at work. I have xl2002 at home. I've never had a problem sharing files between them. ============ One of the biggest differences between xl97 and xl2000 is protection for the VBA macro code. If a project is protected in xl2k, then xl97 won't open the VBA portion for editing. The file will open ok and the macros will run. You just can't open the VBA portion for viewing/editing. (You have to go back to xl2k and save the project without a password. Then xl97 can open that macro code. Again, this isn't the worksheet stuff. It's the VBA macro stuff.) "Milo K. Anderson Sr." wrote: I have Win ME on my home computer using Office 2000 Prem. I have tried to veiw excel documents created by Win XP on my home computer with no luck. Is it possible to view documents created in XP on a Win ME system, or is the file system of XP (ntfs) not compatible with Win ME? If that is the case, is there some way to accomplish this without upgrading to Win XP? This is vital to me as I need to bring work home from a XP based system. -- Dave Peterson ec35720@msn.com |
| 2863 | Not sure what you want here. 1. If you put an email address into an Excel 2000 cell it is recognised as such, and you can double click to get a blank mail form. Excel 97 would need a macro to do this. 2. If you want to copy and paste the text of an email, it will go into a cell, but I put it into a TextBox from the Drawing toolbar. If this is not what you want, please be more explicit & state your Excel version. Regards BrianB --------------------------------------------------------------- "Xander" <pvoogt@mnszw.nl wrote in message news:<1a42301c2315b$de5b1010$b1e62ecf@tkmsftngxa04... I would like to know how I might be able to insert an e- mail into a Excell cell as a reference. Thanks in advance. |
| 2866 | Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene |
| 2872 | Opps...darn wrapping link...try this link: /?W25B42351 "Laura Wilde" <laura@top-brands.com wrote in message news:ujKJ8TcMCHA.2372@tkmsftngp11... Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene |
| 2877 | Many thanks, Gord and Debra. At some point, when I was reading MVP verbage about templates, I must have changed my default directory for templates (in Word). I'll change it as you both suggest. Thanks so much. st. "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D3C6DD0.7060700@contextures.com... Is this where both files were previously, or did you move them both there? Personal.xls should be there, but Normal.dot shouldn't. (You referred to Personal.dot -- I hope that was a typo!) Delete the Normal.dot template from the XLStart folder (or rename it, and move it to a different folder.) When you start Word, it will automatically create a new Normal.dot document. If it creates the Normal.dot document in the XLStart folder (it shouldn't), then you'll have to change your file path settings in Word Splash wrote: Thanks, Debra. I'm using Windows2000 and Office2000. Both Normal.dot and Personal.dot are stored in C:\ProgFiles\MSOff\Office\XLStart (as you suggested). Are you saying I should change the template directory for Word to C:\Program Files\Microsoft Office 97\Templates? "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D3C2C47.8040603@contextures.com... What version of Excel are you using? What version of Windows? In Excel 97, the personal.xls file should be stored in XLSTART, perhaps with a path similar to: C:\Program Files\Microsoft Office 97\Office\XLSTART Normal.dot should be in a templates folder, e.g.: C:\Program Files\Microsoft Office 97\Templates Other versions would be slightly different, but the two files shouldn't normally be in the same folder. Splash wrote: Thanks, Peo. I've already removed Normal.dot completely, (but whenever I open Word another Normal.dot is created, which also gives the error.) There is no alternative startup location for Excel. Any other ideas? "Peo Sjoblom" <terre08@mvps.org wrote in message news:OPqw24PMCHA.1352@tkmsftngp11... Do a search for normal.dot, then remove it from anything associated with excel, also check if you have an alternative startup location under toolsoptionsgeneral -- Regards, Peo Sjoblom "Splash" <zsplash@zsplash.com wrote in message news:ujm9ouptkk424b@corp.supernews.com... Whenever I open Excel, I get the following error message: "Normal.dot: file format is not valid." I am doing nothing with Word. It appears that Excel is trying to open my default Word template. I do have both Personal.xls and Normal.dot in the same startup directory. Even if I remove the Normal.dot, I get the same error message on opening Excel. . Any ideas, guys? -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2878 | Or, you can get rid of all the Google stuff, for a shorter, direct link to the article: /default.aspx?scid=kb;[LN];Q171217 Laura Wilde wrote: Opps...darn wrapping link...try this link: /?W25B42351 "Laura Wilde" <laura@top-brands.com wrote in message news:ujKJ8TcMCHA.2372@tkmsftngp11... Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2880 | But that would be too simple, a lot less complicated, and far too easy for others understand... :) "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D3C7BDE.2060704@contextures.com... Or, you can get rid of all the Google stuff, for a shorter, direct link to the article: /default.aspx?scid=kb;[LN];Q171217 Laura Wilde wrote: Opps...darn wrapping link...try this link: /?W25B42351 "Laura Wilde" <laura@top-brands.com wrote in message news:ujKJ8TcMCHA.2372@tkmsftngp11... Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2883 | Thank you so much for your quick reply! I checked the link but now I am confused. I never use anything from an extended character set. In fact, I never saved the original file as an Excel Add In. Additionally, the Excel97 machine already has SR-1, which the link says may fix the problem. I am still having issues with this. I hope you are still reading this chain of replies. Again, thank you for your help on this..... Gene -----Original Message----- Gene, Check out this link: /url? sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene . |
| 2884 | Actually, that was the *new, improved* MSKB link, which seems to have broken at the first square bracket. The old style still seems to work, and stays glued together <fingers crossed: /default.aspx?scid=kb;en-us;Q171217 Laura Wilde wrote: But that would be too simple, a lot less complicated, and far too easy for others understand... :) "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D3C7BDE.2060704@contextures.com... Or, you can get rid of all the Google stuff, for a shorter, direct link to the article: /default.aspx?scid=kb;[LN];Q171217 Laura Wilde wrote: Opps...darn wrapping link...try this link: /?W25B42351 "Laura Wilde" <laura@top-brands.com wrote in message news:ujKJ8TcMCHA.2372@tkmsftngp11... Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2885 | Although Andy's code works, you should note that the 'OnDoubleclick' is replaced in Excel 97. To quote from the help file, ... Hidden properties and methods for visible objects are listed in the following table. Most of the hidden properties and methods have been replaced by new functionality in Microsoft Excel 97. These properties and methods are supported only for backward compatibility; for new code, you should use the replacement functionality provided in Microsoft Excel 97. For more information about the changes to the Microsoft Excel 97 object model, see one of the following topics: OnDoubleClick is one of these, replaced by the worksheet BeforeDoubleClick event. This is invoked by adding the code to that event in the worksheet code module (right-click on the tab name, and select View Code), selecting Worksheet in the Object drop-down, and BeforeDoubleClick in the procedure drop-down. Test Target for your certain cell,and then activate the other cell. HTH -- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Andy Wiggins" <ngroups@bygsoftware.com wrote in message news:84__8.2062$tg4.112020@newsfep1-win.server.ntli.net... This file might be a help: /examples/dubclick.xls It's in the "Worksheet with VBA" section on page: /examples/examples.htm Demonstrates how to setup and use VBA's "OnDoubleClick". With a little adaptation it should suit your purpose. Regards Andy Wiggins FCCA www.BygSoftware.com Home of "Byg Tools for VBA" and "The Excel Auditor" "Michael Horwith" <mhorwith1@mindspring.com wrote in message news:ahhpu6$hl5$1@slb5.atl.mindspring.net... Can I make excel jump to a particular cell when a certain cell is doubleclicked? |
| 2887 | Sometimes I just crack myself up. I double checked the module names and the ones that it is choking on are ones that have an underscore in the name. I didn't think underscores were considered extended characters. Well if you can't laugh at yourself, who can you laugh at. Obscure problems are a headache to solve. That is why I REALLY REALLY REALLY apprciate your help on this problem. Gene -----Original Message----- Thank you so much for your quick reply! I checked the link but now I am confused. I never use anything from an extended character set. In fact, I never saved the original file as an Excel Add In. Additionally, the Excel97 machine already has SR-1, which the link says may fix the problem. I am still having issues with this. I hope you are still reading this chain of replies. Again, thank you for your help on this..... Gene -----Original Message----- Gene, Check out this link: /url? sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene . . |
| 2893 | Glad it's fixed, but I've used underscore in a lot of my module names since xl97. They've never (cross fingers here) given me trouble. (Well, the code does, but not the module names!) FYI only. Gene LaForest wrote: Sometimes I just crack myself up. I double checked the module names and the ones that it is choking on are ones that have an underscore in the name. I didn't think underscores were considered extended characters. Well if you can't laugh at yourself, who can you laugh at. Obscure problems are a headache to solve. That is why I REALLY REALLY REALLY apprciate your help on this problem. Gene -----Original Message----- Thank you so much for your quick reply! I checked the link but now I am confused. I never use anything from an extended character set. In fact, I never saved the original file as an Excel Add In. Additionally, the Excel97 machine already has SR-1, which the link says may fix the problem. I am still having issues with this. I hope you are still reading this chain of replies. Again, thank you for your help on this..... Gene -----Original Message----- Gene, Check out this link: /url? sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene . . -- Dave Peterson ec35720@msn.com |
| 2926 | "xoom7" <xoom7@btinternet.com wrote: The columns in my work sheet sometimes appear as a number as opposed to the normal letter. I have tried to find the solution in help but am unable to resolve. In Excel 97: ToolsOptionsGeneraldeselect "R1C1 reference style" -- Greg phobos@quik.com /phobos |
| 2927 | I'm curious why Book 1 and Book 2 open when starting a new Excel 97 file using "New Office Document". Is this a Win98SE thing? This did not occur with my earlier version of Win98. I recently installed SR2 and this did not affect it. I could not see anything in Options that does this. |
| 2928 | I am trying to build an excel spreadsheet at work which imports the power price from our power pool website . The machine I am using has Excel 2000 on it .If I try to get the data onto the screen using the web query function , all I get is the Header and the next line says"the report is downloading " and that is it . When I save the worksheet and try it on another machine using Excel 97 , the header and the table with the pool price shows up just fine .It appears as if Excel 2000 is not polling the website long enough in order to get the information . Is there a setting where a person set the amount of time the web query runs for when it refreshes the Data . I have attached the power pool website address and a copy of my worksheet with the web query on it . If anyone can figure this out . I would greatly appreciate it . Thank you . /Market/Reports/CSMPriceReportServlet begin 666 Power pool test.xls MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````! M````&0``````````$ ``_O___P````#^____`````!@```#_____________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M______________________\)"! ```8%`*\8S0=)0 ``!@$``.$``@"P!,$` M`@```.(```!<`' `"@``5V%Y;F4@5W5L9B @(" @(" @(" @(" @(" @(" @ M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @ M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @($(``@"P!&$!`@`` M`, !```]`08``0`"``,`G `"``X`&0`"````$@`"````$P`"````KP$"```` MO $"````/0`2`&@!2P!,+(L:. ```````0!8`D ``@```(T``@```"(``@`` M``X``@`!`+<!`@```-H``@```#$`&@#(````_W^0`0````````4!00!R`&D` M80!L`#$`&@#(````_W^0`0````````4!00!R`&D`80!L`#$`&@#(````_W^0 M`0````````4!00!R`&D`80!L`#$`&@#(````_W^0`0````````4!00!R`&D` M80!L`#$`&@#(``0`# "0`0```0````4!00!R`&D`80!L`!X$' `%`!<``"(D M(B,L(R,P7RD[7"@B)"(C+",C,%PI'@0A``8`' ``(B0B(RPC(S!?*3M;4F5D M75PH(B0B(RPC(S!<*1X$(@`'`!T``"(D(B,L(R,P+C P7RD[7"@B)"(C+",C M,"XP,%PI'@0G``@`(@``(B0B(RPC(S N,#!?*3M;4F5D75PH(B0B(RPC(S N M,#!<*1X$-P`J`#(``%\H(B0B*B C+",C,%\I.U\H(B0B*B!<*",L(R,P7"D[ M7R@B)"(J("(M(E\I.U\H0%\I'@0N`"D`*0``7R@J(",L(R,P7RD[7R@J(%PH M(RPC(S!<*3M?*"H@(BTB7RD[7RA 7RD!#\`+ `Z``!?*"(D(BH@(RPC(S N M,#!?*3M?*"(D(BH@7"@C+",C,"XP,%PI.U\H(B0B*B B+2(_/U\I.U\H0%\I M'@0V`"L`,0``7R@J(",L(R,P+C P7RD[7R@J(%PH(RPC(S N,#!<*3M?*"H@ M(BTB/S]?*3M?*$!?*1X$%0"D`! ``")997,B.R)997,B.R).;R(!!H`I0`5 M```B5')U92([(E1R=64B.R)&86QS92(!!0`I@`/```B3VXB.R)/;B([(D]F M9B+@`!0``````/7_( ``````````````P"#@`!0``0```/7_( ``] `````` M````P"#@`!0``0```/7_( ``] ``````````P"#@`!0``@```/7_( ``] `` M````````P"#@`!0``@```/7_( ``] ``````````P"#@`!0``````/7_( `` M] ``````````P"#@`!0``````/7_( ``] ``````````P"#@`!0``````/7_ M( ``] ``````````P"#@`!0``````/7_( ``] ``````````P"#@`!0````` M`/7_( ``] ``````````P"#@`!0``````/7_( ``] ``````````P"#@`!0` M`````/7_( ``] ``````````P"#@`!0``````/7_( ``] ``````````P"#@ M`!0``````/7_( ``] ``````````P"#@`!0``````/7_( ``] `````````` MP"#@`!0```````$`( ``````````````P"#@`!0``0`K`/7_( ``^ `````` M````P"#@`!0``0`I`/7_( ``^ ``````````P"#@`!0``0`L`/7_( ``^ `` M````````P"#@`!0``0`J`/7_( ``^ ``````````P"#@`!0`!0```/3_```` M] ``````````P"#@`!0``0`)`/7_( ``^ ``````````P"#@`!0````4``$` M( ``! ``````````P"#@`!0`!0```$$!( ``````````````P""3`@0`$( # M_Y,"! `1@ ;_DP($`!* !/^3`@0`$X '_Y,"! `4@ C_DP($``" `/^3`@0` M%8 %_V !`@```(4`#@!@!P`````&`%-H965T,84`#@!O# `````&`%-H965T M,H4`#@!V#0`````&`%-H965T,XP`! `!``$`K@$$``,``007``@``0`````` M```8`"\`````%0L````!````````0U--4')I8V5297!O<G1397)V;&5T.P`` M```'`````P#!`0@`P0$``&!I`0#\`+X`"0````D````5``!37-T96T@36%R M9VEN86P@4')I8V4)``!$871E("A(12D$``!4:6UE"0``4')I8V4@*"0I"P`` M5F]L=6UE("A-5RD-```P-B\R-"\R,# Q(#(R#0``,#8O,C0O,C P,2 R,0T` M`# V+S(T+S(P,#$@,C ^``!0<F]J96-T960@4&]O;"!0<FEC92!F;W(@2&]U M<B!%;F1I;F<@,C(@:7,@)#4R+C$Y(&%S(&]F(#(Q.C(P+O\`$@`(`) &```, M````!0<``($````*````"0@0```&$ "O&,T'24 ```8!```+`A0````````` M```.````<@D``$H+```-``(``0`,``(`9 `/``(``0`1``(````0``@`_*GQ MTDUB4#]?``(``0`J``(````K``(```""``(``0" ``@````````````E`@0` M``#_`($``@#!!!0````5````@P`"````A `"````30!2`0``10!0`%,`3P!. M`" `4P!T`'D`; !U`',`( !#`$\`3 !/`%(`( `X`# `, `````````````` M```````````````$4!#4`'P`#XF !P$``0#J"F\(9 `!``<`: $"``$`: $! M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````# M`0```P````$````P`0````````````#H%_ ``````(`! ````$``@````0$ M````````````````! %%4%-/3B!3='EL=7,@0T],3U(@.# P```````````` M`$Q05#$Z```````````````````````````````````````````````!```` M``````$``0``````H0`B``$`9 `!``$``0`"``````````````#@/P`````` M`. _`0!5``(`" !]``P``````+8U#P`&``(`?0`,``$``0"2!0\``@`"`'T` M# `"``(```@/``(``@!]``P``P`#`&T,#P`&``(```(.```````.```````$ M````" (0```````$`/\````````!#P`(`A ``@````0`_P````````$/``@" M$ `$````! #_`````````0\`" (0``4````$`/\````````!#P`(`A `!@`` M``0`_P````````$/``@"$ `'````! #_`````````0\`" (0``T````$`/\` M```````!#P#]``H```````\``````/T`"@`"````#P`(````_0`*``0````/ M``$```#]``H`! `!``\``@```/T`"@`$``(`#P`#````_0`*``0``P`/``0` M``#]``H`!0````\`!0```+T`& `%``$`%@```.P_#P`!8[1 #P```#1 `P#] M``H`!@````\`!@````,"#@`&``$`%@"KJJJJJJKJ/[T`$@`&``(`#P`!8[1 M#P```#1 `P#]``H`!P````\`!P````,"#@`'``$`%@!55555557I/[T`$@`' M``(`#P`!8[1 #P```#1 `P`!`@8`#0```!<`UP`2`( !``!X``X`#@`X`"H` M-@`V`% `" `(`````````#X"$@"V!@````! ```````````````=``\``P`` M``````$`````````K0$D`$D#$ `2```````5``!#4TU0<FEC95)E<&]R=%-E M<G9L971/`-P`# !$`0```0````````#-`$(`/P``:'1T<#HO+W=W=RYP;W=E M<G!O;VPN86(N8V$O36%R:V5T+U)E<&]R=',O0U--4')I8V5297!O<G1397)V M;&5T`@@J``((`````````P``````$ `5``!#4TU0<FEC95)E<&]R=%-E<G9L M971O<@,(' `#" ``! ```",``````````````````0`!````[P`&````-P`` M``H````)"! ```80`*\8S0=)0 ``!@$```L"$ `````````````````G#0`` M#0`"``$`# `"`&0`#P`"``$`$0`"````$ `(`/RI\=)-8E _7P`"``$`*@`" M````*P`"````@@`"``$`@ `(````````````)0($````_P"!``(`P004```` M%0```(,``@```(0``@```*$`(@```/\``0`!``$`! ``````````````X#\` M``````#@/W1350`"``@```(.````````````````````/@(2`+8``````$ ` M`````````````!T`#P`#`````````0````````#O``8````W````"@````D( M$ ``!A `KQC-!TE ```&`0``"P(0`````````````````"X.```-``(``0`, M``(`9 `/``(``0`1``(````0``@`_*GQTDUB4#]?``(``0`J``(````K``(` M``""``(``0" ``@````````````E`@0```#_`($``@#!!!0````5````@P`" M````A `"````H0`B````_P`!``$``0`$``````````````#@/P```````. _ M=%-5``(`" ```@X````````````````````^`A(`M@``````0 `````````` M````'0`/``,````````!`````````.\`!@```#<````*```````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````_O\```0*`@```````````````````````0`` M`."%G_+Y3V@0JY$(`"LGL]DP````J ````<````!````0 ````0```!(```` M" ```%P````2````< ````P```"(````#0```)0````3````H ````(```#D M! ``'@````L```!787EN92!7=6QF```````"P```%=A6YE(%=U;&8``!X` M```0````36EC<F]S;V9T($5X8V5L`$ `````%A*.TOK `4 ```" ?JO4)?W M`0,````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````/[_```$"@(```````````````````````$` M```"U<W5G"X;$).7" `K+/FN, ```-@````)`````0```% ````/````6 `` M`!<```!D````"P```&P````0````= ```!,```!\````%@```(0````-```` MC ````P```"U`````@```.0$````````0``````,P`#````H H)``L````` M````"P`````````+``````````L`````````'A ```,````'````4VAE970Q M``<```!3:&5E=#(`!P```%-H965T,P`,$ ```@```!X````+````5V]R:W-H M965T<P`#`````P`````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````!`````@````,````$````!0````8````' M````_O___PD````*````"P````P````-````#@````\```#^____$0```!(` M```3````% ```!4````6````%P```/[____]_____O__________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M_________________________________________________U(`;P!O`'0` M( !%`&X`= !R`'D````````````````````````````````````````````` M```````````````6``4!__________\"````( @"``````# ````````1@`` M`````````````,!EA)GS,<(!_O___P``````````5P!O`'(`:P!B`&\`;P!K M```````````````````````````````````````````````````````````` M`````!(``@'_______________\````````````````````````````````` M`````````````````````! ````````%`%,`=0!M`&T`80!R`'D`20!N`&8` M;P!R`&T`80!T`&D`;P!N````````````````````````````````````* `" M`0$````#````_____P`````````````````````````````````````````` M``````@`````$ ````````4`1 !O`&,`=0!M`&4`;@!T`%,`=0!M`&T`80!R M`'D`20!N`&8`;P!R`&T`80!T`&D`;P!N```````````````X``(!________ M________````````````````````````````````````````````````$ `` )```0```````` ` end |
| 2933 | Try amazon.com Jerry Mikael Wallen wrote: Hi Group, Does anyone know if the book Excel 97 SDK (I don´t have the correct title but it was published at MS Press) is still available and if not where I can find similar information? TIA, Mikael W |
| 2944 | Hi Robert Try Start/Run and enter excel.exe /regserver (you may need to browse to find excel.exe before adding the /regserver bit. Regards BrianB -------------------------------------------------------- "Robert" <rtbeard@attbi.com wrote in message news:<1a8f401c231f0$4cec1e90$b1e62ecf@tkmsftngxa04... I'm curious why Book 1 and Book 2 open when starting a new Excel 97 file using "New Office Document". Is this a Win98SE thing? This did not occur with my earlier version of Win98. I recently installed SR2 and this did not affect it. I could not see anything in Options that does this. |
| 2984 | On Wed, 24 Jul 2002 00:12:31 -0700, "Richard Axam" <raxam@thiess-services.com.au wrote: Hello All, I'm trying to customise Excel so that when I print, the footer will show the directory path of the file I'm in. The footer can dispaly the filename, date, time etc, but not, it seems, the directory path. There is a worksheet function called INFO("DIRECTORY"). This will return the directory path. However I don't know how to this function into the footer. Any ideas? It's always a good idea to mention which version of Excel you're using. If you're referring to Excel 97, I believe that the only way you can get it in there is to either manually type it (not much good if you move the file), or have the workbook's BeforePrint event procedure do it for you like so: Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet.PageSetup .LeftFooter = ThisWorkbook.Path & "&F" End With End Sub In XP (and possibly 2000, I'm not sure) there is the option to set the path as one of the fields --------------------------------------------------------- Hank Scorpio apolloXVIII@ozemail.com.au Change XVIII to 18 for real address. * Please keep all replies in this Newsgroup. Thanks! * |
| 3002 | I sent an Excel file to a friend with some VBA I wrote in Excel 5c. He's using Excel 97. ( I tested on my Excel 97 before sending) He emailed me back... ----------------------------(email clip start)---------------------------------------------------- I could not run, kept getting error messages, both with enable macros and disable macros, error messages are; 1. This program has performed an illegal operation and will be shut down. If problem persists, contact the program vendor. 2. Could not register the Visual Basic Environment. Please Run Setup. 3. An error occured initializing the VBA Librarys (1157) Details are EXCEL caused an invalid page fault in module <unknown at 0000:4d001940. Registers: EAX=00000002 CS=017f EIP=4d001940 EFLGS=00010246 EBX=00000000 SS=0187 ESP=00629f94 EBP=00629fa4 ECX=d27acc60 DS=0187 ESI=6509f094 FS=11c7 EDX=c00301b0 ES=0187 EDI=650a00c0 GS=0000 Bytes at CS:EIP: Feels like old times, Ha ha ha. I'm running Excel 97 SR-2. ----------------------------(email clip end)---------------------------------------------------- I emailed him a version saved as Excel 5/97 for him to try, but.... ----------------------------(email clip start)---------------------------------------------------- Same problem, This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor. EXCEL caused an invalid page fault in module <unknown at 0000:4d001940. Registers: EAX=00000002 CS=017f EIP=4d001940 EFLGS=00010246 EBX=00000000 SS=0187 ESP=00629d94 EBP=00629da4 ECX=d27739d0 DS=0187 ESI=6509f094 FS=0f27 EDX=c00301b0 ES=0187 EDI=650a00c0 GS=0000 Bytes at CS:EIP: Could not register the Visual Basic Environment. Please Run Setup. An error occured initializing the VBA Libraries (1157) This leaves me in Excel, Under "Tools/Visual Basic Editor", I get the same errors. Under "Visual Basic/Tools", my only option is Source Safe. ----------------------------(email clip end)---------------------------------------------------- The file uses only the add-ins that came with Excel. It needs both the ToolPaks to run right. Other than that, my only guess (and you know how this is) is that his Excel is missing some files. I am using Win98se. I believe he is too, if that makes any difference. Anyone know what could cause this and how I can fix it? -Ray |
| 3106 | A couple of queries, can anyone help ? I have just upgraded to Excel 2002. In a spreadsheet written in Excel 97 I had cells with data validation (from list) criteria. These cells were locked and when the sheet was protected, the user could still change the cell selection from the list. In Excel 2002, the validation still works but the cells that were locked cannot now be changed - the normal "the cell or chart...is protected" message comes up. Am I doing something wrong or is a new feature of 2002 ? I have checked the file on another PC still on Excel 97 and it still works as before. And.. as a general point, can anyone advise where I can get a useful summary of the new features/key changes in Excel 2002 ? Many thanks |
| 3132 | You could unprotect the sheet, select the cells with validation, do formatcellsprotection, uncheck locked for the validation cells, then protect the sheet again. -- Regards, Peo Sjoblom "Ian" <badgerzz1@yahoo.co.uk wrote in message news:0f0301c233c0$76194460$3bef2ecf@TKMSFTNGXA10... A couple of queries, can anyone help ? I have just upgraded to Excel 2002. In a spreadsheet written in Excel 97 I had cells with data validation (from list) criteria. These cells were locked and when the sheet was protected, the user could still change the cell selection from the list. In Excel 2002, the validation still works but the cells that were locked cannot now be changed - the normal "the cell or chart...is protected" message comes up. Am I doing something wrong or is a new feature of 2002 ? I have checked the file on another PC still on Excel 97 and it still works as before. And.. as a general point, can anyone advise where I can get a useful summary of the new features/key changes in Excel 2002 ? Many thanks |
| 3142 | Hi all I have a workbook which has been shared, however I am getting lots of "unexpected locks" All the clients are Excel 97 and they have full control over the file. Once I get an unexpected lock message that user then cannot update changes to the sheet, they are saved as another file. Any ideas? Thanks _____________________ Stuart Pittwood Information Technology Amery-Parkes Solicitors |
| 3205 | Hello, our office is running excel on a network. We share data files on the network drive; and excel is installed on each workstation. We have a couple of different versions of excel. One one workstation we have Excel 2000, on the rest is Excel 97. We are getting the error "File Format is not Valid" on certain files. I have looked through the MS Knowledge database, and have not found any solutions. |
| 3209 | I have developed a spreadsheet in Excel 97 on a computer I no longer have access to and I believe it has commercial application. I want to buy a licensed copy of Excel but am concerned that if I buy Excel 2002 and send the file to someone who only has Excel 97 or 2000, then the file may lose some functionality. Can I buy 2002 and save the file in 97 format without causing a problem in backwards compatibility? Am I better to buy Excel 97 so that my version is always behind or level with that of any potential clients? If I am better off doing this, how can I buy a copy of 97? |
| 3223 | Dear John Re the last question, I recently bought a legal new copy of Office 97 Pro in a small computer shop for UK£70. That's a lot of processing power for a small outlay. It's also available from time-to-time via Auction sites like Ebay (but it must have the original packaging and product id). For obvious reasons Microsoft frowns on people trying to buy cheaper, earlier versions. Nobody has yet given me any persuasive reason to upgrade. (at work, there is a mixture of 97 and 2000, and no problems with compatibility). Cheers Andrew "John percy" <linkagesolutions@bigpond.com.au wrote in message news:134f01c23453$532e5330$9be62ecf@tkmsftngxa03... I have developed a spreadsheet in Excel 97 on a computer I no longer have access to and I believe it has commercial application. I want to buy a licensed copy of Excel but am concerned that if I buy Excel 2002 and send the file to someone who only has Excel 97 or 2000, then the file may lose some functionality. Can I buy 2002 and save the file in 97 format without causing a problem in backwards compatibility? Am I better to buy Excel 97 so that my version is always behind or level with that of any potential clients? If I am better off doing this, how can I buy a copy of 97? |
| 3233 | Hi John I think the warning message you get when saving to an older version is overstated. Excel 97 is a comprehensive package and the improvements you may lose in later versions don't have much practical effect eg can't have the filename & path in the footer. I work in a company with 4000+ users and we upgraded from 95 to 97 to 2000 within 6 months with no instances of users losing functionality as it seems you have to be a professional developer to use the functions affected. You can also "Save As" Microsoft Excel Workbook rather than a specific version to avoid down saving to a specific older version. Tim Tim -----Original Message----- I have developed a spreadsheet in Excel 97 on a computer I no longer have access to and I believe it has commercial application. I want to buy a licensed copy of Excel but am concerned that if I buy Excel 2002 and send the file to someone who only has Excel 97 or 2000, then the file may lose some functionality. Can I buy 2002 and save the file in 97 format without causing a problem in backwards compatibility? Am I better to buy Excel 97 so that my version is always behind or level with that of any potential clients? If I am better off doing this, how can I buy a copy of 97? . |
| 3235 | Array-enter: =SUM(A1:A7)+SUM(IF((LEN(A1:A7)1),LEFT(A1:A7)+0)) Aladin "David" <shoes2@qc.aira wrote in message news:115a01c2340f$e9e9c280$9be62ecf@tkmsftngxa03... I need to know wether their is a way to omit certain characters from sum equations in Excel 97. For example, if there was a cell included in a sum reading "1x", i would want it to disregard only the x and count the 1, rather than disregarding the whole cell. thank you |
| 3257 | I don't have 97 installed (it's in Swedish and I don't want to mix different language versions), I usually just click in one cell somewhere, then press F5.. -- Regards, Peo Sjoblom "Dave Peterson" <ec35720@msn.com wrote in message news:3D40AF7F.ED65D6E@msn.com... Hmmm. I like to press ctrl-A just to make sure there isn't a current multicell selection. Sometimes I forget what I have selected! (Do you still have xl97? Did/does it work that way???) Peo Sjoblom wrote: You don't even have to press ctrl+A, just press F5 or editgo to, it will select those cells regardless. And I can only agree with the last point regarding Dave's memory <g -- Regards, Peo Sjoblom "Dave Peterson" <ec35720@msn.com wrote in message news:3D406CA5.80C9DF08@msn.com... And if you want to get all the cells with validation in one shot, you can do: ctrl-A (to select the whole sheet) Edit|goto|special click on Data Validation (bottom right corner) Then Cells|format|protection tab stuff that Peo describes. (But I don't recall that xl97 worked this way. Are you sure???) ==== As for the what's new in xl2002, notice the little combobox on the far right of the menubar. Type "what's new" in that box and hit enter. Then click on the first option. You'll see a pretty substantial list. ===== Not to harp too much, but are you sure that you had data|validation dropdowns with xl97??? (I'm getting older and my memory ain't what it used to be....) Peo Sjoblom wrote: You could unprotect the sheet, select the cells with validation, do formatcellsprotection, uncheck locked for the validation cells, then protect the sheet again. -- Regards, Peo Sjoblom "Ian" <badgerzz1@yahoo.co.uk wrote in message news:0f0301c233c0$76194460$3bef2ecf@TKMSFTNGXA10... A couple of queries, can anyone help ? I have just upgraded to Excel 2002. In a spreadsheet written in Excel 97 I had cells with data validation (from list) criteria. These cells were locked and when the sheet was protected, the user could still change the cell selection from the list. In Excel 2002, the validation still works but the cells that were locked cannot now be changed - the normal "the cell or chart...is protected" message comes up. Am I doing something wrong or is a new feature of 2002 ? I have checked the file on another PC still on Excel 97 and it still works as before. And.. as a general point, can anyone advise where I can get a useful summary of the new features/key changes in Excel 2002 ? Many thanks -- Dave Peterson ec35720@msn.com -- Dave Peterson ec35720@msn.com |
| 3479 | Most people won't open attachments anyway. The threat of malicious code is too great. Is it possible that there's a macro that runs that hides worksheets. I think you'll have to unshare the workbook before you can go look at the code, though. ====== Silly question: You are sure that you're just not scrolled to far right/left on the worksheet tabs??? rebecca wrote: Can not attach file due to confidentiality restraints, but problem is that our shared excel 97 file sometimes is missing entire worksheets that disappear and reappear at random. -- Dave Peterson ec35720@msn.com |
| 3580 | Many people asked me to make the add-in directly available due to some form processing glitch on the yahoo site. Please find the direct link below: ------------------------------------------------------------ I originally wrote this Excel add-in to address some of the pet peeves of MS Excel, like error handling within a cell. This add-in is convenient to use as it adds cell-level functionality using the right click of the mouse. It also has undo capabilities! Please feel free to use it and provide feedback! If my time permits, I would like to add more features based on user feedback. ALLRIGHT!- A Right-Click Menu Utility for Microsoft Excel 97-2000 Features - Adds powerful functionality where you need them at the cell or worksheet tab level - SMART formatting - Text formatting only affects the text, no overwriting of formulas - Add Error Trap feature enables the user to add IF ISNA/ISBLANK or ISERROR conditions to cell formulas - No annoying questions - Are you sure? - but UNDO is available - Fast! To register: /gygulyas/index-page3.html To download directly: /gygulyas/index-page4.html I would appreciate any feedback. Gyula |
| 3588 | I posted the message below about a month ago. I really didn't get a satisfactory answer, though the Works to Excel converter utility referenced in one reply worked, but was a "crippled-ware" demo and wasn't worth the $50 for teh two files I needed to convert. I finally did a MS Knowledge Base search and found Q109246 which includes the following: "In the versions of Microsoft Excel listed at the beginning of this article (includes Excel 95 ver. 7.0, Excel 97 and others), you cannot open files that have been saved in the Microsoft Works 3.0 or 4.0 format." the workaround is to reopen the Works file in its own environment and save in a compatible format including Works 2.0 or Works for DOS, Excel 4.0 or 5.0 SS, or Lotus 1-2-3 formats. This really didn't help since I don't have Works available on a computer I have access to. I'm posting this just for the record, in case it might be of use to others. Optiker "Optiker" <optiker.crb@pnl.gov wrote in message news:#7UfyQeHCHA.1596@tkmsftngp13... Using MS Office 97 Excel, I'm trying to open what I believe is a MS Works file with an extension of *.wks. Any suggestions? Is there a supplemntal filter for this? Thanks!! Optiker |
| 3611 | After writing this, I figured I should add this to the beginning: Do all this stuff against a copy of the workbook. (Just in case you break it bad!) ======= Try clicking on Tools|Macro|Visual Basic Editor... (Or Alt-F11). You should see another screen. This is where the macros live. Now hit ctrl-R to see the project explorer. Usually it will should show up on the left hand side (and it might have been there already). Now, look at that panel. You should see a list of open workbooks that look like: VBAProject (Book1.xls) The first part is the name of the project, the name is parens is the name of your workbook. There is a box in front of this item. It works just like Windows explorer. If the box contains a minus (-), then the contents of that level are shown. If the box contains a plus (+), then that means the contents are condensed. Expand every box in front of every item in the subitems under your workbook's project. If you get prompted for a password, then the project is protected from prying eyes. You'll have to go back to the developer and yell. But if it expands, you should see: Microsoft Excel Objects This will have one entry for each sheet (worksheet/chartsheet) in the workbook. And one entry for the workbook itself. If you see one of these for sheets that have disappeared, then you know that the worksheets are still there. Click on one of the items that represents a worksheet that has disappeared. Now click F4. (F4 shows the properties for the thing you have selected.) You should see another panel under the project explorer. Look down that list of properties until you get to Visible. Does it say "-1-xlsheetvisible" or "0 - xlsheethidden" or "2-xlsheetveryhidden"? The last two options mean that you shouldn't see the sheet. The first one (xlsheetvisible) means that you should be able to see the worksheet. ======== If the worksheet is hidden (either veryhidden or just regular hidden), then you probably have a macro working for (against??) you. === To find the macro, go back to the project explorer and make sure that you have all the stuff expanded under your workbook's project. Do you see anything named "Modules" or "Forms"? If yes, then there can be macros inside them. (Same thing with "class modules", too. If you don't see any of these, you have to check under each of the worksheet objects under "microsoft excel objects" and also ThisWorkbook, too. When you double click on one of the sheets (or thisworkbook), you should see another window open on the right hand side (usually, again). Is there any typing there? If you see something that says: private sub ....... 'bunch of greek stuff here end sub or any typing at all, you have macros. The next question is: Do they belong? I'd go back to the original author(s) and ask what they were doing and explain why they bother you. (If you're the original author, then you can probably(?) delete all of these modules/forms, and remove all the code under the sheets/thisworkbook. =========== If you don't see any macros after this excursion into no-man's land, then I'm at a loss and don't know what to recommend. One tip: If you right click on the VCR controls to the left of the worksheet tabs in Excel, you'll see a list of worksheets. If the "disappeared" one appears here, it's not really disappeared. Click on that worksheet's name and see if pops up in front of you. If not, maybe Windows|Arrange|Tiled will show it to you and you can resize manually. ======== ps. You can close the VBE window just like any other window (giant X in top right corner) or just alt-F11 to toggle between Excel and VBE. ======== Non-xl question: Do you work at the Villa Park dealership? I lived in VP about a block and a half from there about 10 years ago. Company relocated and so did I. Martin Sotak wrote: Yes, I am sure. We are using the middle of a new worksheet. I do not know if there is a macros running beind the worksheet, I havent used macros personally. Marty -----Original Message----- Most people won't open attachments anyway. The threat of malicious code is too great. Is it possible that there's a macro that runs that hides worksheets. I think you'll have to unshare the workbook before you can go look at the code, though. ====== Silly question: You are sure that you're just not scrolled to far right/left on the worksheet tabs??? rebecca wrote: Can not attach file due to confidentiality restraints, but problem is that our shared excel 97 file sometimes is missing entire worksheets that disappear and reappear at random. -- Dave Peterson ec35720@msn.com . -- Dave Peterson ec35720@msn.com |
| 3641 | If they're small files, maybe you can copy them to a floppy and take them to your local library (or friend). Works is on (almost??) every new pc I've seen. (Or maybe your local computer store wouldn't mind if you converted a couple of files. Especially if you're buying a bunch of other stuff!) Optiker wrote: I posted the message below about a month ago. I really didn't get a satisfactory answer, though the Works to Excel converter utility referenced in one reply worked, but was a "crippled-ware" demo and wasn't worth the $50 for teh two files I needed to convert. I finally did a MS Knowledge Base search and found Q109246 which includes the following: "In the versions of Microsoft Excel listed at the beginning of this article (includes Excel 95 ver. 7.0, Excel 97 and others), you cannot open files that have been saved in the Microsoft Works 3.0 or 4.0 format." the workaround is to reopen the Works file in its own environment and save in a compatible format including Works 2.0 or Works for DOS, Excel 4.0 or 5.0 SS, or Lotus 1-2-3 formats. This really didn't help since I don't have Works available on a computer I have access to. I'm posting this just for the record, in case it might be of use to others. Optiker "Optiker" <optiker.crb@pnl.gov wrote in message news:#7UfyQeHCHA.1596@tkmsftngp13... Using MS Office 97 Excel, I'm trying to open what I believe is a MS Works file with an extension of *.wks. Any suggestions? Is there a supplemntal filter for this? Thanks!! Optiker -- Dave Peterson ec35720@msn.com |
| 3738 | I have a business need to run Excel 97 and Excel 2000 on the same machine. First, is this possible? Second, what are the problems? |
| 3740 | Why do you need to run both? Tim C "Joe Smyth" <wjsmyth60@msn.com wrote in message news:026601c238e3$9ae73310$9be62ecf@tkmsftngxa03... I have a business need to run Excel 97 and Excel 2000 on the same machine. First, is this possible? Second, what are the problems? |
| 3744 | On Wed, 31 Jul 2002 15:42:52 -0700, "Joe Smyth" <wjsmyth60@msn.com wrote: I have a business need to run Excel 97 and Excel 2000 on the same machine. First, is this possible? Second, what are the problems? It IS possible, but not recommended. You need to install from oldest to newest. This article is very useful: /default.aspx?scid=kb;[LN];Q218861 --------------------------------------------------------- Hank Scorpio apolloXVIII@ozemail.com.au Change XVIII to 18 for real address. * Please keep all replies in this Newsgroup. Thanks! * |
| 3745 | Lots of people who post to these ng's have multiple versions of excel loaded on their pcs. (I don't.) But a couple of responses that I've seen are: Load the earliest version first (xl97 then xl2k) Use different folders for each version (different partitions if possible?) Answer no to the question about removing the previous version (Even I understand that last point!) Joe Smyth wrote: I have a business need to run Excel 97 and Excel 2000 on the same machine. First, is this possible? Second, what are the problems? -- Dave Peterson ec35720@msn.com |
| 3838 | I have seen a couple of similar posts but none seem quite the same as my user is having. Using Excel 97 running over Citrix Terminal Server (NT4). The user attempts to save their document and it pops up with a dialogue box that says only "Document not saved". No further attempts to save the document will be successful, wether it is saved on another network drive, saved as a different file or anything. The same message pops up every time. However, in the same session of Excel another document can be opened or created and saved fine, but still the one with the original problem will not save. The only way around the problem is to copy and paste each sheet into a new workbook and then you can save that over the original file. Appreciate any help on this. (I've checked the knowledge base too, and while it had a similar problem it wasnt quite the same and couldnt solve my one in any case) |
| 3839 | Hi Greg! Does the file have any code in it? That seems to be kind of a generic error. There are a few different things that you can try: 1. Try copying all of the sheets (one at a time) over to another workbook and renaming them. 2. Restore the file from the last backup, copy the users changes over to the restored file and save. Let us know if you need further assistance. Adria "Greg Sole" <gregory.sole@thcl.co.nz wrote in message news:01ed01c239d5$997f76c0$b1e62ecf@tkmsftngxa04... I have seen a couple of similar posts but none seem quite the same as my user is having. Using Excel 97 running over Citrix Terminal Server (NT4). The user attempts to save their document and it pops up with a dialogue box that says only "Document not saved". No further attempts to save the document will be successful, wether it is saved on another network drive, saved as a different file or anything. The same message pops up every time. However, in the same session of Excel another document can be opened or created and saved fine, but still the one with the original problem will not save. The only way around the problem is to copy and paste each sheet into a new workbook and then you can save that over the original file. Appreciate any help on this. (I've checked the knowledge base too, and while it had a similar problem it wasnt quite the same and couldnt solve my one in any case) |
| 3879 | Hi Greg FWIW I have had this error message when space on the server is becoming limited. Sometimes this precedes a more helpful (?) message "Out of disk Space". This situation is very changeable when server usage is heavy and can be Ok one minute and error prone he next. When this happens files are prone to being corrupted ! Bear in mind that, to confuse matters, Excel saves a temporary file to the server which is deleted on exit. For this reason I habitually work on my C: drive and back up files to the server. It is also a lot faster. Hope this helps. Regards BrianB --------------------------------------- "Greg Sole" <gregory.sole@thcl.co.nz wrote in message news:<01ed01c239d5$997f76c0$b1e62ecf@tkmsftngxa04... I have seen a couple of similar posts but none seem quite the same as my user is having. Using Excel 97 running over Citrix Terminal Server (NT4). The user attempts to save their document and it pops up with a dialogue box that says only "Document not saved". No further attempts to save the document will be successful, wether it is saved on another network drive, saved as a different file or anything. The same message pops up every time. However, in the same session of Excel another document can be opened or created and saved fine, but still the one with the original problem will not save. The only way around the problem is to copy and paste each sheet into a new workbook and then you can save that over the original file. Appreciate any help on this. (I've checked the knowledge base too, and while it had a similar problem it wasnt quite the same and couldnt solve my one in any case) |
| 3932 | Excel 97, I have an existing chart with months along the bottom and £value up the left side. I now want to add a secondary axis on the right hand side (no. of) Excel help says to click the series then Format menu - Data series click axis tab then click secondary axis. My problem is when I click on Format menu.. there is no Data Series to click on !! Any suggestions how I create a secondary axis. Bob |
| 3933 | When you click on one of the columns or lines (don't know what kind of chart you've created), you've selected a data series. Then choose Format, and the first item in the menu should be 'Selected Data Series.' If it says something else, then something else in the chart is currently selected. You can also select objects in the chart by choosing from the dropdown list on the Chart menu. Robert Gillard wrote: Excel 97, I have an existing chart with months along the bottom and £value up the left side. I now want to add a secondary axis on the right hand side (no. of) Excel help says to click the series then Format menu - Data series click axis tab then click secondary axis. My problem is when I click on Format menu.. there is no Data Series to click on !! Any suggestions how I create a secondary axis. Bob -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 3980 | When I installed Excel 97, I chose to install visual basic help. I seem to recall that there was a way to separate the visual basic section of the help from the main help section for Excel. I can't remember it, and I don't want to get in trouble by experimenting with moving help files around. I don't want to completely uninstall visual basic help: I just want to be able to search excel help without what I am looking for being buried in help topics for a long list of VB commands and functions. If I want visual basic help, I can always get it from the VB editor or a simple shortcut to the VB help file. (It is GREAT to be back to usenet, I guess sometimes the good old days CAN be recovered.) Thanks! |
| 3982 | You need to have at least 2 data series in order to implement a 2nd Y axis. Is that the case? On Sat, 03 Aug 2002 12:14:42 GMT, "Robert Gillard" <bob@mystical.demon.co.uk wrote: Excel 97, I have an existing chart with months along the bottom and £value up the left side. I now want to add a secondary axis on the right hand side (no. of) Excel help says to click the series then Format menu - Data series click axis tab then click secondary axis. My problem is when I click on Format menu.. there is no Data Series to click on !! Any suggestions how I create a secondary axis. Bob |
| 3998 | Hi to all. I am new to excel and would like to set up a spreadsheet to use for my work. I would like to keep track of my work hrs and total pay and hrs worked. I am going to use either excel 97 or works 2000. Any help would be great. Thanks in advance for your help Bill |
| 4010 | Hi Bill, Look at /excel/overtime.htm -- Regards, Niek Otten Microsoft MVP - Excel "Bill k" <billrk513@cs.com wrote in message news:aii4vv$o5o$1@nntp-m01.news.aol.com... Hi to all. I am new to excel and would like to set up a spreadsheet to use for my work. I would like to keep track of my work hrs and total pay and hrs worked. I am going to use either excel 97 or works 2000. Any help would be great. Thanks in advance for your help Bill |
| 4040 | A few years ago, I learned about a registry change that would enable live scrolling for Word 97 under Windows 95/98. With this change, a Word document would scroll as I dragged the scroll bar without waiting until I let go of the bar. The registry entry was: [HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Word\Options] "LiveScrolling"="1" Is there an equivalent capability for Excel 97? Note: While I have a wheel mouse at home, my employer does provide them at work. Further, the scrolling I get by dragging the scroll bar is not the same as using the wheel mouse. The former can be much easier to control during fast scrolling than the latter. Also, while using the scroll bar, I see the current row number. -- David E. Ross </~rossde/. Concerned about someone snooping into your E-mail? Use PGP. See my </~rossde/pgp.html |
| 4045 | This is posting 9 of Frequently Asked Questions for the Excel newsgroups microsoft.public.excel.misc, microsoft.public.excel.programming and microsoft.public.excel.worksheet.functions. Topics are: The Excel application and Excel files Worksheet functions and formats Dates and times Macros, VBA functions I didn't find my answer here, now what ? Good resources on the web Collected by Harald Staff, Microsoft Excel MVP. This FAQ can also be found at Debra Dalgleish's website /xlfaqIndex.html -it's worth a bookmark. If you reply to this posting, reply to a single group and quote as little as possible. ************************************************* **** The Excel application and Excel files **** * When I start Excel, why do a million files open up automatically? Menu Tools Options General has an entry for "Startup directory", and all files there will be loaded when Excel starts. Alter or remove this entry. * When I start XL, I get the error message "Compile error in Hidden Module" An add-in with a programming error is bothering you. 1 Tools, Add-ins 2 note which are checked 3 uncheck all (but one) 4 restart XL 5 if no error, check the next one and repeat from step 4 Got the error? uncheck the one you last checked. If no luck, see if there's an .xla file in the startup directory (see previous tip). Scanner software typically place itself there, sometimes with code errors like the one in question. Not an add-in? It will be a hidden workbook then. 1 Try (in Excel) Windows, Unhide and write down which files are listed. 2 Unhide them. 3 Now go to the VBE (press Alt-F11). 4 On the left side there should be the project explorer. 5 Select the first project you unhid 6 From the menu choose Debug, compile 7 No Errors? select the next project listed, repeat 6. * Why do the column headers show numbers instead of letters? How do I change my column headings so they are back to alpha letters instead of numbers ? Tools / Options / General / Settings / R1C1 Reference Style (uncheck) * How can I change the color of the sheet tabs? Excel 10 (XP) is the only version that can color sheet tabs. * I want to lock in my Title Row and keep it there Visible while I scroll down to see the rest of my data. Any ideas? Assuming title row is 1, select A2 then WindowFreeze Panes. * I need more than 256 columns and/or 65536 Rows. Excel has no more. Quattro Pro v9 has 1 million rows and 18278 columns. * I just began to design an intricate spreadsheet and after over an hour got an error message in Excel - which then closed automatically. Unfortunately, I did not save my file. Excel did not automatically recover the file. Is there anything I can do to get it back? No. There should be an Autosave add-in in Tools Addin menu that you now might consider start using. (But then again, you may not want to overwrite an existing file with every little test you do in it, so be careful). Jan Karel Pieterse has an add-in Autosafe.zip downloadable from www.bmsltd.co.uk/mvp. See also 's /dmcritchie/excel/backup.htm for more on backup and recovery. Finally, Excel XP has great backup and recovery tools, so upgrading is a good future solution to those problems. * All of a sudden a number of my Excel 2000 files have become "read-only". Clear out c:\windows\temp directory on the machine that houses the files, reboot. * I have an excel file that I use every day at work. Some time ago, mysteriously, the file began opening two copies of itself every time I double-click the icon. If I close one of the copies, both close. Any changes made to one copy show up in the other. This sounds like you just have two windows open that are displaying the same workbook. You can close the extra window by clicking the lower of the two X buttons in the upper right corner of the screen (don't click the top X button, as that will close Excel). Then save the workbook. * When I type a number; example 44 it becomes 0.44 even if I format the cell without decimals. Goto Tools/Options/Edit and uncheck the fixed decimals checkbox. * When I click on an Excel file to open it, the file opens but an error message is displayed that says a file with that name is already open and that I can not open two files open with the same name. If you are sure it's not really happening -you may have Book1 open and then attempt to open a Book1 from another folder- then try re-register Excel. click startrun and "C:\Program Files\Microsoft Office\Office\Excel.Exe" /regserver (include the quotes) adapt to fit your path. Other things to look at: Tools=Option=General Tab, make sure "Ignore Other Applications" is not checked * Why does Excel say my file has links, when I know it doesn't? Links come in several flavors; linked formulas, defined names (Insert Name Define menu), objects (buttons and stuff) assigned to remote macros, ... You might find the FINDLINK.XLA program useful - you can get it from Stephen Bullen's web site: * Is there a way to allow the use of autofilter on a protected worksheet ? This needs a macro to run first: Sub Protect_keep_filter() With ActiveSheet .EnableAutoFilter = True .Protect DrawingObjects:=True, _ contents:=True, Scenarios:=True, UserInterfaceOnly:=True End With End Sub Note that the .enableautofilter has to be reset each time you open your file. (It's not persistent between closes.) * How many worksheets I can put in a workbook? It is not a limit per se, but of course there is a practical one which depends on the computer resources.. * How many Characters can be placed in a Cell? In Excel 97 and above, you can have up to 32K characters in a worksheet cell, but only the first 1000 or so can be displayed (the exact number depends on your font and display characteristics). * I've lost my password ! Yeah sure. Well, there are passwords and there are passwords. One is to open the file, one other is to unprotect the spreadsheet, still another is to unprotect the workbook and yet another one is to unprotect the macro code. File and VBA passwords can not be cracked by a "normal macro", workbook and worksheet passwords are fairly easy. A search for "excel password" at / will find both commercial and free solutions of varying quality and brutality. * Can anyone advice how to protect an Excel file (and associated code) from un-authorized copying and/or create time limited functionality ? There is no fool-proof method for this, and most solutions limit themselves to require macros enabled on opening. This said, creating your own system is a fun challenge allowing lots of "evil creativity". * When I try to open XL, it freezes and all I can do is reboot * Excel crashes on me regularly, what can I do * EXCEL caused an invalid page fault... * Illegal Operation Error when starting Excel To-Do List: Try opening Excel without any addins or hidden workbooks: Start, Run, "C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation Note you may have to change the path. If your error disappears, there is either an add-in or a (hidden) workbook that is loaded upon XL's start, which bothers you. - Try locating the XLSTART directory, move everything from there. - In XL: Tools, Addins, note the ones checked and uncheck them one at the time, each time restarting XL - In XL, Tools, options, general. Check if a path is entered after "Alternate startup file location". Clear it. Another option is to open XL in Safe mode: "C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe Also, you might try: "C:\Program Files\Microsoft Office\Office\Excel.exe" /Regserver Yet another possible problem is a corruption of your toolbar customisation file. Locate all files with extension .xlb and rename the extension(s) to something like .old .Now try and start XL again. Finally, this is what MS has to say: /default.aspx?scid=kb;en-us;Q280504 **** Worksheet functions and formats **** * How can I protect a formulas from being deleted or changed? Select all cells that users ARE allowed to change. Go menu Format Cells Protection and uncheck Locked. When done, protect the worksheet in menu Tools Protection Protect worksheet. * How can I enter the date into a cell so it doesn't change every day? Press Ctrl ; (that's holding Ctrl down while pressing semicolon.) Ctrl : will enter the time. * I have to enter the Expenses and to select from some criteria. That means, the user can only enter 'DHL', 'FEDEX', 'UPS'. In other word once the user move into the corresponding cell under expenses it will popup a combo box with the above 3 Companies and user will select one. Select the region you want to apply this to, then select menu item Data/Validation. In the Allow dropdown, select List. In the Source textbox, enter "DHL,FEDEX,UPS" (without the quotes) * Is there a way to create a formula that will do this type of function =IF(D25 DOES NOT EQUAL E25 THAN D25 FONT WILL TURN RED) ? Try Format=Conditional Formatting: Select D25. Click on FormatConditional Formatting. Set Condition 1 - Cell Value Is, not equal to, click on E25 on the worksheet. Click on Format, select the Font tab. Under Colour, choose red. OK, OK. * Is there a way to enter a formula that will round a value to the nearest increment of 5? =ROUND(A1/5,0)*5 * or to the nearest quarter ? =ROUND(A1/0.25,0)*0.25 * I am looking for a formula that will look at an adjacent column then find that value in another sheet and return the data from an adjacent column. Try VLOOKUP. =VLOOKUP(A2,Sheet2!A2:B100,2,FALSE) * I want to add the largest/smallest 5 entries in A column. =SUM(LARGE(A:A,{1,2,3,4,5})) * I have data stored in rows and I want to change these rows to columns Select the data, copy it, select where you want it, do editpaste special, check the transpose option, click OK * How do I pick 20 random items from a list of 100 ? Enter the items down A1:A100. In B1:B100 enter formula =RAND(). Sort the list by B column; top 20 rows is your selection. Press F9 for new B numbers and repeat for a new selection. * Is it possible to write a SUMIF worksheet formula to sum visible cells only? If the cells are hidden as a result of AutoFiltering, you can use the SUBTOTAL function, with 9 as the first argument * I can sum all numbers =10 with =SUMIF(A1:A20,"=10") . But how do I enter two criterias so I can sum numbers between 5 and 10 ? That equals sum of all =5 minus sum of all 10: =SUMIF(A1:A20,"=5")-SUMIF(A1:A20,"10") Or you can use this method: =SUMPRODUCT((A1:A20=5)*(A1:A20<=10)*A1:A20) * Using DataSubtotals, I would like to create a table that has just these subtotals, not the hidden detail rows. 1. Once you've applied the Subtotal, collapse the outline so that only the rows you want to copy are visible. 2. Select the cells. 3. Choose EditGo To, click the Special button 4. Select 'Visible Cells Only', click OK 5. Click the Copy button 6. Go to another sheet, and paste * When I use AutoFilter I don't see all the items in the drop down list. Why not? An AutoFilter dropdown list will only show 1000 entries. You could add a new column, and split the list into 2 or three groups, e.g.: =IF(LEFT(C2,1)<"N","A-M","N-Z") Filter on this column first, then by the intended criteria. Another option is to choose Custom from the drop-down list, and type the criteria. * In a cell I have "lastname, firstname". I want to put lastname in one cell and first name in another. Use DataText to columns and specify the comma as a delimiter. * How can I prevent hyperlinks from appearing when I type an email address? You can turn that option off in Excel XP only. All versions: Select the cell and press Ctrl+Z, this will convert the hyperlink back to text. The code below, when run on a selection, will also delete the hyperlinks. Sub delHyperlinks() Dim myCell As Range For Each myCell In Selection myCell.Hyperlinks.Delete Next myCell End Sub * When I import information from my merchant account the field which holds the 16 digit credit card information does not display it properly. Excel only maintains 15 significant digits for numbers and cannot be used for credit cards which require 16 digits. If you don't need to do math on them, input long numbers into a range that you've formatted as text. Both above -and also entries automatically converted to dates- can be prevented by entering a single ' before the actual entry. Excel will now treat the cell as pure text and change nothing. * Why does my function display #NAME? The function may point to an add-in function that is not avaliable to this Excel. Most frequently it's an Analysis Toolpack function; go menu Tools Add-Ins and check that there are checks against Analysis Toolpak. Unlike Excel's built-in functions, Add-in functions do not translate themselves to regional language, so american add-in functions are by default unavaliable on a Norwegian computer and vice versa. * Is there way of returning the name of a sheet in a cell without using code? =CELL("Filename",A1) returns the complete file path and sheet name =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) will stip away everything but the sheet name. The file must be saved or the formula will not work. * My spreadsheet does not calculate correctly ! I'm right, Excel's wrong ! There are three common causes for messages like this. 1. What is displayed in the cells is not what's really there. A cell can show 1 (no decimals format) but it may well contain real or calculated values like 0.6 or 1.4. Add or multiply a bunch of those and you're surprised; Excel will calculate with real cell contents, NOT displayed contents. You may choose "precision as displayed" in the tools options menu for a workaround, but make sure you know what you do. 2. A computer use binary numbers, and this has its limitations. It can not represent numbers like 1/10 exact. Numbers like that are rounded to nearest 15 significant decimal digits, and Excel will be "wrong" around 15th-16th digit. Some operations suffer from this, and some boolean tests (tests that may appear as 0.1=0.1) can return False because of this. "Normal work" like sensible-number budgetting and day-to-day math is usually not affected, but this may not be the tool for advanced science. 3. You are using Excel's statistical functions. Some of those are not good enough. LINEST() (also SLOPE(), INTERCEPT(), VAR(), STDEV(), LOGEST(), TREND(), FORECAST(), etc.) uses a numerically unstable algorithm. You're right, Excel's wrong. Links to backgrounders and tools at /Excel/Statistics/ * My spreadsheet does not calculate at all ! Calculation is set to Manual, alter this in Tools Options menu. International issues: These functions are in english, and you can not enter them i a Swedish Excel as is. Run this macro: Sub EnterEnglishFunction() ActiveCell.Formula = InputBox("English function:") End Sub paste the function in and OK, and in most cases it translates. **** Dates and times **** Very very many Excel questions are about dates and times. Chip Pearson's webpage /excel/datetime.htm will give you understanding of how this works in Excel , and it has lots of useful samples. Here are a very few common questions: * How do I add times together ? Just add together just like any number (=A1+A2+A3). Use custom number format [h]:mm in the result cell to prevent rollover at 24 hours * How do I subtract time? Just subtract, like =B1-A1. Use Calendar format 1904 if you need to display negative results; Tools/Options/Calculation and check the 1904 Date System checkbox. Note that 1904 calendar will offset all dates by 4 years 1 day, so be careful. * I need to calculate a column with hh:mm (formatted for TIME) against a hour rate. So 0:45 minutes needs to be calculated against 120 per hour - with an answer of 90. Now it says 3.75 ??? 1 is a day; 24 hours. So one hour is 1/24. =A1*B1*24 will bring the desired result. Format result cell as currency or number (it tends to pick the date format by default). * When I copy-paste dates, they end up one day wrong. * When I copy-paste dates, they end up four years wrong. One workbook is using 1904 calendar, the other one 1900 (in the first example, years are not displayed, but definitely present). Go menu Tools/Options/Calculation and make them equal, preferrably also correct if you know what the dates was supposed to be. * When I try to sum the time data in the format: 5:20, 12:02, 20:12 etc. I get the value that is the real sum minus N*24, eg. 2:07 instead of 50:07. Use custom number format [h]:mm to prevent rollover at 24 hours * I'm adding up a large number of cells with seconds in them, i.e... 25, 50 47, etc... the result I would like is 1:10, 1:50: 2:03 Since XL stores times as fractions of days, in order to convert integers into times you need to divide the sum by (24*60*60) or 86,400 * How do I add 3 months to a date ? =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) * Could someone give me the series of worksheet functions that would emulate EOMONTH; last day of month? The last day of the month equals the zero'th of next month for some strange reason: =DATE(YEAR(A1),MONTH(A1)+1,0) * Excel thinks 1900 is a leap year. It's not. Yes it does and it's not. **** Macros, VBA functions **** * I have a user defined function that doesn't recalculate. Include all the cells that your UDF depends on in the argument list. Or enter this as the first statment in your Function: Application.Volatile This will cause the function to be executed whenever a calculation occurs in the workbook. * All of a sudden, when I open the file, it asks if I want to "Enable or Disable a Macro". There are no macros in this workbook. A macro has been added and then removed, leaving an empty module. Open the file, right click on a sheet tab and choose View Code. Look for modules and delete them. Empty modules trigger the macro query, as does an actual macro. While there, make sure all other object's modules are completely empty. *When a button is drawn onto a sheet the assign macro is not displayed. When right-clicking on the button the "assign macro" context menu item is no present. There are buttons and there are buttons, from the Forms toolbar or from the Control Toolbox. If "assign macro" is no option then it's the second kind. Choose "View code" and call your macro from it like this: Private Sub CommandButton1_Click() Call Macro1 End Sub * Some of the functions that we want our macros to accomplish are not possible without first unprotecting the worksheet/workbook with the password. Worksheets("MySheet").Unprotect password:="drowssap" 'your code here Worksheets("MySheet").Protect password:="drowssap" Be sure to protect your macro code to hide the sheet password. * I want Excel to run this macro automatically every time the Excel file is opened. Place the code in (or call it from) the Workbook_open event of the ThisWorkbook module in the VB editor. Or simply name your macro Auto_Open. If you choose to use both then Workbook__open will run before Auto_open. Auto_open will not run if the workbook is opened by another macro, you must use the RunAutoMacros method. Contrary; Workbook_open will run if the workbook is opened by a macro, you must use Application.EnableEvents = False to prevent it. * I want to add a toolbar to my spreadsheet that when clicked, brings up Userform1. Assing the toolbar button to this macro, which should be in a standard VBA module: Sub ShowForm () Userform1.Show End Sub * I want to show a userform each time my file is opened. Combine the two solutions above: Private Sub Workbook_Open() UserForm1.Show End Sub or Sub Auto_open() UserForm1.Show End Sub See Chip Pearson's /excel/events.htm for detail and many more useful events. * Can I ask my user for confirmiation before executing the macro ? Sub AskAndDo() If MsgBox("Are you sure ?", vbYesNo + vbQuestion) = _ vbNo Then Exit Sub 'Code goes here instead of MsgBox "Actions here" End Sub * Can I have my Macro make Excel NOT to ask "the file already exists, do you want to overwrite" type of questions ? Application.DisplayAlerts = False 'code to save, overwrite, delete, whatever goes here Application.DisplayAlerts = True * Is it possible to call a macro from the condition true or false side of a worksheet formula? ie. if(a2="ok",Run macro1,run macro2) Basically, the answer is No. You can write functions in VBA that you can call from worksheet cells, but these functions can only return a value. They can't modify other cells or alter any part of the Excel environment. (See next Q for a macro solution to the problem) * How do I run a macro everytime a certain cell changes it's value? There is an event called Worksheet_Change which is triggered when a value is entered (it will not fire when a formula result changes). One of the arguments to this event is 'Target' which is a reference to what changed. Since this event will occur whenever a value changes - you can use the target to see if it is the cell you are interested in: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("C5")) Is Nothing Then Exit Sub Else 'The cell you are monitoring has changed! 'Do whatever you need to do... End If End Sub * How do I find the first empty cell in A column ? If ActiveSheet.UsedRange.Count < 2 Then MsgBox 1 Else MsgBox Columns("A:A").Find(What:="", LookAt:=xlWhole).Row End If * How do I find the cell below the last entry in A column ? MsgBox Cells(65000, 1).End(xlUp).Row + 1 (This will return 2 on an empty A column) * How do I find the last row in my spreadsheet ? MsgBox ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row * I want to loop through all selected cells and perform an operation on each of them. Sub DoOnSelection() Dim oCell As Range For Each oCell In Selection oCell.Font.Bold = True Next End Sub * I want to loop through all worksheets and perform an operation on each of them (unprotecting or whatever). Sub AllSheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets MsgBox ws.Name Next End Sub * I want to loop through all workbooks in a folder and perform an operation on each of them. Sub AllFolderFiles() Dim wb As Workbook Dim TheFile As String Dim MyPath As String MyPath = "C:\Temp" ChDir MyPath TheFile = Dir("*.xls") Do While TheFile < "" Set wb = Workbooks.Open(MyPath & "\" & TheFile) MsgBox wb.FullName wb.Close TheFile = Dir Loop End Sub * How can I tell if a file exists in a spesific folder ? Function bFileExists(rsFullPath As String) As Boolean bFileExists = Len(Dir$(rsFullPath)) End Function * How can I tell if a spesific workbook is open ? Function bWorkbookIsOpen(rsWbkName As String) As Boolean On Error Resume Next bWorkbookIsOpen = Len(Workbooks(rsWbkName).Name) End Function * I want to let the user select a file within my macro. Sub SelectWebPageToOpen() Dim ThePage As Variant ThePage = _ Application.GetOpenFilename("Webpage (*.htm*), *.htm*", _ , "Pick one:") If ThePage = False Then MsgBox "You cancelled" Else MsgBox "Do something with file " & CStr(ThePage) End If End Sub * I want to let the user enter a "Save As" location in my macro. Sub SelectSaveFileName() Dim TheFile As Variant TheFile = Application.GetSaveAsFilename("C:\Temp\File.xls", _ "Workbook (*.xls), *.xls", , "Your choice:") If TheFile = False Then MsgBox "You cancelled" Else MsgBox "Do something with file " & CStr(TheFile) End If End Sub * Is there a way to hide the process of executing macro? Application.ScreenUpdating = False 'code here Application.ScreenUpdating = True *Is there a way to protect the macros I create so people can't see or alter them? Go to Tools VBAProject properties, lock the project for viewing, and enter a password. * How can I unprotect a VBA project using code ? You can not. A workaround is to simulate keystrokes with the SendKeys method. * How do I close a file/close Excel with a macro ? ActiveWorkbook.Close savechanges:=False 'true ??? will close the active workbook Workbooks("mywkbk.xls").Close savechanges:=False 'true ??? will close mywkbk.xls ThisWorkbook.Close savechanges:=False 'true ??? will close the workbook that holds the code that's running. Application.Quit will close all of Excel. Be careful with this one. **** I didn't find my answer here, now what ? **** First, do a search on /advanced_group_search to see wether a similar question has been answered before. Use *excel* in the newsgroup field. See 's /dmcritchie/excel/xlnews.htm for more on archive search. If no luck, post a question. Please follow these guidelines for a best possible result: * Tell us what versions of Excel and Windows you're using * Use an illustrative subject line, not "Excel problem" or "Help" * Don't post to more than one group. People don't like wasting time helping you if your problem is already solved elsewhere. * If you've already tried using some formulas or VBA, include what you've already tried. You may be very close. * Please don't ask us to email and don't follow up answers by direct email unless you are invited to. * Finally; do not attatch files. Attachments are frowned upon for a variety of reasons: - newsgroup Bloat. - download time. Many (most?) people pay their phone company a per-minute rate for connections. - virus concerns. Many won't or aren't allowed to open such files. - they takes up space on individual hard drives - they are not stored on newsgroup archives. - Take the time to explain your problem. Who knows, by writing out the question, you may even figure it out yourself. This list is condensed from Chip Pearson's webpage /excel/newposte.htm. **** Good resources on the web **** There is a very good Excel functions workbook by Peter Noneley at /noneley/ . Recommended. Comp.Apps.Sprreadsheets FAQ is located at /faqs/spreadsheets/faq/ .That one's stuffed with good links, some may be too old though. There are many good Excel webpages, and MVPs' / Frequent posters' signature addresses are all worth a visit. Instead of creating yet another links collection, let's just say Start Here: -walk.com/ss/excel/links/index.htm Finally: * What is an MVP and which exams do I take to become one ? MVP is an award that Microsoft give those who help people with using MS products and do it well. So stay here and provide lots of brilliant answers, then see what happens. There are no other exams than "practice, practice, practice". The MVP program is presented at / |
| 4066 | I created an Excel 97 file last week. I just tried opening the same file using Excel 97 and it's giving me an error message saying.... filename.xls file format is not valid and then gives me an OK button to click on. Any ides as to what might of happen to my excel file???? Your help is much appreciated. |
| 4075 | Rena Two things come to mind.... 1. You saved it to floppy and are trying to open it from there. Copy it over to the Hard drive and try to open from there, if this is the case. 2. You had Word open at the time and inadvertantly saved as a Word file(happens more often that you would think). HTH Gord Dibben Excel MVP - XL97 SR2 On Mon, 5 Aug 2002 16:26:33 -0500, "Rena Egan" <eganhl@nt.dot.state.il.us wrote: I created an Excel 97 file last week. I just tried opening the same file using Excel 97 and it's giving me an error message saying.... filename.xls file format is not valid and then gives me an OK button to click on. Any ides as to what might of happen to my excel file???? Your help is much appreciated. |
| 4084 | See my posting today dealing with undocumented memory limits in Excel for one possible theory. Unfortunately, I don't know of a solution yet. See also: www.decisionmodels.com/memlimitsc.htm -----Original Message----- Hi, I am running Excel 97 on a new P4 with 512Mb ram on NT4. I have a very large spreadsheet of data (the data file alone is in excess of 60Mb - without any formulas and calculations etc.), and when I open it I get a "Not enough memory" error. When I click OK, the file opens and I can work on it but I have had to switch "Calculation" to manual as it takes about 30 seconds to compute. When I check the memory useage I only seem to be using about 140Mb and seem to have ample free. There are no charts and no external links. Is there anyway I can get around this as prior to getting this message the calculation time was almost instantaneous. Any suggestions? James . |
| 4116 | [posted and mailed] "Greg Sole" <gregory.sole@thcl.co.nz wrote in news:01ed01c239d5$997f76c0 $b1e62ecf@tkmsftngxa04: I have seen a couple of similar posts but none seem quite the same as my user is having. Using Excel 97 running over Citrix Terminal Server (NT4). The user attempts to save their document and it pops up with a dialogue box that says only "Document not saved". No further attempts to save the document will be successful, wether it is saved on another network drive, saved as a different file or anything. The same message pops up every time. However, in the same session of Excel another document can be opened or created and saved fine, but still the one with the original problem will not save. The only way around the problem is to copy and paste each sheet into a new workbook and then you can save that over the original file. Appreciate any help on this. (I've checked the knowledge base too, and while it had a similar problem it wasnt quite the same and couldnt solve my one in any case) G'day Greg, From (unreliable ?) memory, I think this was a problem which SR2 solved. Cheers, Julian -- Julian Mattay, email: juliandotmattayatcsirodotau Systems Administrator CSIRO, Forestry and Forest Products Ph: +61 8 8721 8118 Mt Gambier, South Australia, Australia Fax: +61 8 8723 9058 |
| 4127 | Hello all; I'm working within MS Excel 97 & 2000. Having problems modifing my page setup from Portrait to Landscape. I have gone into page setup and changed accordingly with no joy. I have also gone into options within page setup and changed the orientation to landscape with no result. Any ideas; Russ |
| 4132 | Hi Russ, After choosing Landscape did you press [OK] button. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Russ Peake" <Russell.Peake@npower.com wrote in message news:119d01c23d25$912d13d0$3aef2ecf@TKMSFTNGXA09... Hello all; I'm working within MS Excel 97 & 2000. Having problems modifing my page setup from Portrait to Landscape. I have gone into page setup and changed accordingly with no joy. I have also gone into options within page setup and changed the orientation to landscape with no result. Any ideas; Russ |
| 4134 | Ok was pressed, David Russ -----Original Message----- Hi Russ, After choosing Landscape did you press [OK] button. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Russ Peake" <Russell.Peake@npower.com wrote in message news:119d01c23d25$912d13d0$3aef2ecf@TKMSFTNGXA09... Hello all; I'm working within MS Excel 97 & 2000. Having problems modifing my page setup from Portrait to Landscape. I have gone into page setup and changed accordingly with no joy. I have also gone into options within page setup and changed the orientation to landscape with no result. Any ideas; Russ . |
| 4140 | In Excel 97 and 2000 you can use an autofilter on a protected sheet if you (1) enable it, and (2) protect the sheet with Userinterfaceonly set to True: Sheet1.EnableAutoFilter = True Sheet1.Protect userinterfaceonly:=True The later setting is not retained with the workbook when saved so it must be reset when the workbook is re-opened. In Excel 2002 you can enable autofilter through the user interface (Tools, Protection, Protect Sheet). -- Jim Rech Excel MVP |
| 4153 | -----Original Message----- A friend of mine recently saved and excel file on his laptop which I opened on my home computer. After doing some modifications I saved the file again on the same disk and cannot get it to re-open. The message That I am getting is : 'financials.xls' cannot be accessed.The file may be read- only, or may be trying to access a read-only location. Or,the server the document is stored on may not be responding. . Does the laptop and your PC ahve same version of Excel, if its its mixture then you may get this problem, if your friend saved the file under Excel 97 and you saved it under Excel 2000, then this may be one of the problems, if you are saving in Excel 2000 then save as 97/2000 format. |
| 4173 | when I right click ... or use the menu, Dave ... all that comes up is the fonts tab ... but I will try it again just to make sure that the shakes weren't from the coffee ;-) On Tue, 06 Aug 2002 19:23:38 -0500, Dave Peterson <ec35720@msn.com wrote: I don't recall xl97 enough to say for sure, but I do know that when I right clicked on the textbox in xl2002, I could miss it and just get the Font tab (for the characters within the box). But when I stopped drinking the coffee, I could right click on the textbox border and get a bunch of tabs. Are you sure you didn't drink too much coffee, too. (I'll trust you if you try it one more time!) Peter Dahl wrote: Dave ... excellent ... and close ... #2 did the trick as far as the runtime error on the nulls .... but #1 is a problem. My problem, I'm sure since I'm back in the dark ages of Excel 97. I have to keep supporting that antique version for at least another 9 months while the company gets ready to roll out new workstations and software. (I get to upgrade next month ... but that doesn't help since all my users will be at the tail end of the upgrade). So ... since there is no protection option under "format text box" ... is there any other way to circumvent that problem? Right now, my only option seems to be to NOT protect that sheet. many thanks! This form is getting to be almost awesome ... maybe even good enough that my users will start following the process instead of doing verything possible to break it. On Mon, 05 Aug 2002 16:24:58 -0500, Dave Peterson <ec35720@msn.com wrote: PMFJI, #1. If you rightclick on the textbox (when the worksheet is not protected) and choose "format Text Box", then select the protection Tab. Make sure you leave "lock Text" not checked. (This protects the contents of the text box. The "Locked" protects the box itself from being deleted/moved/resized. Answer that one the way you want it. #2. If you modify Deb's routine slightly, you can pick off the first cell of the new selection: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim shp As Shape Set shp = ActiveSheet.Shapes("Text Box 1") shp.TextFrame.Characters.Text = Target(1).Text End Sub Notice the Target(1).Text <<I think that this is the routine you and Deb were working on. Peter Dahl wrote: Debra, you nailed it ... I hadn't entered the code in the right place ... chose module instead of worksheet. Work pretty good .... but I do have one problem that occurs now: 1) when the worksheet is protected, I get runtime errors. (RunTime Error '1004'; unable to set the Text property of the Character class) 2) I get a different runtime error when the active cell is a non-single cell. For example, I have many cells where I have merged several cells for appearance sake ... these all return a runtime error regarding improper use of a "null". ever seen either of these before? I'm not as concerned about the null value one ... but I'd like to fix the protected status ... thanks peter On Wed, 31 Jul 2002 15:25:27 -0400, Debra Dalgleish <dsd@contextures.com wrote: The Worksheet_SelectionChange procedure goes on the module for the worksheet where the text box is located. Right-click the sheet tab, and choose View Code. Paste the procedure there and it should work. Peter Dahl wrote: Thanks Debra ... that looks promising, but I'm having a problem still. As I understand it, I need to create a text box that will show the text when there is an active cell. I created the text box and the button. Button works fine ... text box appears and disappears on command. But ... nothing shows up in the box. I entered the text exactly as you show ... and set it up as module 4 (I already had 3 modules in the worksheet, so when I defined this one, it saved as 4) ... but no matter what cell I make active, nothing shows in the box. Is there something missing in the private sub (since there's a blank line between lines 3 and 5)? thanks! peter On Sat, 27 Jul 2002 11:12:06 -0400, Debra Dalgleish <dsd@contextures.com wrote: You could add a text box to the form, and use it to display the text of the active cell. A button could show or hide the text box, by toggling its Visible property. Code for command button, to show/hide the text box: ActiveSheet.Shapes("Text Box 1").Visible _ = Not ActiveSheet.Shapes("Text Box 1").Visible Code to show text of active cell (this goes on the worksheet module): Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim shp As Shape Set shp = ActiveSheet.Shapes("Text Box 1") shp.TextFrame.Characters.Text = Target.Text End Sub Peter Dahl wrote: I have a form that has, per line, 2 drop down boxes that the user selects values in. When the second value is selected, the rest of the row - which contains formulas to retrieve data from a hidden second sheet - gets filled. The problem that I have is that I would like to somehow - macro? - turn the formula results to the value that is retrieved. The problem that I'm trying to saolve is that some of the returned values are wider than the cell ... and the user cannot see the additional text ... if they click in the cell, they'll see the formula, not the value. Any secrets to share? peter too bad common sense isn't -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html too bad common sense isn't -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html too bad common sense isn't -- Dave Peterson ec35720@msn.com too bad common sense isn't -- Dave Peterson ec35720@msn.com too bad common sense isn't |
| 4174 | Point to the border of the textbox -- the pointer changes to a white arrow with a 4-headed arrow at the tip. When that's visible, right-click, and choose Format Text Box. A 7-tab dialog box will open. Peter Dahl wrote: when I right click ... or use the menu, Dave ... all that comes up is the fonts tab ... but I will try it again just to make sure that the shakes weren't from the coffee ;-) On Tue, 06 Aug 2002 19:23:38 -0500, Dave Peterson <ec35720@msn.com wrote: I don't recall xl97 enough to say for sure, but I do know that when I right clicked on the textbox in xl2002, I could miss it and just get the Font tab (for the characters within the box). But when I stopped drinking the coffee, I could right click on the textbox border and get a bunch of tabs. Are you sure you didn't drink too much coffee, too. (I'll trust you if you try it one more time!) Peter Dahl wrote: Dave ... excellent ... and close ... #2 did the trick as far as the runtime error on the nulls .... but #1 is a problem. My problem, I'm sure since I'm back in the dark ages of Excel 97. I have to keep supporting that antique version for at least another 9 months while the company gets ready to roll out new workstations and software. (I get to upgrade next month ... but that doesn't help since all my users will be at the tail end of the upgrade). So ... since there is no protection option under "format text box" ... is there any other way to circumvent that problem? Right now, my only option seems to be to NOT protect that sheet. many thanks! This form is getting to be almost awesome ... maybe even good enough that my users will start following the process instead of doing verything possible to break it. On Mon, 05 Aug 2002 16:24:58 -0500, Dave Peterson <ec35720@msn.com wrote: PMFJI, #1. If you rightclick on the textbox (when the worksheet is not protected) and choose "format Text Box", then select the protection Tab. Make sure you leave "lock Text" not checked. (This protects the contents of the text box. The "Locked" protects the box itself from being deleted/moved/resized. Answer that one the way you want it. #2. If you modify Deb's routine slightly, you can pick off the first cell of the new selection: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim shp As Shape Set shp = ActiveSheet.Shapes("Text Box 1") shp.TextFrame.Characters.Text = Target(1).Text End Sub Notice the Target(1).Text <<I think that this is the routine you and Deb were working on. Peter Dahl wrote: Debra, you nailed it ... I hadn't entered the code in the right place ... chose module instead of worksheet. Work pretty good .... but I do have one problem that occurs now: 1) when the worksheet is protected, I get runtime errors. (RunTime Error '1004'; unable to set the Text property of the Character class) 2) I get a different runtime error when the active cell is a non-single cell. For example, I have many cells where I have merged several cells for appearance sake ... these all return a runtime error regarding improper use of a "null". ever seen either of these before? I'm not as concerned about the null value one ... but I'd like to fix the protected status ... thanks peter On Wed, 31 Jul 2002 15:25:27 -0400, Debra Dalgleish <dsd@contextures.com wrote: The Worksheet_SelectionChange procedure goes on the module for the worksheet where the text box is located. Right-click the sheet tab, and choose View Code. Paste the procedure there and it should work. Peter Dahl wrote: Thanks Debra ... that looks promising, but I'm having a problem still. As I understand it, I need to create a text box that will show the text when there is an active cell. I created the text box and the button. Button works fine ... text box appears and disappears on command. But ... nothing shows up in the box. I entered the text exactly as you show ... and set it up as module 4 (I already had 3 modules in the worksheet, so when I defined this one, it saved as 4) ... but no matter what cell I make active, nothing shows in the box. Is there something missing in the private sub (since there's a blank line between lines 3 and 5)? thanks! peter On Sat, 27 Jul 2002 11:12:06 -0400, Debra Dalgleish <dsd@contextures.com wrote: You could add a text box to the form, and use it to display the text of the active cell. A button could show or hide the text box, by toggling its Visible property. Code for command button, to show/hide the text box: ActiveSheet.Shapes("Text Box 1").Visible _ = Not ActiveSheet.Shapes("Text Box 1").Visible Code to show text of active cell (this goes on the worksheet module): Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim shp As Shape Set shp = ActiveSheet.Shapes("Text Box 1") shp.TextFrame.Characters.Text = Target.Text End Sub Peter Dahl wrote: I have a form that has, per line, 2 drop down boxes that the user selects values in. When the second value is selected, the rest of the row - which contains formulas to retrieve data from a hidden second sheet - gets filled. The problem that I have is that I would like to somehow - macro? - turn the formula results to the value that is retrieved. The problem that I'm trying to saolve is that some of the returned values are wider than the cell ... and the user cannot see the additional text ... if they click in the cell, they'll see the formula, not the value. Any secrets to share? peter too bad common sense isn't -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html too bad common sense isn't -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html too bad common sense isn't -- Dave Peterson ec35720@msn.com too bad common sense isn't -- Dave Peterson ec35720@msn.com too bad common sense isn't -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 4181 | On Excel 2000, I think the default is: C:\WINDOWS\Application Data\Microsoft\Excel\Excel.xlb On Excel 97, you will find: C:\WINDOWS\userxyz8.xlb C:\WINDOWS\userabc8.xlb C:\WINDOWS\Excel8.xlb "AO" <aothnay@jnjil.jnj.com wrote in message news:O6Xx3cRPCHA.1620@tkmsftngp10... Hello All, I wanted to backup the costume toolbars but I only found old "excel.xlb" which was created few years ago and no other file like *.xlb. Where can I find the missing "xlb" or how can I create new one ? I thought that Excel generate this file automatically. TIA, Alon |
| 4232 | Is the sheet protected ? REgards BrianB =================================== "Russ Peake" <Russell.Peake@npower.com wrote in message news:<119d01c23d25$912d13d0$3aef2ecf@TKMSFTNGXA09... Hello all; I'm working within MS Excel 97 & 2000. Having problems modifing my page setup from Portrait to Landscape. I have gone into page setup and changed accordingly with no joy. I have also gone into options within page setup and changed the orientation to landscape with no result. Any ideas; Russ |
| 4264 | Hi at all, is it possible to resize an Excel worksheet from normal 65.536 line/256 row - resolution to any other (customizeable) size. For a simple data analysis I need a single 500 line/ 1000 row worksheet but how can I extend the 256 row limit in Excel??? (using MS-Excel 97 SR-2) Any ideas? And just in case this is an boring FAQ - mea culpa, but I didn't find an answer through the normal search. Thanks a lot for your answer, Christian |
| 4278 | Hallo, I've recently installed Excel 97 on Win XP home. When I open any existing excel document I get the message:" a document with the same name is already open. Cannot open two documents with tha same name etc........" It does the same with newly created documents. Thanks, Sandro |
| 4370 | I have desinged a spreadsheet which uses a number of active-x combo boxes, check boxes, and option buttons. They are all set to print, and I was able to print them all successfully one time and one time only. Now, both in print preview and on the printer, a few of the objects print WYSIWYG; the rest all print, but are tiny (like 1 point font or 3mm by .25mm) They are actually sized to hold 10pt. Arial font. I have tried on two machines and two printers (an hp laser and an epson color inkjet) and have made sure I have the latest drivers. Dragging the object to a much bigger size will sometimes get it to print, but not always. I've spent a day trying to figure this out. Can anyone provide any ideas for resolving the problem? I'm using Excel 97 on a Windows ME with all updates that i know of installed. Thanks! Don |
| 4414 | Hi, Can anyone please tell me why it is that whenever I try to print a spreadsheet, as you go further down the page, the text starts to overlap the border lines of the cells (vertically only) ? This only happens to my PC (the file is on a network share and prints within the cell borders from other PC's). I have tried Excel 97, 2000 and XP but all produce the same results. The printer is set to print using the correct media (A4). In print preview, all appears OK, it's only when actually printed. Thanks in advance ! Regards Colin. |
| 4451 | Hi Colin, You did not indicate if you share printer with others not having the problem or if you have your own printer. Have you tried printing from your computer to a different printer. Someone told me a couple days ago about printing gradually shifting to the right while printing down the page and the solution for a particular type of printer was to clean a belt in the printer. Doubt that is your problem because it sounds to me like your cell borders remain unshifted but your text shifts. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Colin" <colin_tumelty@mrn.co.uk wrote in message news:026201c23f91$e42a2410$35ef2ecf@TKMSFTNGXA11... Hi, Can anyone please tell me why it is that whenever I try to print a spreadsheet, as you go further down the page, the text starts to overlap the border lines of the cells (vertically only) ? This only happens to my PC (the file is on a network share and prints within the cell borders from other PC's). I have tried Excel 97, 2000 and XP but all produce the same results. The printer is set to print using the correct media (A4). In print preview, all appears OK, it's only when actually printed. Thanks in advance ! Regards Colin. |
| 4474 | In Excel 97 I'm sure I could select all the subtotals in a pivot table field - to format them all the same. In Excel 2000 I don't seem tro be able to do this manually - I have to use a preselected presentation that does not do what I want. Is there any way around this? Hopefully, Gef |