add-in combo box date excel 2000 excel 2002 excel 97 excel XP format formatting formula grouping loan - amortization macros subtotal sum excel tutorial workbook worksheet vba
| 868 | A user had her Excel 2000 files stored on her hard drive. I moved them to her folder on the server so they would be backed up. The copy went fine. But when she opens a file and tries to save, it tells her they are read only. This happens on all the Excel files. Our server is NT 4.0 SP6a. She has full rights to her server folder. I looked at the file properties and they are not checked as read only. Does anyone know a solution for this. Thanks, Diane |
| 879 | Further to larrys post (27/6/02). I have a number of columns. I want to count the number of times each name appears in each column and show this as a '100% Stacked Graph'. There are just 4 different names but several thousand entries. The catch is that I need to do this as a pivotchart (in Excel 2000) - (in addition to the 'data columns' containing the names I have a number of 'criteria columns'). I thought this would be dead easy but....... Any advice is most welcome. Adrian Matthews |
| 886 | I should have mentioned: With the list in column A And the formula =TRIM(A1) in B1 Just double click in the "DragHandle" of B1 That gets my vote for the easiest and quickest. (I just might be a little prejudiced) Regards, RD "Dave Peterson" <ec35720@msn.com wrote in message news:3D1A4474.E8EBB141@msn.com... If you select a range of cells (say b1:b100) then type in your formula in A1 and hit ctrl-shift-enter, it'll convert it all in one fell swoop! If you limit your array range to one cell, I don't think you'll get what you want. Ragdyer wrote: Hi Roger, What does =TRIM(A1:A100) do ? Regards, RD "Roger Govier" <roger@technology4u.co.uk wrote in message news:kspjhu0vk04bfhj956knu0l9usq83on84q@4ax.com... Hi Bill Take look at the TRIM() function =TRIM(A1:A100) will remove the excess leading and trailing spaces for you. -- Roger Govier Technology 4 U W98SR2 XL2K On Wed, 26 Jun 2002 08:35:58 -0700, "Bill" <bill@thetrainingassociates.com wrote: Hi All, One more problem that I would really appreciate your help with. I do a lot of importing into a particular Excel 2000 database from all kinds of sources.I extract names, addresses, email, you name it. Included with the imports in some cells are leading spaces. They completely ruin sorts because all data sorted in these columns alphabetically, sorts a-z without the leading spaces, then continues sorting from a-z witht the leading spaces!!! How do I get rid of these leading spaces!!!! I tried using indent, left align, replace, nothing works. Do I have to go through all the cells with these leading spaces and delete them manually????!!!!!!!!!!!!!!!!! Thanks for your quick and concise response from my first question. You guys are great!!!! -- Dave Peterson ec35720@msn.com |
| 893 | Hi RD I think I would agree with you. But, variety is the "spice of life"<g -- -- Roger Govier Technology 4 U W98SR2 XL2K "Ragdyer" <RAGDYER@MSN.COM wrote in message news:enVfGueHCHA.2532@tkmsftngp13... I should have mentioned: With the list in column A And the formula =TRIM(A1) in B1 Just double click in the "DragHandle" of B1 That gets my vote for the easiest and quickest. (I just might be a little prejudiced) Regards, RD "Dave Peterson" <ec35720@msn.com wrote in message news:3D1A4474.E8EBB141@msn.com... If you select a range of cells (say b1:b100) then type in your formula in A1 and hit ctrl-shift-enter, it'll convert it all in one fell swoop! If you limit your array range to one cell, I don't think you'll get what you want. Ragdyer wrote: Hi Roger, What does =TRIM(A1:A100) do ? Regards, RD "Roger Govier" <roger@technology4u.co.uk wrote in message news:kspjhu0vk04bfhj956knu0l9usq83on84q@4ax.com... Hi Bill Take look at the TRIM() function =TRIM(A1:A100) will remove the excess leading and trailing spaces for you. -- Roger Govier Technology 4 U W98SR2 XL2K On Wed, 26 Jun 2002 08:35:58 -0700, "Bill" <bill@thetrainingassociates.com wrote: Hi All, One more problem that I would really appreciate your help with. I do a lot of importing into a particular Excel 2000 database from all kinds of sources.I extract names, addresses, email, you name it. Included with the imports in some cells are leading spaces. They completely ruin sorts because all data sorted in these columns alphabetically, sorts a-z without the leading spaces, then continues sorting from a-z witht the leading spaces!!! How do I get rid of these leading spaces!!!! I tried using indent, left align, replace, nothing works. Do I have to go through all the cells with these leading spaces and delete them manually????!!!!!!!!!!!!!!!!! Thanks for your quick and concise response from my first question. You guys are great!!!! -- Dave Peterson ec35720@msn.com |
| 896 | Excel 2000 allowes you to create a geographical map and associate with data. I have upgraded to Office XP and am not having success at finding the map in Excel anymore. Is this still an option provided with Excel? If so, how do you hook it back up? Thanks for the help! Mackeby |
| 915 | The map component, called "MS Map", is not available with Office XP. Maps created in earlier versions of Excel can still be opened, but you cannot modify them, nor can you create new maps. Microsoft MapPoint, a stand-alone product from MS, works quite well with Excel and provides much more than the old MS Map. It is, however, a separate program, not part of Excel, and costs around $250. See /office/mappoint/ for more information about MapPoint. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com chip@cpearson.com "Mackeby" <Matthewhuffman@netscape.net wrote in message news:1113b01c21dee$ee6e8e80$36ef2ecf@tkmsftngxa12... Excel 2000 allowes you to create a geographical map and associate with data. I have upgraded to Office XP and am not having success at finding the map in Excel anymore. Is this still an option provided with Excel? If so, how do you hook it back up? Thanks for the help! Mackeby |
| 918 | If you still have your Excel 2000 disks, you can try the tip on this page: Getting What's Missing in Excel 2002 /winplanet/tips/3997/1/ Mackeby wrote: Excel 2000 allowes you to create a geographical map and associate with data. I have upgraded to Office XP and am not having success at finding the map in Excel anymore. Is this still an option provided with Excel? If so, how do you hook it back up? Thanks for the help! Mackeby -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 930 | Thanks - I did the next best thing! I reinstalled office 2000. I was not happy with Office XP for many different reasons. Mackeby -----Original Message----- If you still have your Excel 2000 disks, you can try the tip on this page: Getting What's Missing in Excel 2002 /winplanet/tips/3997/1/ Mackeby wrote: Excel 2000 allowes you to create a geographical map and associate with data. I have upgraded to Office XP and am not having success at finding the map in Excel anymore. Is this still an option provided with Excel? If so, how do you hook it back up? Thanks for the help! Mackeby -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html . |
| 943 | Roger, I am using Excel 2000.....and I tried using copy cell....past special.......value and then I get the message.... Could it be because my columns on my form might have cell that are protected.... like if I have cell D2 and it's a protected cell....would it create a problem for Cell D14............that is a merged cell with E14, F14, G14 and H14.... Thanks Jaime "Roger Govier" <roger@technology4u.co.uk wrote in message news:#VogcSgHCHA.2436@tkmsftngp10... Hi Jaime What version of XL are you using? I just tried it in XL2k and XL2002 and in both cases the merged cell copied to the destination cell, and, formatted the destination the same as the source merged cells. Selecting Paste Special, copied the value but left the destination cell with the same single cell format as original. -- Roger Govier Technology 4 U W98SR2 XL2K "JR" <jaimeh@admin.usmetals.com wrote in message news:OXTFoLgHCHA.2436@tkmsftngp10... Hello, I have tried to copy the value of a cell (AA114) into cell D14... But it give me an error that reads, Merged cells must be the same exact size as cells being copied. I have made the cells the same size and I sill get the message... Is there another way to do this.. Thanks Jaime |
| 1007 | Wilson, both of the cells N3 and C7 are formatted as a date does this make a difference and in your Last Sub, I have a rap problem. Maybe you could help with these suggestions. TIA Greg "Wilson" <jwilson@wickes.com wrote in message news:eDda3UpHCHA.2464@tkmsftngp10... Can't be of any help. Works fine on my Excel 2000 Windows 2K PRO ????? "Greg Rivet" <gregrivet@hotmail.com wrote in message news:#yqd5UiHCHA.1740@tkmsftngp10... Wilson, Sub first works great, Sub Last, I get a "Type Mismatch" error. Greg "Wilson" <jwilson@wickes.com wrote in message news:eAL5yuhHCHA.2272@tkmsftngp09... Here you go, Greg Sub First() Dim r As Integer r = 7 Range(Cells(6, 3), Cells(25, 3)).ClearContents Cells(r, 3) = Cells(3, 14) For r = 8 To 21 Cells(r, 3) = Cells(r - 1, 3) + 1 Next r End Sub Sub Last() Dim r As Integer Dim e r = 7 Range(Cells(6, 3), Cells(25, 3)).ClearContents Cells(r, 3) = Cells(3, 14) + 15 Cells(r - 1, 3).FormulaR1C1 = "=DAY(DATE(YEAR(R[-3]C[11]),MONTH(R[-3]C[11])+1,0))" e = Cells(r - 1, 3) For r = 8 To e - 9 Cells(r, 3) = Cells(r - 1, 3) + 1 Next r Cells(6, 3).ClearContents End Sub HTH "Greg Rivet" <gregrivet@hotmail.com wrote in message news:ecoKAgfHCHA.2240@tkmsftngp08... Wilson, your macros work perfectly. Now how do I improve on them and fill C8 to C??? for the balance of the pay period. In other words your macros fill the First for the first day of the month and Last, the 16th. Now I want to fill column C to the 15th for the First and 16th to end of month for Last. TIA Greg "Wilson" <jwilson@wickes.com wrote in message news:uSwOcZfHCHA.2644@tkmsftngp10... Assign these macros to the buttons Sub First() Range("C7") = Range("N3") End Sub Sub Last() Range("C7") = Range("N3") + 15 End Sub HTH "Greg Rivet" <gregrivet@hotmail.com wrote in message news:#n9AcRfHCHA.2496@tkmsftngp08... I have an option button from the forms toolbar on my sheet. There are 2 options, First and Last. If First is chosen, I would like cell C7 to reflect the first date of the month, which is indicated in Cell N3. If Last is chosen, I would like the 16th of the month in Cell C7. How do I accomplish this feat. TIA Greg |
| 1008 | Wilson, ignore my last post. It was a rap problem. Works like a dream.............Thanks Greg "Wilson" <jwilson@wickes.com wrote in message news:eDda3UpHCHA.2464@tkmsftngp10... Can't be of any help. Works fine on my Excel 2000 Windows 2K PRO ????? "Greg Rivet" <gregrivet@hotmail.com wrote in message news:#yqd5UiHCHA.1740@tkmsftngp10... Wilson, Sub first works great, Sub Last, I get a "Type Mismatch" error. Greg "Wilson" <jwilson@wickes.com wrote in message news:eAL5yuhHCHA.2272@tkmsftngp09... Here you go, Greg Sub First() Dim r As Integer r = 7 Range(Cells(6, 3), Cells(25, 3)).ClearContents Cells(r, 3) = Cells(3, 14) For r = 8 To 21 Cells(r, 3) = Cells(r - 1, 3) + 1 Next r End Sub Sub Last() Dim r As Integer Dim e r = 7 Range(Cells(6, 3), Cells(25, 3)).ClearContents Cells(r, 3) = Cells(3, 14) + 15 Cells(r - 1, 3).FormulaR1C1 = "=DAY(DATE(YEAR(R[-3]C[11]),MONTH(R[-3]C[11])+1,0))" e = Cells(r - 1, 3) For r = 8 To e - 9 Cells(r, 3) = Cells(r - 1, 3) + 1 Next r Cells(6, 3).ClearContents End Sub HTH "Greg Rivet" <gregrivet@hotmail.com wrote in message news:ecoKAgfHCHA.2240@tkmsftngp08... Wilson, your macros work perfectly. Now how do I improve on them and fill C8 to C??? for the balance of the pay period. In other words your macros fill the First for the first day of the month and Last, the 16th. Now I want to fill column C to the 15th for the First and 16th to end of month for Last. TIA Greg "Wilson" <jwilson@wickes.com wrote in message news:uSwOcZfHCHA.2644@tkmsftngp10... Assign these macros to the buttons Sub First() Range("C7") = Range("N3") End Sub Sub Last() Range("C7") = Range("N3") + 15 End Sub HTH "Greg Rivet" <gregrivet@hotmail.com wrote in message news:#n9AcRfHCHA.2496@tkmsftngp08... I have an option button from the forms toolbar on my sheet. There are 2 options, First and Last. If First is chosen, I would like cell C7 to reflect the first date of the month, which is indicated in Cell N3. If Last is chosen, I would like the 16th of the month in Cell C7. How do I accomplish this feat. TIA Greg |
| 1020 | That's good news, Greg. Enjoy! "Greg Rivet" <gregrivet@hotmail.com wrote in message news:eg9JpwrHCHA.2468@tkmsftngp13... Wilson, ignore my last post. It was a rap problem. Works like a dream.............Thanks Greg "Wilson" <jwilson@wickes.com wrote in message news:eDda3UpHCHA.2464@tkmsftngp10... Can't be of any help. Works fine on my Excel 2000 Windows 2K PRO ????? "Greg Rivet" <gregrivet@hotmail.com wrote in message news:#yqd5UiHCHA.1740@tkmsftngp10... Wilson, Sub first works great, Sub Last, I get a "Type Mismatch" error. Greg "Wilson" <jwilson@wickes.com wrote in message news:eAL5yuhHCHA.2272@tkmsftngp09... Here you go, Greg Sub First() Dim r As Integer r = 7 Range(Cells(6, 3), Cells(25, 3)).ClearContents Cells(r, 3) = Cells(3, 14) For r = 8 To 21 Cells(r, 3) = Cells(r - 1, 3) + 1 Next r End Sub Sub Last() Dim r As Integer Dim e r = 7 Range(Cells(6, 3), Cells(25, 3)).ClearContents Cells(r, 3) = Cells(3, 14) + 15 Cells(r - 1, 3).FormulaR1C1 = "=DAY(DATE(YEAR(R[-3]C[11]),MONTH(R[-3]C[11])+1,0))" e = Cells(r - 1, 3) For r = 8 To e - 9 Cells(r, 3) = Cells(r - 1, 3) + 1 Next r Cells(6, 3).ClearContents End Sub HTH "Greg Rivet" <gregrivet@hotmail.com wrote in message news:ecoKAgfHCHA.2240@tkmsftngp08... Wilson, your macros work perfectly. Now how do I improve on them and fill C8 to C??? for the balance of the pay period. In other words your macros fill the First for the first day of the month and Last, the 16th. Now I want to fill column C to the 15th for the First and 16th to end of month for Last. TIA Greg "Wilson" <jwilson@wickes.com wrote in message news:uSwOcZfHCHA.2644@tkmsftngp10... Assign these macros to the buttons Sub First() Range("C7") = Range("N3") End Sub Sub Last() Range("C7") = Range("N3") + 15 End Sub HTH "Greg Rivet" <gregrivet@hotmail.com wrote in message news:#n9AcRfHCHA.2496@tkmsftngp08... I have an option button from the forms toolbar on my sheet. There are 2 options, First and Last. If First is chosen, I would like cell C7 to reflect the first date of the month, which is indicated in Cell N3. If Last is chosen, I would like the 16th of the month in Cell C7. How do I accomplish this feat. TIA Greg |
| 1021 | When I copied the table, then edited the comment, the Paste function was not available. However, by puting the comment in edit mode, then using Ctrl-Page Up to go to the worksheet with the table, then copying the table, then going back to the worksheet with the comment, which ws still in edit mode, I was then able to Paste. (Had tried Copy Picture but I had many such tables to do and the file size would become extremely large.) Thanks........ Billy Billy Thomas <bthomas@gcronline.com wrote in message news:u1TTZQnHCHA.2696@tkmsftngp12... I am using Excel 2000. I have some data tables I would like to place in cell comments. Is there anyway to accomplish this by pasting them into the comment box? Manually entering them would be quite a chore. Thanks Billy |
| 1051 | You could use a Workbook_BeforePrint sub in ThisWorkbook module with Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveWindow.DisplayZeros = False End Sub and then turn them back on with F9 and Private Sub Workbook_SheetCalculate(ByVal Sh As Object) ActiveWindow.DisplayZeros = True End Sub HTH "Jackie" <genmaicha@aol.com wrote in message news:1184d01c21ed5$7ec4a8c0$2ae2c90a@hosting.microsoft.com... I have been recently been converting really, really, old versions of Lotus files into Excel 2000 workbooks. In doing so I have had to modify formulas etc. There is a formula in Lotus that says if a cell equals zero, then do not print that row/column (or the designated range of cells). I have not been able to reproduce this in Excel. Is there a way to supress zeros when printing an Excel file? |
| 1083 | I have a spreadsheet consisting of 70+ worksheets. In one of the cells on each worksheet (say G3) I want a page number to display. I want to be able to move the worksheets around and add or delete them, but still have the page numbering remain sequential for the first worksheet to the last in order. Is there anyway to accomplish this? Thanks in advance for any assistance. (Excel 2000) |
| 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 |
| 1150 | Thanks Don, that works perfectly. If I could request one small addition... How would I skip an initial index worksheet, and have the second worksheet start as page one. Thank you again for your assistance. Jack "Don Guillett" <donaldb@281.com wrote in message news:<#TTPskuHCHA.2628@tkmsftngp11... Sub sheetnum() i = 1 For Each ws In Sheets ws.Select [a1] = i i = i + 1 Next End Sub -- Don Guillett SalesAid Software Granite Shoals, TX donaldb@281.com "Jack" <albus4@hotmail.com wrote in message news:5acbc5b6.0206281304.6d6d37e2@posting.google.com... I have a spreadsheet consisting of 70+ worksheets. In one of the cells on each worksheet (say G3) I want a page number to display. I want to be able to move the worksheets around and add or delete them, but still have the page numbering remain sequential for the first worksheet to the last in order. Is there anyway to accomplish this? Thanks in advance for any assistance. (Excel 2000) |
| 1217 | Recurring problem: Selected cells won't respond to formatting. The following problems happen: * Apply Border toolbar shorcut doesn't work. * A right-click from selected cells, choice of FORMAT CELLS... produces no sub-menu * Accessing the main menu Format/Cells... produces no submenu. I had this problem in one part of my sheet and I decided to insert a new leftmost column. After this I could format some cells that now had an empty column to the side. But other areas still don't respond. Pass the clue, please. -jc Using Excel 2000 (Version 5.0.2195 Service Pack 1 Build 2195) |
| 1219 | Hi Murray =Upper(A1) =Proper(A1) =Lower(A1) -- Regards William willwest22@yahoo.com "murray" <murray.hall@markelintl.com.au wrote in message news:13fdb01c2214f$531ba990$9ae62ecf@tkmsftngxa02... | Hi,is there a way to change case in excel. I know it can | be done in Word. I'm using Excel 2000. | Thanks in advance | Murray |
| 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 |
| 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 |
| 1234 | Is the sheet protected? HTH RD "jc" <halfmybrain@yahoo.com wrote in message news:140ec01c22150$75e97690$b1e62ecf@tkmsftngxa04... Recurring problem: Selected cells won't respond to formatting. The following problems happen: * Apply Border toolbar shorcut doesn't work. * A right-click from selected cells, choice of FORMAT CELLS... produces no sub-menu * Accessing the main menu Format/Cells... produces no submenu. I had this problem in one part of my sheet and I decided to insert a new leftmost column. After this I could format some cells that now had an empty column to the side. But other areas still don't respond. Pass the clue, please. -jc Using Excel 2000 (Version 5.0.2195 Service Pack 1 Build 2195) |
| 1235 | There are 3 commands you might be interested in. =upper(cell) =lower(cell) =proper(cell) -----Original Message----- Hi,is there a way to change case in excel. I know it can be done in Word. I'm using Excel 2000. Thanks in advance Murray . |
| 1240 | I have a spreadsheet that was created in Excel 2000 which displays an error condition, but only when opened in Excel 2002. Some cells containing numbers are displayed with a small green triangle in the upper left corner of the cell. When you place your mouse pointer in this cell an error box appears to the left of the cell which contains an exclamation point and a drop down menu. The drop down menu tells you that you have a number in the cell which has been stored as text, and asks whether you want to correct this "error" by converting it to a number. Once you do this the green triangle is removed, and you are presumably okay. I opened a new spreadsheet in 2002 and pre-formatted a cell to text before entering a number. The green triangle appeared, and reformatting the cell to general or number did not make it go away. You have to fix the "error" with the special drop down box to the left of the cell. However, if you format a cell as text after a number has been entered into it using general or number format this error does not occur. I also encountered this problem when trying to import this spreadsheet into Access 2000. These cells cause an import error to occur - error 3349 numeric overflow. Once the "error" cells are fixed this import error disappears. Is anyone aware of a general fix for this problem by way of a service pack for Excel 2002? Bill |
| 1241 | Hi jc It sounds like there might be some code in the Sheet Object, right click on the sheet name tab select "View Code" if there anything there post it here, or delete it if you feel comfortable doing so. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "jc" <halfmybrain@yahoo.com wrote in message news:140ec01c22150$75e97690$b1e62ecf@tkmsftngxa04... | Recurring problem: Selected cells won't respond to | formatting. The following problems happen: | | * Apply Border toolbar shorcut doesn't work. | * A right-click from selected cells, choice of FORMAT | CELLS... produces no sub-menu | * Accessing the main menu Format/Cells... produces no | submenu. | | I had this problem in one part of my sheet and I decided | to insert a new leftmost column. After this I could format | some cells that now had an empty column to the side. But | other areas still don't respond. | | Pass the clue, please. | | -jc | | | Using Excel 2000 | (Version 5.0.2195 Service Pack 1 Build 2195) | |
| 1247 | Hi Bill ToolsOptionsError Checking. You can record a macro toggling the options to get the code. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "Bill Murphy" <wmurphy@NO*SPAM!houston.rr.com wrote in message news:377U8.25029$p85.681329@twister.austin.rr.com... | I have a spreadsheet that was created in Excel 2000 which displays an error | condition, but only when opened in Excel 2002. Some cells containing | numbers are displayed with a small green triangle in the upper left corner | of the cell. When you place your mouse pointer in this cell an error box | appears to the left of the cell which contains an exclamation point and a | drop down menu. The drop down menu tells you that you have a number in the | cell which has been stored as text, and asks whether you want to correct | this "error" by converting it to a number. Once you do this the green | triangle is removed, and you are presumably okay. | | I opened a new spreadsheet in 2002 and pre-formatted a cell to text before | entering a number. The green triangle appeared, and reformatting the cell | to general or number did not make it go away. You have to fix the "error" | with the special drop down box to the left of the cell. However, if you | format a cell as text after a number has been entered into it using general | or number format this error does not occur. | | I also encountered this problem when trying to import this spreadsheet into | Access 2000. These cells cause an import error to occur - error 3349 | numeric overflow. Once the "error" cells are fixed this import error | disappears. | | Is anyone aware of a general fix for this problem by way of a service pack | for Excel 2002? | | Bill | | |
| 1252 | If it isn't what RD wrote, I can commiserate with you. I've seen this type of problem on 2 or 3 workbooks. They were always created with another program (Lotus 123 or Crystal Reports (IIRC)). I don't have a fix, but I did notice that if I selected more of a range than I actually needed, then I could format the cells. (Then I'd go back and get the "extra" cells.) Maybe this would work for you, too. ps. I think I saw the problem with xl97, though. Haven't seen it in a longggg time. In fact, I kept one workbook and just tried it. It worked fine with xl2002. jc wrote: Recurring problem: Selected cells won't respond to formatting. The following problems happen: * Apply Border toolbar shorcut doesn't work. * A right-click from selected cells, choice of FORMAT CELLS... produces no sub-menu * Accessing the main menu Format/Cells... produces no submenu. I had this problem in one part of my sheet and I decided to insert a new leftmost column. After this I could format some cells that now had an empty column to the side. But other areas still don't respond. Pass the clue, please. -jc Using Excel 2000 (Version 5.0.2195 Service Pack 1 Build 2195) -- Dave Peterson ec35720@msn.com |
| 1253 | I am having a problem with Excel 2000 When I receive a spreadsheet from a Excel 200 colleague I cannot access any buttons in the workbook. As I pass the pointer over the command button object, the cross turns to a arrow as if it should be selectable, but clicking does nothing. My security is set to low level. As a further test, I created a new worksheet and tried to create a button from the controls toolbox. I received an error message stating "Cannot insert object" I received the same message trying option button, radio buttons, etc. However, I am able to insert and attach macros to buttons added from the forms toolbox. I am confused, any ideas? I have tried reinstalling excel to see if it helps, but to no avail. It seems to be related to ActiveX controls only. I would look for any help anyone can offer. I am running windows 2000 pro on my laptop. |
| 1254 | Dave, Thanks for this tip. I turned off this error check and it immediately resolved my problem, including the problem when importing to Access. Bill "" <DavidH@OzGrid.com wrote in message news:6o7U8.18$tm.19011@vicpull1.telstra.net... Hi Bill ToolsOptionsError Checking. You can record a macro toggling the options to get the code. -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "Bill Murphy" <wmurphy@NO*SPAM!houston.rr.com wrote in message news:377U8.25029$p85.681329@twister.austin.rr.com... | I have a spreadsheet that was created in Excel 2000 which displays an error | condition, but only when opened in Excel 2002. Some cells containing | numbers are displayed with a small green triangle in the upper left corner | of the cell. When you place your mouse pointer in this cell an error box | appears to the left of the cell which contains an exclamation point and a | drop down menu. The drop down menu tells you that you have a number in the | cell which has been stored as text, and asks whether you want to correct | this "error" by converting it to a number. Once you do this the green | triangle is removed, and you are presumably okay. | | I opened a new spreadsheet in 2002 and pre-formatted a cell to text before | entering a number. The green triangle appeared, and reformatting the cell | to general or number did not make it go away. You have to fix the "error" | with the special drop down box to the left of the cell. However, if you | format a cell as text after a number has been entered into it using general | or number format this error does not occur. | | I also encountered this problem when trying to import this spreadsheet into | Access 2000. These cells cause an import error to occur - error 3349 | numeric overflow. Once the "error" cells are fixed this import error | disappears. | | Is anyone aware of a general fix for this problem by way of a service pack | for Excel 2002? | | Bill | | |
| 1267 | ...or you can do it with a Macro if you want the original cell changed without the help of a formula. Sub UPPER() Dim c As Range For Each c In Selection c.Formula = UCase$(c.Formula) Next End Sub Sub lower() Dim c As Range For Each c In Selection c.Formula = LCase$(c.Formula) Next End Sub Sub Proper() Dim c As Range For Each c In Selection c.Formula = StrConv(c.Formula, vbProperCase) Next End Sub The lack of this feature will seem strange to Word users, but remember that Excel is a math tool, and "a" does not necessarily equal "A" in mathematics. HTH. Best wisshes Harald "murray" <murray.hall@markelintl.com.au wrote in message news:13fdb01c2214f$531ba990$9ae62ecf@tkmsftngxa02... Hi,is there a way to change case in excel. I know it can be done in Word. I'm using Excel 2000. Thanks in advance Murray |
| 1287 | I attempt to load MS Excel 2000 in Windows 98 and I all that I get is the Excel application with menu bars and scroll bars (right & bottom) and nothing else. The mouse pointer resembles an hour glass and the program does nothing (bascially freezes). I have checked the task manager each time and it says that Excel is not responding. I have also tried to open an existing spreadsheet but get the same results. What is really odd is that I never have had this problem in 18 months. Likewise, I have reinstalled MS Office 2000 with no success. Can anyone help me?? Regards Matthew |
| 1291 | Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W |
| 1292 | Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W |
| 1293 | Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W |
| 1294 | Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W |
| 1295 | Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W |
| 1296 | Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W |
| 1298 | I have resolved the problem, please refer to the Excel, Crashes & GPFs folder. -----Original Message----- I attempt to load MS Excel 2000 in Windows 98 and I all that I get is the Excel application with menu bars and scroll bars (right & bottom) and nothing else. The mouse pointer resembles an hour glass and the program does nothing (bascially freezes). I have checked the task manager each time and it says that Excel is not responding. I have also tried to open an existing spreadsheet but get the same results. What is really odd is that I never have had this problem in 18 months. Likewise, I have reinstalled MS Office 2000 with no success. Can anyone help me?? Regards Matthew . |
| 1302 | what kind of symbols? you might try a Character Map in Start-Programs-Accessories-System Tools-... keyboard shortcuts work also in Excel Uzytkownik "Winston Rietmuller" <wrietmuller@cs.co.za napisal w wiadomosci news:1461601c221c2$6785cff0$9be62ecf@tkmsftngxa03... Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W |
| 1304 | --------------6143CC8B788D6C6A0E64B596 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi Winston, Many symbols can be inserted with ALT+0nnn. Thus ALT+0186 give degree symbol (=BA). You must use the numberic keypad. For Greek letters, insert Roman letter and format with symbol - you can format a sinlge character in a cell. Thus D gives D. Best wishes Beranrd Winston Rietmuller wrote: Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W --------------6143CC8B788D6C6A0E64B596 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" <HTML Hi Winston, <BRMany symbols can be inserted with ALT+0nnn. Thus ALT+0186 give degree symbol (º). You must use the numberic keypad. For Greek letters, insert Roman letter and format with symbol - you can format a sinlge character in a cell. Thus D gives <FONT FACE="Symbol"D.</FONT <BR<FONT FACE="Times New Roman,Times"Best wishes</FONT <BR<FONT FACE="Times New Roman,Times"Beranrd</FONT <PWinston Rietmuller wrote: <BLOCKQUOTE TYPE=CITEHi <PA client recently enquired how to insert a symbol, as <BRused in Word 2000 into an Excel 2000 spreadsheet. She <BRsays she has unsucessfully tried copying and pasting from <BRWord. <BRThe symbols used will be of an engineering/scientific <BRnature. <BRPlease advise whether this is possible and the steps to <BRfollow. <PThanks and regards <PW</BLOCKQUOTE </HTML --------------6143CC8B788D6C6A0E64B596-- |
| 1305 | 1. Go to cell A1 in your worksheet and key this: =CHAR(ROW()) 2. Drag this formula down to cell A255. 3. Select the column and format as Wingdings. HTH Jason Atlanta, GA -----Original Message----- Hi A client recently enquired how to insert a symbol, as used in Word 2000 into an Excel 2000 spreadsheet. She says she has unsucessfully tried copying and pasting from Word. The symbols used will be of an engineering/scientific nature. Please advise whether this is possible and the steps to follow. Thanks and regards W . |
| 1308 | Hi I want to protect a sheet that has a group/outline in it. Protecting the sheet works fine, but then I can't ungroup/un-outline any more. This is in Excel 2000. A solution is welcome. Stefan |
| 1311 | From the help: ActiveSheet.EnableOutlining = True ActiveSheet.Protect contents:=True, userInterfaceOnly:=True But it has to be reset each time you open the workbook. Maybe you could add it to your auto_Open/workbook_open macro. microsoft wrote: Hi I want to protect a sheet that has a group/outline in it. Protecting the sheet works fine, but then I can't ungroup/un-outline any more. This is in Excel 2000. A solution is welcome. Stefan -- Dave Peterson ec35720@msn.com |
| 1323 | Has anyone any idea why the clipboard would be missing on one of our machines in the office? Is it an option? All of our machines run Excel 2000, but on one of them, you cannot copy and paste multiple items! What's going on..? Cheers, Ben |
| 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 |
| 1431 | I'd like sources with information on writing web queries. First objective is to retrieve stock price history data from /d I want to learn to build a query that will cycle through a worksheet listing of ticker synbols with start and end dates and pull price histories into worksheets where I can manipulate and analyze the data for volatility, etc. Excel 2000 Windows 2K PRO TIA |
| 1434 | Hello, I am using Excel 2000. I have a protected sheet, with a password. I recorded a macro and included uprotecting the sheet, typing in the password. But when I run the macro, I am prompted for the password. As I don't want the user to have the password, is there a way I can overcome this so the macro runs and in donig so unprotects the password-protected sheet, then protects it again with the same password? Thank you very much. Billy |
| 1436 | Hi Billy, Try this Sub ProtecTest() ActiveSheet.UnProtect Password:="Drowssap" [code to do stuff] ActiveSheet.Protect Password:="Drowssap" End Sub HTH "Billy Thomas" <bthomas@gcronline.com wrote in message news:ehYlFGsICHA.1604@tkmsftngp12... Hello, I am using Excel 2000. I have a protected sheet, with a password. I recorded a macro and included uprotecting the sheet, typing in the password. But when I run the macro, I am prompted for the password. As I don't want the user to have the password, is there a way I can overcome this so the macro runs and in donig so unprotects the password-protected sheet, then protects it again with the same password? Thank you very much. Billy |
| 1451 | In the destination cell, enter the SUM function (sigma tool). It will by default select certain cells. In the formula, between the ( ), delete whatever it selects and replace it with the addresses of the cells to be included in the total (click on each cell in turn). Separate each with a comma. Your formula should look something like this: =SUM(A3,B4,C5,D6,E7). Another way to do it is as follows: =A3+B4+C5+D6+E7. Since you aren't using a function you don't need ( ). But this sounds like what you tried to do and didn't like. "Edward" <strott@charis.co.uk wrote in message news:15fae01c222cb$19f24b10$35ef2ecf@TKMSFTNGXA11... I want to add together the values shown in various unconnected cells, and place the result in a chosen destination cell. When using Excel on my old Mac I would start by first inserting the equal (=)sign in a destination cell, and then click in sequence each cell containing a value, finally clicking the Tick/Acceptsign on the menu bar. But when I do this on my new PC with Excel 2000(by trying to aggregate each of the value cells by clicking in sequence)the destination cell only includes the value shown in the LAST cell clicked. i.e it ignores the other cells previously clicked.!! HOW CAN I DO THIS WITHOUT HAVING TO LABORIOUSLY PRESS THE 'ADD' button each time I click a cell??? Help! |