Date Formula Microsoft Excel 97 2000 2002 free tutorial format function workbook worksheet sum report printing pivot table forms templates template Date Data CountIf Count VBA Macro excel formula subtotal filtering chart graph

Microsoft Excel 97

ArticleBody
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 pos