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
| 1452 | I usually type =sum( then use the mouse to point at a cell, then with my left hand hovering over the comma, I hit the comma. Then I point to the next cell. (and so on). If you're not using =sum() (maybe just =a1+b9+c13+d99), then maybe you can add the "+" icon to a spot close to the formula bar. Then =PointAtCe11-1(click + Icon)pointatcell-2...etc. The "+" icon can be found under Tools|customize|Commands Tab|Insert Category| (a little more than halfway down (xl2002)). Edward wrote: 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! -- Dave Peterson ec35720@msn.com |
| 1497 | If you have Excel 2000 or Excel 2002, you could use the Worksheet_Change event to create dynamic lists with advanced filters. For example, selecting a department in column A on the Project Tasks sheet, could create a unique list of projects for that department, by using the department name as criteria for the advanced filter. If the list were created in column M, the range would be named ProjList, and refer to: =OFFSET(Projects!$M$1,1,0,COUNTA(Projects!$M$1:$M$100)-1,1) The event code on the Project Tasks worksheet would be: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then With Worksheets("Projects") .Range("I2").Value = Target.Value Range("A1").Select .Range("L:M").Clear .Range("A1:B" & .Cells(Rows.Count, "B").End(xlUp).Row) _ .AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=.Range("I1:I2"), _ CopyToRange:=.Range("L1"), Unique:=True End With End If End Sub You could use a similar technique to create a list of applicable tasks. Tony Starr wrote: Thanks Dave, Debra's solution works nicely for predefined lists, however in my chase the lists are dynamic and I do not think Debra's solution would work. Regards Tony "Dave Peterson" <ec35720@msn.com wrote in message news:3D2447AB.B8A37847@msn.com... Take a look at Debra Dalgleish's web site: /xlDataVal01.html and /xlDataVal02.html You should be able to expand on her notes. (IIRC, she only goes 2 deep.) Tony Starr wrote: Hi Folks, I need some help with implementing data validation lists. I want to have a validation list for column B that is based upon the value the user selects in column A and a validation list in Column C that depends on the choices made in columns A and B. On a sheet named Projects users enter the details of people working on Projects The sheet looks like this Department Project Person Accounts Payroll System John Smith Accounts Payroll System Helen Brown Accounts Debt Recovery Allan Welling Despatch New Loading Bay Mike Lang Despatch New Loading Bay Sharon Stone HR Leave System John Smith HR Leave System Mike Lang HR Training Jodi Rich (It is possible that two departments may have a project of the same name) The values entered in the Department Column are from a predefined list. The values entered in the Project and Person columns are user defined. (i.e. absolutely anything) My "Project Tasks" Sheet looks like this Department Project Person Task Accounts Payroll System John Smith Scoping Accounts Payroll System John Smith Planning Accounts Payroll System John Smith Purchase Accounts Payroll System Helen Brown Installation I want the values entered in the Department, Project and Person columns to be picked from a validation list. If the user selects Accounts in the Department column, the validation list for Project Column should consist of only projects entered on the "Projects" sheet against the Accounts department. Likewise the validation list for the Person column should only consist of people listed in the "Projects" sheet for the nominated department/project. How do I do this? (Just stressing again I do not know in advance the values the users will be entering as Projects and Persons on the "Projects" sheet.) TIA Tony -- Dave Peterson ec35720@msn.com -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 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 |
| 1583 | I'm trying to find out whether Excel 2000 (not Excel 2002 from Office XP) can be integrated with XML Web Services. Many thanks, Ian |
| 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 |
| 1642 | I wonder if anyone has had a similar problem. I am running excel 2000 on Windows98 on a Pentium 400 laptop with 128mb memory. It has been running fine for months. In the last few days I have a 'not enough memory' message when opening a 2nd excel file. Usually I have 6 to 12 files open at the same time with no problem, in the same excel session. When I have this problem, the file already open shows calculate, although the file is set to automatic calculation. I can open the 2nd file in a 2nd excel session (by un ticking ignore other applications), but do not want to do this as I can not then link files and I do not want all the excel files having a button in the task bar. I have looked at google groups and several web pages that were suggested but to no avail. Any ideas gratefully received. Barbara |
| 1646 | Can't say why you are getting out of memory, but for the calculate: /search/preview.aspx?scid=kb;en-us;Q243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References (Q243495) If you have buttons and other objects on your worksheet and you have the zoom at other than 100%, this can cause memory errors. Perhaps you are just running out of resources. Barbara wiseman <b@nbpwiseman.fsnet.co.uk wrote in message news:Owc98XcJCHA.2488@tkmsftngp09... I wonder if anyone has had a similar problem. I am running excel 2000 on Windows98 on a Pentium 400 laptop with 128mb memory. It has been running fine for months. In the last few days I have a 'not enough memory' message when opening a 2nd excel file. Usually I have 6 to 12 files open at the same time with no problem, in the same excel session. When I have this problem, the file already open shows calculate, although the file is set to automatic calculation. I can open the 2nd file in a 2nd excel session (by un ticking ignore other applications), but do not want to do this as I can not then link files and I do not want all the excel files having a button in the task bar. I have looked at google groups and several web pages that were suggested but to no avail. Any ideas gratefully received. Barbara |
| 1660 | I have a rather large project catalog in excel that I have cleaned up and will later send to Acrobat for printing - I however only have excel 2000 - which as far as I can tell i can not import the company logo as a footer - is there anyway I can do this with excel 2000 - It looks as though excel 2002 has this option thanks |
| 1677 | Hello. I am using Excel 2000 and need a macro to produce a sum. All the numbers are in column 'H', and the columns to either side of H contain numbers also that I do not want summed. The rows that the numbers to be summed are in, along with the row where the sum should go, change as data is added. That is, I might want to place the sum for rows 5 - 8 in row 10, then the next time place the sum for rows 14-21 in row 23, etc, with the sum always being 2 rows below the last number being summed. I tried to record using autosum but the result was not useable. CurrentRegion doesnt seem to be the answer either since there is data in neighboring columns that I dont want to include. Thanks for the help. Billy |
| 1681 | Yes, although I advice you to install the oldest version first. I have Excel 2000 and 2002 on the same computer -- Regards, Peo Sjoblom "Nikiahc" <none wrote in message news:3d28e4a4@snipnews.snip.net... Can I have two versions installed at the same time? |
| 1682 | Weird bug: I have a spreadsheet (Excel 2000) which I use regularly that no longer allows me to enter negative numbers as, e.g. -3. As soon as I hit the 3 key (after the -), whether KP or not, the - becomes a long dash, and the spreadsheet does not recognize the value in the cell as a number). The only way I can enter negative numbers is by use of parentheses (e.g. (3.2)). This is very annoying...anyone know how to fix? Presumably I hit some stupid key combination at some point? Many thanks in advance, Mark Evans |
| 1686 | This sounds like someone (you?) was playing with the Autocorrect options. Click on Tools|Autocorrect Options... Then either type a hypen in the replace box or scroll down until you find it. If it's there, click on the delete button. I believe that the autocorrect stuff is shared throughout office. Maybe you made the change in word and forgot about it. Mark Evans wrote: Weird bug: I have a spreadsheet (Excel 2000) which I use regularly that no longer allows me to enter negative numbers as, e.g. -3. As soon as I hit the 3 key (after the -), whether KP or not, the - becomes a long dash, and the spreadsheet does not recognize the value in the cell as a number). The only way I can enter negative numbers is by use of parentheses (e.g. (3.2)). This is very annoying...anyone know how to fix? Presumably I hit some stupid key combination at some point? Many thanks in advance, Mark Evans -- Dave Peterson ec35720@msn.com |
| 1688 | with excel open, look in tools=Options in the general tab and make sure Ignore Other Applications is not checked. If that doesn't fix it, make sure Excel is closed, then go to the start menu in windows and select run Put in Excel.Exe /regserver Then click OK. This should refresh excel's registry entries. Bob Kneebone <bob.kneebone@delter.com.cn wrote in message news:ewmEAviJCHA.1600@tkmsftngp13... Using Excel 2000 and double clicking on a file in a folder it reports "cannot find file.xls or one of its components. Using File Open from the Excel menu it is fine. Any ideas??? -- Please Reply to bob.kneebone@delter.com.cn Visit our WebSite at Visit our Chinese site at |
| 1692 | Debra, Thank you for an elegant solution. Regards Tony "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D24D8FA.6030805@contextures.com... If you have Excel 2000 or Excel 2002, you could use the Worksheet_Change event to create dynamic lists with advanced filters. For example, selecting a department in column A on the Project Tasks sheet, could create a unique list of projects for that department, by using the department name as criteria for the advanced filter. If the list were created in column M, the range would be named ProjList, and refer to: =OFFSET(Projects!$M$1,1,0,COUNTA(Projects!$M$1:$M$100)-1,1) The event code on the Project Tasks worksheet would be: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then With Worksheets("Projects") .Range("I2").Value = Target.Value Range("A1").Select .Range("L:M").Clear .Range("A1:B" & .Cells(Rows.Count, "B").End(xlUp).Row) _ .AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=.Range("I1:I2"), _ CopyToRange:=.Range("L1"), Unique:=True End With End If End Sub You could use a similar technique to create a list of applicable tasks. Tony Starr wrote: Thanks Dave, Debra's solution works nicely for predefined lists, however in my chase the lists are dynamic and I do not think Debra's solution would work. Regards Tony "Dave Peterson" <ec35720@msn.com wrote in message news:3D2447AB.B8A37847@msn.com... Take a look at Debra Dalgleish's web site: /xlDataVal01.html and /xlDataVal02.html You should be able to expand on her notes. (IIRC, she only goes 2 deep.) Tony Starr wrote: Hi Folks, I need some help with implementing data validation lists. I want to have a validation list for column B that is based upon the value the user selects in column A and a validation list in Column C that depends on the choices made in columns A and B. On a sheet named Projects users enter the details of people working on Projects The sheet looks like this Department Project Person Accounts Payroll System John Smith Accounts Payroll System Helen Brown Accounts Debt Recovery Allan Welling Despatch New Loading Bay Mike Lang Despatch New Loading Bay Sharon Stone HR Leave System John Smith HR Leave System Mike Lang HR Training Jodi Rich (It is possible that two departments may have a project of the same name) The values entered in the Department Column are from a predefined list. The values entered in the Project and Person columns are user defined. (i.e. absolutely anything) My "Project Tasks" Sheet looks like this Department Project Person Task Accounts Payroll System John Smith Scoping Accounts Payroll System John Smith Planning Accounts Payroll System John Smith Purchase Accounts Payroll System Helen Brown Installation I want the values entered in the Department, Project and Person columns to be picked from a validation list. If the user selects Accounts in the Department column, the validation list for Project Column should consist of only projects entered on the "Projects" sheet against the Accounts department. Likewise the validation list for the Person column should only consist of people listed in the "Projects" sheet for the nominated department/project. How do I do this? (Just stressing again I do not know in advance the values the users will be entering as Projects and Persons on the "Projects" sheet.) TIA Tony -- Dave Peterson ec35720@msn.com -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 1696 | Debra. That works fine! Thank you so very very much! Billy Billy Thomas <bthomas@gcronline.com wrote in message news:#1bnq6gJCHA.2272@tkmsftngp09... Hello. I am using Excel 2000 and need a macro to produce a sum. All the numbers are in column 'H', and the columns to either side of H contain numbers also that I do not want summed. The rows that the numbers to be summed are in, along with the row where the sum should go, change as data is added. That is, I might want to place the sum for rows 5 - 8 in row 10, then the next time place the sum for rows 14-21 in row 23, etc, with the sum always being 2 rows below the last number being summed. I tried to record using autosum but the result was not useable. CurrentRegion doesnt seem to be the answer either since there is data in neighboring columns that I dont want to include. Thanks for the help. Billy |
| 1702 | Billy, You're welcome. Thanks for letting me know. Debra Billy Thomas wrote: Debra. That works fine! Thank you so very very much! Billy Billy Thomas <bthomas@gcronline.com wrote in message news:#1bnq6gJCHA.2272@tkmsftngp09... Hello. I am using Excel 2000 and need a macro to produce a sum. All the numbers are in column 'H', and the columns to either side of H contain numbers also that I do not want summed. The rows that the numbers to be summed are in, along with the row where the sum should go, change as data is added. That is, I might want to place the sum for rows 5 - 8 in row 10, then the next time place the sum for rows 14-21 in row 23, etc, with the sum always being 2 rows below the last number being summed. I tried to record using autosum but the result was not useable. CurrentRegion doesnt seem to be the answer either since there is data in neighboring columns that I dont want to include. Thanks for the help. Billy -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 1708 | I have an Excel 2000 file that won't open. It says the file format is incorrect. It is a shared network file, and everyone that is using it uses Excel 2000. The only info I can find from MS says that e-mail routing (?) or different versions of Excel have been used to open it. I don't believe either of these apply. I can open it with Word, but I only get one workbook. Any ideas that I can try to open it? |
| 1710 | Hello to All I have come up with a problem and would like to know if anyone else has run into this.When two people try to access an Excel file at the same time. Normally when a second user tries to open an Excel file that is already open the second user gets a message that the file is "in use, would they like to open a copy". When a person opens a file first and I try to open the same file, I get that warning message - good thing. When I open the file first, Cindy gets no message when she tries to open it - dangerous. Cindy is running Excel 2000, I am running Excel 2002. This is a big problem for us, is this an Excel 2002 compatibility problem. Thank You for you advice Brenda |
| 1823 | See if it opens in word -- if so -- most likely someone opened in word and saved it "JoeyGee" <Joseph.Gillen@Aquila.com wrote in message news:17c3401c22772$935a2a30$35ef2ecf@TKMSFTNGXA11... : Microsoft. The file resides on a WINNT 4.0 file server, : and all clients are WINNT 4.0 running Office 2000. : : Do you have a fix for your issue? : : -----Original Message----- : : -----Original Message----- : Please excuse the repost... : : I have an Excel 2000 file that won't open. It says the : file format is incorrect. It is a shared network file, : and : everyone that is using it uses Excel 2000. The only info : I : can find from MS says that e-mail routing (?) or : different : versions of Excel have been used to open it. I don't : believe either of these apply. : : I can open it with Word, but I only get one workbook. : Any : ideas that I can try to open it? : : . : : : What is your network software? Microsoft or Novell? : I have a similar problem with Novell. : : . : |
| 1828 | I can open it in Word if I right click and do an OPEN WITH, but it only has info from one workbook, and not 4. I can do the same with Power Point. -----Original Message----- See if it opens in word -- if so -- most likely someone opened in word and saved it "JoeyGee" <Joseph.Gillen@Aquila.com wrote in message news:17c3401c22772$935a2a30$35ef2ecf@TKMSFTNGXA11... : Microsoft. The file resides on a WINNT 4.0 file server, : and all clients are WINNT 4.0 running Office 2000. : : Do you have a fix for your issue? : : -----Original Message----- : : -----Original Message----- : Please excuse the repost... : : I have an Excel 2000 file that won't open. It says the : file format is incorrect. It is a shared network file, : and : everyone that is using it uses Excel 2000. The only info : I : can find from MS says that e-mail routing (?) or : different : versions of Excel have been used to open it. I don't : believe either of these apply. : : I can open it with Word, but I only get one workbook. : Any : ideas that I can try to open it? : : . : : : What is your network software? Microsoft or Novell? : I have a similar problem with Novell. : : . : . |
| 1829 | Sorry, unless you have a backup somewhere the file is basically lost, or rather 3 out of 4 sheets.. I'd suggest you get a tool like autosafe by Jan Karel Pieterse /mvp/ -- Regards, Peo Sjoblom "JoeyGee" <Joseph.Gillen@Aquila.com wrote in message news:1494701c22787$e4dea560$2ae2c90a@hosting.microsoft.com... I can open it in Word if I right click and do an OPEN WITH, but it only has info from one workbook, and not 4. I can do the same with Power Point. -----Original Message----- See if it opens in word -- if so -- most likely someone opened in word and saved it "JoeyGee" <Joseph.Gillen@Aquila.com wrote in message news:17c3401c22772$935a2a30$35ef2ecf@TKMSFTNGXA11... : Microsoft. The file resides on a WINNT 4.0 file server, : and all clients are WINNT 4.0 running Office 2000. : : Do you have a fix for your issue? : : -----Original Message----- : : -----Original Message----- : Please excuse the repost... : : I have an Excel 2000 file that won't open. It says the : file format is incorrect. It is a shared network file, : and : everyone that is using it uses Excel 2000. The only info : I : can find from MS says that e-mail routing (?) or : different : versions of Excel have been used to open it. I don't : believe either of these apply. : : I can open it with Word, but I only get one workbook. : Any : ideas that I can try to open it? : : . : : : What is your network software? Microsoft or Novell? : I have a similar problem with Novell. : : . : . |
| 1835 | I am working with a large Excel 2000 file with a lot of graphs. Whenever I try to alter the chart titles or print the charts in this file, I get the following error message: No more new fonts may be applied in this workbook. Can you tell me what is causing this error message, and how I can fix this file? Thanks for your help, Kyle Garcia |
| 1855 | From someone who has never had to work with support for international users: It sounds like Windows Regional settings are slightly different. Under Win98, you can see the settings by: Start|Settings|control panel|Regional Settings Applet|Number Tab. I'd check list "list separator", "decimal symbol" and anything you can tell from the differences in the fields. Good luck, Clive Pocock wrote: Does anyone know what could cause a variation in CSV output? We have an application accessible through a browser (in this case IE 6.00) which outputs a csv file that theoretically can be imported into Excel 2000. We are finding our Spanish office gets a different output depending on which machine they use.# Thanks in advance -- Dave Peterson ec35720@msn.com |
| 1865 | I am using excel 2000, every time I open a new or existing worksheet the column Labels are 1-999999 as are the rows. How can I make the colum names read A, B, C...like they used to? |
| 1867 | Go to the Tools menu, select Options, select the View tab. Check the box in Window Options for Row and Column Headers. Regards, Greg "Regina" <Regi1226@cs.com wrote in message news:149f901c2279f$b1283200$2ae2c90a@hosting.microsoft.com... I am using excel 2000, every time I open a new or existing worksheet the column Labels are 1-999999 as are the rows. How can I make the colum names read A, B, C...like they used to? |
| 1882 | Or if Greg's solution does not do the job then Go to the Tools menu, select Options and select the General tab. Uncheck the box in the Settings Options marked R1C1 reference style.. Regards William willwest22@yahoo.com "Greg Koppel" <gregkoppel@hotmail.com wrote in message news:O5wV1C6JCHA.2400@tkmsftngp08... | Go to the Tools menu, select Options, select the View tab. Check the box in | Window Options for Row and Column Headers. | | Regards, Greg | | "Regina" <Regi1226@cs.com wrote in message | news:149f901c2279f$b1283200$2ae2c90a@hosting.microsoft.com... | I am using excel 2000, every time I open a new or existing | worksheet the column Labels are 1-999999 as are the rows. | How can I make the colum names read A, B, C...like they | used to? | | |
| 1900 | Kyle, I am having the same problem! I have writen to Microsoft, but have had no responce. If I find the answer I will let you know. "Kyle Garcia" <kyle@trugmanvaluation.com wrote in message news:16b1801c2278d$2a2d7790$19ef2ecf@tkmsftngxa01... I am working with a large Excel 2000 file with a lot of graphs. Whenever I try to alter the chart titles or print the charts in this file, I get the following error message: No more new fonts may be applied in this workbook. Can you tell me what is causing this error message, and how I can fix this file? Thanks for your help, Kyle Garcia |
| 1903 | "Kevin" <khunter2@ford.com wrote in message news:aggn6s$18f5@eccws12.dearborn.ford.com... I keep getting an error message " no more new fonts may be applied to this workbook " Q1) Can the number of fonts allowed be increased ? Q2) How many am I allowed ? Q3) Will Excel XP allow me more ? Any help would be appreciated. Kevin, I experienced similar problems, when I had approx 150 charts in one workbook and tried to modify their fonts. Not sure if your case is similar, but here's a post from Trevor Shuttleworth that helped me out. I vaguely recall that the workaround in my case was to disable the font size autoscale thingy. HTH Jouni "Trevor Shuttleworth" <Trevor@shucks.demon.co.uk wrote in message news:uQOKo40BCHA.864@tkmsftngp04... Jouni From TechNet ... PSS ID Number: Q215573 Article last modified on 10-26-2000 WINDOWS:2000 ====================================================================== -------------------------------------------------------------------------- -- --- The information in this article applies to: - Microsoft Excel 2000 -------------------------------------------------------------------------- -- --- SYMPTOMS ======== When you copy a worksheet with embedded chart objects several times, you may receive the following error message: No more new fonts may be applied in this workbook. When you click OK to clear the error message, you may receive the following error message: Cell table Integrity failure. CAUSE ===== This problem may occur if all of the following are true: - You created a chart object in the worksheet. -and- - The chart object contains a title. -and- - You pasted a chart object on the same worksheet ten or more times. -and- - You copied the worksheet several times in the same workbook. WORKAROUND ========== To workaround this behavior, use either of the following methods. Method 1: Disable Autoscaling in the Chart ------------------------------------------ 1. Select the chart. 2. On the Format menu, click Selected Chart Area. 3. Click the Font tab. 4. Click to clear the Autoscale check box. 5. Click OK. Method 2: Split the Number of Charts into Multiple Workbooks ------------------------------------------------------------ STATUS ====== Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. Additional query words: XL2000 ====================================================================== Keywords : kbdta Version : WINDOWS:2000 Issue type : kbbug Solution Type : kbpending ============================================================================ = Copyright Microsoft Corporation 2000. Regards Trevor "Jouni" <asd.asd@asd.asd wrote in message news:ot9J8.5703$ws6.121035@news2.nokia.com... Hi, my problem seems unambiguous and maybe there's no cure for it. Anyway, I've got five workbooks in total: four having charts on several worksheets, and one that is used to collate the charts. That is, I copy each of the charts one by one (using macros, of course) and paste them into the fourth workbook. Because the charts tend to change a bit when pasted, I have to format axes (font sizes & types, and date-format). The problem is that I end up having appr 150 charts on one sheet, and that's apparently too much for Excel2000 because I get a message "Unable to set the Size property of the Font class". If I try to change any fonts manually, I get a message saying: "No more new fonts may be applied in this workbook." Any ideas how to overcome this? I've tried to format the charts before pasting them as _pictures_, but it didn't help because the fonts are still messed up and then, having the charts as pictures, the fonts are definitely untouchable. It's a little irritating that I have to send out a report that has fonts of size 3.75... Any help appreciated. Cheers, Jouni |
| 2188 | Debra Could I get a copy of that sample file? Thanks. Otto "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D2F6040.4000305@contextures.com... In Excel 2000 or Excel 2002 you can create a simple version of this by using a cell with Data Validation on the user entry page, from which you could select a category. By using the Worksheet_Change event, you could run an Advanced Filter, to extract a list of items in the selected category. The full list of items could be stored on a hidden sheet. If you like, I can email you a sample file. Jeff wrote: Anyone knows how to do a simple database or might have an example of a item database in Excel? What I'm looking for is a database of items and the user opens the database and types in a wildcard search for (let's Say) Cereal. The spreadsheet would then clear the screen and show all the different types of cereal that I have made in the database. The database would be a listing of all products in the grocery store. The entire database would be hidden at all times except the items in the search. In the workbook, one sheet would hold all the entire database but I would like the first worksheet or template to house the user entry page and display the output? I know access is capable but someone mentioned I should be able to do this in Excel? Any suggestions would be greatly appreciated. Thank You. Jeff email me at jeff.keefner@az.ngb.army.mil -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2190 | Hi Otto, I put a copy on my web site: /excelfiles.html Under the heading -- 'Sample Excel Spreadsheets' -- look for 'Product List by Category'. The sample file (35 kb) is named ProductsList.xls If you have any trouble with it, let me know. Debra Otto Moehrbach wrote: Debra Could I get a copy of that sample file? Thanks. Otto "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D2F6040.4000305@contextures.com... In Excel 2000 or Excel 2002 you can create a simple version of this by using a cell with Data Validation on the user entry page, from which you could select a category. By using the Worksheet_Change event, you could run an Advanced Filter, to extract a list of items in the selected category. The full list of items could be stored on a hidden sheet. If you like, I can email you a sample file. Jeff wrote: Anyone knows how to do a simple database or might have an example of a item database in Excel? What I'm looking for is a database of items and the user opens the database and types in a wildcard search for (let's Say) Cereal. The spreadsheet would then clear the screen and show all the different types of cereal that I have made in the database. The database would be a listing of all products in the grocery store. The entire database would be hidden at all times except the items in the search. In the workbook, one sheet would hold all the entire database but I would like the first worksheet or template to house the user entry page and display the output? I know access is capable but someone mentioned I should be able to do this in Excel? Any suggestions would be greatly appreciated. Thank You. Jeff email me at jeff.keefner@az.ngb.army.mil -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2215 | The samples on your site are great, many thanks Joan "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D3049C5.6030206@contextures.com... Hi Otto, I put a copy on my web site: /excelfiles.html Under the heading -- 'Sample Excel Spreadsheets' -- look for 'Product List by Category'. The sample file (35 kb) is named ProductsList.xls If you have any trouble with it, let me know. Debra Otto Moehrbach wrote: Debra Could I get a copy of that sample file? Thanks. Otto "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D2F6040.4000305@contextures.com... In Excel 2000 or Excel 2002 you can create a simple version of this by using a cell with Data Validation on the user entry page, from which you could select a category. By using the Worksheet_Change event, you could run an Advanced Filter, to extract a list of items in the selected category. The full list of items could be stored on a hidden sheet. If you like, I can email you a sample file. Jeff wrote: Anyone knows how to do a simple database or might have an example of a item database in Excel? What I'm looking for is a database of items and the user opens the database and types in a wildcard search for (let's Say) Cereal. The spreadsheet would then clear the screen and show all the different types of cereal that I have made in the database. The database would be a listing of all products in the grocery store. The entire database would be hidden at all times except the items in the search. In the workbook, one sheet would hold all the entire database but I would like the first worksheet or template to house the user entry page and display the output? I know access is capable but someone mentioned I should be able to do this in Excel? Any suggestions would be greatly appreciated. Thank You. Jeff email me at jeff.keefner@az.ngb.army.mil -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2236 | Whenever I close Excel it locks my system and I have to reboot. This just started. I have been using Excel 2000 on this machine for two years. Do I have a virus? |
| 2276 | Hey, What I would do is re-install Excel, that might fix the problem. For the virus issue, an anti-virus program should tell you if the problem is a virus. Good day, Pierre -----Original Message----- Whenever I close Excel it locks my system and I have to reboot. This just started. I have been using Excel 2000 on this machine for two years. Do I have a virus? . |
| 2277 | I am using Excel 2000 in office professional. I am wondering why when I open more than one excel file they do not open in their own new windows. I thought 2000 fixed the problem of opening files in the same window. Is there a setting that I don't have set properly? I am running the software on Windows 2000. Microsoft Word opens files in multiple windows. Please help! |
| 2323 | This describes your problem: XL2000: AutoSave Settings Are Not Retained Between Sessions of Excel 2000 (Q231117) /default.aspx?scid=kb;EN-US;q231117 "Roger L. Waer" wrote: I've installed the Autosave Add-In for excel 2000 and it defaults to saving the active workbook only, every 10 minutes and prompting me before autosaving. This is NOT what I want. Is there a way to change the default settings permanently? I'm tired of changing them every time I start excel! Thanks in advance. Roger L. Waer -- Dave Peterson ec35720@msn.com |
| 2350 | Hi David, AVERAGE formula is precisely doing that (Excel 2000). It is summing up all numeric values and then dividing it by the number of numeric entries in the range. I have posted the reply after testing it in my copy of Excel 2000. Please post back, I might be missing something! -- Regards, Murthy "" <dmcritchie@msn.com wrote in message news:eLvB#1GLCHA.2372@tkmsftngp11... Hi Terri, Average of numeric entries, including zeros: =SUM(A1:C3)/COUNT(A1:C3) HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Murthy" <murthyavr@hotmail.com wrote in message Supposing A1:A10 is the range. The formula is: =AVERAGE(A1:A10) ..... some of the entries are text and were not to be ..... included in the average of cells that are numeric. [David] "Terri Beth" <Terri01@directvinternet.com wrote in message news:18a7d01c22c68$dbe739a0$9ae62ecf@tkmsftngxa02... How can I average a row of cells that contain numbers and text but only get the average of the cells that are number (excluding the text cells). I recently asked this question except my previous question said I had numbers, text, and dates. I was told I couldn't do this with dates included because they are actually numbers. So how can I do it with just numbers and text in a row? Help! |
| 2356 | Hi Murthy, You're correct, they are the same I wasn't paying attention to how I was changing my test data. "Murthy" <murthyavr@hotmail.com wrote in message news:ebhCXOHLCHA.2328@tkmsftngp09... Hi David, AVERAGE formula is precisely doing that (Excel 2000). It is summing up all numeric values and then dividing it by the number of numeric entries in the range. I have posted the reply after testing it in my copy of Excel 2000. Please post back, I might be missing something! -- Regards, Murthy "" <dmcritchie@msn.com wrote in message news:eLvB#1GLCHA.2372@tkmsftngp11... Hi Terri, Average of numeric entries, including zeros: =SUM(A1:C3)/COUNT(A1:C3) HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Murthy" <murthyavr@hotmail.com wrote in message Supposing A1:A10 is the range. The formula is: =AVERAGE(A1:A10) ..... some of the entries are text and were not to be ..... included in the average of cells that are numeric. [David] "Terri Beth" <Terri01@directvinternet.com wrote in message news:18a7d01c22c68$dbe739a0$9ae62ecf@tkmsftngxa02... How can I average a row of cells that contain numbers and text but only get the average of the cells that are number (excluding the text cells). I recently asked this question except my previous question said I had numbers, text, and dates. I was told I couldn't do this with dates included because they are actually numbers. So how can I do it with just numbers and text in a row? Help! |
| 2361 | We try to summary our data from sveral output files into an Excel 2000 file. In some case our ID is "5-9976", but when this data transfer into Excel, it automatically change to "may-76". Its getting annoy if we have several hundreds data to summary. Is there anyway we can make Excel left my text data along and keep what it was? |
| 2401 | Have you tried formatting your cells as text *before* you import your data? HTH RD "WU" <wuxx0153@us.sina.com wrote in message news:18f5201c22c89$f8148030$9be62ecf@tkmsftngxa03... We try to summary our data from sveral output files into an Excel 2000 file. In some case our ID is "5-9976", but when this data transfer into Excel, it automatically change to "may-76". Its getting annoy if we have several hundreds data to summary. Is there anyway we can make Excel left my text data along and keep what it was? |
| 2417 | Unprotect the sheet? It looks like protection for .drawingobjects means for existing drawingobjects. Not new ones. If you're setting up a procedure for someone else, maybe you could have a macro add the picture. And let them move/resize it where they want it (or even plop it down in a selected range and don't let the user change anything...) If you can consider that option, this worked for me: Option Explicit Sub testme1() Dim myPicture As Picture ActiveSheet.Protect DrawingObjects:=False, _ Contents:=True, _ Scenarios:=True, _ UserInterfaceOnly:=True Set myPicture = ActiveSheet.Pictures.Insert( _ "C:\My Documents\My Pictures\test1.JPG") With ActiveSheet.Range("a1:b3") myPicture.Left = .Left myPicture.Width = .Width myPicture.Height = .Height myPicture.Top = .Top End With End Sub Adjust drawingobjects (true/false) according to what you want the user to do. C Mullins wrote: I need to insert a picture into a cell range on a protected sheet. I’m using Excel 2000 and have sheet protection turn on (contents/objects/scenarios) . There is a block of cells d1..h5 that is unlocked, I would like to insert a picture into this cell range. When I goto the first cell in the range d1 (or any of the cells in the range for that matter) and select Insert Picture all options are grayed out. Does some know how to resolve this issue? Thanks in advance for your assistance. C Mullins -- Dave Peterson ec35720@msn.com |
| 2437 | I meant that if you protect the worksheet with .drawingobject = false, then it looks like it allows you to do things with existing objects--not new ones. Dave Peterson wrote: Unprotect the sheet? It looks like protection for .drawingobjects means for existing drawingobjects. Not new ones. If you're setting up a procedure for someone else, maybe you could have a macro add the picture. And let them move/resize it where they want it (or even plop it down in a selected range and don't let the user change anything...) If you can consider that option, this worked for me: Option Explicit Sub testme1() Dim myPicture As Picture ActiveSheet.Protect DrawingObjects:=False, _ Contents:=True, _ Scenarios:=True, _ UserInterfaceOnly:=True Set myPicture = ActiveSheet.Pictures.Insert( _ "C:\My Documents\My Pictures\test1.JPG") With ActiveSheet.Range("a1:b3") myPicture.Left = .Left myPicture.Width = .Width myPicture.Height = .Height myPicture.Top = .Top End With End Sub Adjust drawingobjects (true/false) according to what you want the user to do. C Mullins wrote: I need to insert a picture into a cell range on a protected sheet. I’m using Excel 2000 and have sheet protection turn on (contents/objects/scenarios) . There is a block of cells d1..h5 that is unlocked, I would like to insert a picture into this cell range. When I goto the first cell in the range d1 (or any of the cells in the range for that matter) and select Insert Picture all options are grayed out. Does some know how to resolve this issue? Thanks in advance for your assistance. C Mullins -- Dave Peterson ec35720@msn.com -- Dave Peterson ec35720@msn.com |
| 2440 | I don't think you can. but if you do a file|Open, there's a button on the left hand side that says history. This might be good enough for you. MD King wrote: I would like to expand the ("recent documents") list in Excel 2000 beyond the 9 allowed in the options. How do I accomplish this? , MD King -- Dave Peterson ec35720@msn.com |
| 2472 | Hi Sleurhutje, Really Excel97 is faster than Excel 2002 but nor so fast. Take care with the temp folder and see these MS Kb: /search/preview.aspx?scid=kb;en-us;Q299372 /search/preview.aspx?scid=kb;en-us;Q262530 /search/preview.aspx?scid=kb;en-us;Q210162 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) "Sleurhutje" <sleurhutje@hotmail.com escreveu na mensagem news:OA7S1xQLCHA.2312@tkmsftngp13... Hi, We upgraded our Office 97 Pro to Office 2000 Pro, all options installed on harddisk (in both cases). But after the upgrade many users complain about the speed of Excel 2000. It's remarkably slower then Office 97. All PC's are HP Vectra VL420's with PIII/933MHz, 256MB RAM, 20GB HDD, Win2K Professional SP2 + Hotfixes. Only other application used is a DOS program that starts in a DOS box. But when the complaints start, the users don't use this DOS application. Can this be true? How do I speed up Excel 2000? Thanks, Jeroen. |
| 2478 | I am having an issue when trying to save Excel 2002 documents to a network drive on a Windows 2000 server. When clicking save I get the message "The file 'x.xls' may have been changed by another user since you last saved it. In that case, what do you want...Save a copy or Overwrite changes. If I choose overwrite changes the file saves fine. We have other computers with Excel 2000 on our network and they do not experience this issue, only on the Excel 2002 computers. No one else is trying to access the file. Any ideas on what might be causing this? |
| 2502 | Where would I set .drawingobject =false? -----Original Message----- I meant that if you protect the worksheet with .drawingobject = false, then it looks like it allows you to do things with existing objects--not new ones. Dave Peterson wrote: Unprotect the sheet? It looks like protection for .drawingobjects means for existing drawingobjects. Not new ones. If you're setting up a procedure for someone else, maybe you could have a macro add the picture. And let them move/resize it where they want it (or even plop it down in a selected range and don't let the user change anything...) If you can consider that option, this worked for me: Option Explicit Sub testme1() Dim myPicture As Picture ActiveSheet.Protect DrawingObjects:=False, _ Contents:=True, _ Scenarios:=True, _ UserInterfaceOnly:=True Set myPicture = ActiveSheet.Pictures.Insert( _ "C:\My Documents\My Pictures\test1.JPG") With ActiveSheet.Range("a1:b3") myPicture.Left = .Left myPicture.Width = .Width myPicture.Height = .Height myPicture.Top = .Top End With End Sub Adjust drawingobjects (true/false) according to what you want the user to do. C Mullins wrote: I need to insert a picture into a cell range on a protected sheet. I’m using Excel 2000 and have sheet protection turn on (contents/objects/scenarios) . There is a block of cells d1..h5 that is unlocked, I would like to insert a picture into this cell range. When I goto the first cell in the range d1 (or any of the cells in the range for that matter) and select Insert Picture all options are grayed out. Does some know how to resolve this issue? Thanks in advance for your assistance. C Mullins -- Dave Peterson ec35720@msn.com -- Dave Peterson ec35720@msn.com . |
| 2530 | In a macro that protected the worksheet: ActiveSheet.Protect DrawingObjects:=False, _ Contents:=True, _ Scenarios:=True, _ UserInterfaceOnly:=True Or from Tools|Protection Depending on your version (pre xl2002, I think) had three checkboxes--contents, objects, scenarios that you could protect/leave unprotected. In xl2002, there's an option at the bottom of the "allow all users of this worksheet to" box that shows "edit objects". But this alone won't allow you to add new pictures. C Mullins wrote: Where would I set .drawingobject =false? -----Original Message----- I meant that if you protect the worksheet with .drawingobject = false, then it looks like it allows you to do things with existing objects--not new ones. Dave Peterson wrote: Unprotect the sheet? It looks like protection for .drawingobjects means for existing drawingobjects. Not new ones. If you're setting up a procedure for someone else, maybe you could have a macro add the picture. And let them move/resize it where they want it (or even plop it down in a selected range and don't let the user change anything...) If you can consider that option, this worked for me: Option Explicit Sub testme1() Dim myPicture As Picture ActiveSheet.Protect DrawingObjects:=False, _ Contents:=True, _ Scenarios:=True, _ UserInterfaceOnly:=True Set myPicture = ActiveSheet.Pictures.Insert( _ "C:\My Documents\My Pictures\test1.JPG") With ActiveSheet.Range("a1:b3") myPicture.Left = .Left myPicture.Width = .Width myPicture.Height = .Height myPicture.Top = .Top End With End Sub Adjust drawingobjects (true/false) according to what you want the user to do. C Mullins wrote: I need to insert a picture into a cell range on a protected sheet. I’m using Excel 2000 and have sheet protection turn on (contents/objects/scenarios) . There is a block of cells d1..h5 that is unlocked, I would like to insert a picture into this cell range. When I goto the first cell in the range d1 (or any of the cells in the range for that matter) and select Insert Picture all options are grayed out. Does some know how to resolve this issue? Thanks in advance for your assistance. C Mullins -- Dave Peterson ec35720@msn.com -- Dave Peterson ec35720@msn.com . -- Dave Peterson ec35720@msn.com |
| 2548 | I am trying to get Excel 2000 to print only a selection of a sheet on a well logger printer which uses a roll of thermal paper, and I don't want to print empty space -- I want it to stop at the end of the selection. Is there a way to do this other than making a custom paper size? Thanks |
| 2552 | I did a search for Specifications in xl2002's help and got this info about cells: Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Could you have reached the 1027 display limit? If yes, you may want to put a textbox on the worksheet to hold all the info. DLo wrote: Has anyone ever found a solution to Excel not fully expanding the row height in cells with a large number of text lines? This is NOT a case where it is clipping the last word or line, but rather it expands to a point and then will not autofit any larger regardless of how much text is remaining. I am using Excel 2000. -- Dave Peterson ec35720@msn.com |
| 2581 | Dave, You can pre-select your range for printing (by high-lighting the range) and then go in for FilePrint. In the next dialogue box which asks for what to print, select "Selection". Alternatively, you can go to FilePageSetup and on the Sheet Tab (the last one), you can set the print area. Hope this helps you. -- Regards, Murthy "dave" <rmws@wic.net wrote in message news:18f3f01c22de2$2d3c98c0$b1e62ecf@tkmsftngxa04... I am trying to get Excel 2000 to print only a selection of a sheet on a well logger printer which uses a roll of thermal paper, and I don't want to print empty space -- I want it to stop at the end of the selection. Is there a way to do this other than making a custom paper size? Thanks |
| 2595 | I am unsure if this can be done, but have every faith in your knowledge out there! (Using Excel 2000) I am trying to automatically assign a name to each cell in column B with the text that is in column A. For example... A B 1 oranges [want cell's name to be oranges] 2 apples [want cell's name to be apples] 3 and so on 4 5 The reason why I want to be able to do it automatically (instead of going into each cell andinsert name etc.) is that I will be working with a very large price list file with over 3000 records!! Hope some brain box out there can help me with this problem! Thanks in advance :) |
| 2596 | Hi Lisa The facility is already inbuilt to Excel. Mark your range of columns A and B Got to Insert=Names=Create and tick the box for Names in Left column. Job done! -- Regards, Roger Govier Technology 4 U "Lisa Hughes" <LisaAitch@aol.com wrote in message news:16ece01c22e32$f9b2c3c0$a5e62ecf@tkmsftngxa07... I am unsure if this can be done, but have every faith in your knowledge out there! (Using Excel 2000) I am trying to automatically assign a name to each cell in column B with the text that is in column A. For example... A B 1 oranges [want cell's name to be oranges] 2 apples [want cell's name to be apples] 3 and so on 4 5 The reason why I want to be able to do it automatically (instead of going into each cell andinsert name etc.) is that I will be working with a very large price list file with over 3000 records!! Hope some brain box out there can help me with this problem! Thanks in advance :) |
| 2612 | Hi, I have a query relating to the number format that we use in Excel. Iam using Excel 2000. I need the number format in this style. For Ex.when I type 1,50,000 in the Excel worksheet it appears like this : 150,000. But, I want my numbers like this ONLY : 1,50,000. Is there a way to accomplish the above. Likewise if I enter a number in crores (say, for example One crore and fifty lacs) it should appear in worksheet like this Rs.1,50,00,000. Awaiting very eagerly for your sugestions .. Rgs, Dev India. |
| 2619 | Hi, If you don't need to add the columns you can format the column as text or place a single quotation mark "'" at the start of the cell. Eg '1,50,000 when you exit the cell the preceding quotation mark will disappear from view Best regards KM -----Original Message----- Hi, I have a query relating to the number format that we use in Excel. Iam using Excel 2000. I need the number format in this style. For Ex.when I type 1,50,000 in the Excel worksheet it appears like this : 150,000. But, I want my numbers like this ONLY : 1,50,000. Is there a way to accomplish the above. Likewise if I enter a number in crores (say, for example One crore and fifty lacs) it should appear in worksheet like this Rs.1,50,00,000. Awaiting very eagerly for your sugestions .. Rgs, Dev India. . |
| 2621 | In Excel 2000 and 2002 each visible window has its own taskbar entry if Tools, Options, View Windows in Taskbar is selected. That is, if there are at least two windows visible. -- Jim Rech Excel MVP |
| 2622 | Hi Dev, For Excel 2000 and all Excel before Excel 2002 you can use custom number format [9999999.99]##\,##\,##\,##0.00;[99999.99]"##\,##\,##0.00;"##,##0.00 This format separates groups for India/Thailand, format valid for positive numbers up to 99,99,99,999.99 or 999,999,999.99) in Excel XP see function BhatText as in Thai Bhat currency. The help information for Excel 2002, but everyone using file would have to have Excel 2002 so there would be no advantage if exchanging files. BAHTTEXT /assistance/offhelp/offxp/excel/xlmain10/html/Bahttext.htm Format numbers using Thai digits /assistance/offhelp/offxp/excel/xlmain10/html/xlhowsadisplaythainumbers.htm Convert Arabic numbers to Thai text format /assistance/offhelp/offxp/excel/xlmain10/html/xlhowsaenterthaifunctionformulassheets.htm Use Thai numbers and dates in headers and footers /assistance/offhelp/offxp/excel/xlmain10/html/xlhowsausethainumbersheadersfooters.htm HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Dev" <dev9812@yahoo.com wrote in message news:b4ec7768.0207180302.2828b6f6@posting.google.com... Hi, I have a query relating to the number format that we use in Excel. Iam using Excel 2000. I need the number format in this style. For Ex.when I type 1,50,000 in the Excel worksheet it appears like this : 150,000. But, I want my numbers like this ONLY : 1,50,000. Is there a way to accomplish the above. Likewise if I enter a number in crores (say, for example One crore and fifty lacs) it should appear in worksheet like this Rs.1,50,00,000. Awaiting very eagerly for your sugestions .. Rgs, Dev India. |
| 2694 | Are you useing the document managment functions of Groupwise? If you are then talk to your GroupWise admin. If not to get rid of this message. Under 5.5 client go Tools, options, Documents, Intergrations. Then check off Enable integrations. This take of the ODMA error. Eric -----Original Message----- Hello, Can anyone help me this: Whatever, whenever I open MS Excel 2000 then I get a error:"Groupwise ODMA Integration. Quit your application and Reinstall resource library and restart your application!" I click OK many time til the error window close then I can work with Excel document. Thank you for any sugession. MN . |
| 2707 | I am writing a SAS script that refers to an Excel 2000 file. I would like to use OLEDB commands, however I am not certain of the parameter values for excel files. How do I find out, or does anyone know what are the values for the 'provider' and 'provider_string' parameters when it comes to Excel 2000? |
| 2713 | An excel 2000 sheet has been saved whilst it was in the process of being emailed - not as an attachment in Outlook 2000. Now when I open the sheet the envelope toolbar appears. Can this be removed? Thanks gavin |
| 2724 | Are you meaning the reviewing toolbar? If so uncheck it under viewtoolbarsreviewing -- Regards, Peo Sjoblom "Gavin Scott and Denise Allardice" <mrs@snowy.net.au wrote in message news:#vJZclyLCHA.2400@tkmsftngp08... An excel 2000 sheet has been saved whilst it was in the process of being emailed - not as an attachment in Outlook 2000. Now when I open the sheet the envelope toolbar appears. Can this be removed? Thanks gavin |
| 2733 | I think this is what you are looking for Sub z() ThisWorkbook.EnvelopeVisible = False End Sub regards Ron "Gavin Scott and Denise Allardice" <mrs@snowy.net.au schreef in bericht news:#vJZclyLCHA.2400@tkmsftngp08... An excel 2000 sheet has been saved whilst it was in the process of being emailed - not as an attachment in Outlook 2000. Now when I open the sheet the envelope toolbar appears. Can this be removed? Thanks gavin |
| 2746 | -----Original Message----- Try clearing out your temporary internet files. deactivating your antivirus program starting Excel without macros starting Excel in safe mode, without macros or addins To start in safe mode XL2000: Startup Switches for Microsoft Excel 2000 /default.aspx?scid=kb;en- us;Q211481 start excel from the Windows Start, Run menu excel.exe /s If you find something that works, report back and maybe a more durable solution can be found. Thank you for your reaction, i'll let you know if it works! |
| 2753 | If that doesn't work, I've seen these suggested: /default.aspx?scid=kb;EN-US;q270125 OFF2000: Program Quits Immediately After Installing Project or Visio (Q270125) /default.aspx?scid=kb;EN-US;q255503 OFF2000: Program Quits Immediately After Starting When SR-1/SR-1a Update Is Applied (Q255503) /default.aspx?scid=kb;EN-US;q236592 OFF2000: Error Messages Starting Office Program, or Program Immediately Quits on Windows XP, Windows NT 4.0, or Windows 2000 (Q236592) If one of these don't help, maybe you could search the KB: /default.aspx?ln=EN-US&pr=kbinfo& Pietje wrote: -----Original Message----- Try clearing out your temporary internet files. deactivating your antivirus program starting Excel without macros starting Excel in safe mode, without macros or addins To start in safe mode XL2000: Startup Switches for Microsoft Excel 2000 /default.aspx?scid=kb;en- us;Q211481 start excel from the Windows Start, Run menu excel.exe /s If you find something that works, report back and maybe a more durable solution can be found. Thank you for your reaction, i'll let you know if it works! -- Dave Peterson ec35720@msn.com |
| 2829 | I have seen this with Excel 2000, but haven't tested this fix with Excel 2002. Under Tools, Options, General tab - adjust the setting for "Ignore other applications". We had to reverse the setting of this check box for the double-click to work. HTH Beth - Excel MVP Ok heres something that is unusually weird. . . When I double click my excel file, the application (Excel 2002) opens up but doesnt open my actual file. What I have to do next is to drag my file onto the app and then i see my file. After i double click - the application is running with a blank window. I tried to re-install excel again and its still the same problem. This doesnt happen to any other app (Word, Powerpoint . . .). I have already looked into file associations and everything there checks out ( cross referenced that with another pc's configuration). this just started happening recently. anyone have any idea how/why this happened and how i can fix it? Thanks |
| 2856 | OH MY GOD!!!!!! I must say that you have saved my life!!! I should have just posted a message instead of spending 4 hours, installing, uninstalling and playing around with file types. Thanks you so much - I went under the general tab and unchecked "ignore other apps" and VOILA, i double clicked my file and it worked. haroon "BUnglesbee" <bunglesbee@aol.com wrote in message news:20020721154311.07767.00000212@mb-ba.aol.com... I have seen this with Excel 2000, but haven't tested this fix with Excel 2002. Under Tools, Options, General tab - adjust the setting for "Ignore other applications". We had to reverse the setting of this check box for the double-click to work. HTH Beth - Excel MVP Ok heres something that is unusually weird. . . When I double click my excel file, the application (Excel 2002) opens up but doesnt open my actual file. What I have to do next is to drag my file onto the app and then i see my file. After i double click - the application is running with a blank window. I tried to re-install excel again and its still the same problem. This doesnt happen to any other app (Word, Powerpoint . . .). I have already looked into file associations and everything there checks out ( cross referenced that with another pc's configuration). this just started happening recently. anyone have any idea how/why this happened and how i can fix it? Thanks |
| 2863 | Not sure what you want here. 1. If you put an email address into an Excel 2000 cell it is recognised as such, and you can double click to get a blank mail form. Excel 97 would need a macro to do this. 2. If you want to copy and paste the text of an email, it will go into a cell, but I put it into a TextBox from the Drawing toolbar. If this is not what you want, please be more explicit & state your Excel version. Regards BrianB --------------------------------------------------------------- "Xander" <pvoogt@mnszw.nl wrote in message news:<1a42301c2315b$de5b1010$b1e62ecf@tkmsftngxa04... I would like to know how I might be able to insert an e- mail into a Excell cell as a reference. Thanks in advance. |
| 2902 | I am currently using windows 98 and running Excel 95, version 7.0. Can I upgrade to Excel 2000 version 9.0 or 2002 through a download or do I have to go to the store and purchase the Excel? Will Excel 2002 be compatible with Excel 95, version 7.0? Will appreciate your assistance. |
| 2903 | I've got quite a few spreadsheets. What I want to do is change the Excel icon (the little spreadsheet with the "X") that seems to be the default icon to something a little more eye-catching. Something like putting an automobile for the auto expense spreadsheet, a wrench for the maintenance sheet, a lightning bolt for the electricity expense sheet. -- Reply to joeclement at kenton dot com - ignore the spam bait above "seaun" <seaunmatthews@yahoo.com wrote in message news:O3vobsbMCHA.1596@tkmsftngp13... joe, are you wanting to change the icon as it would appear in say an explorer window or the icons IN excel?? "Mike M." <joeqcpa@yahoo.com wrote in message news:1bba701c231b2$3b434800$3bef2ecf@TKMSFTNGXA10... Right-click on one of your toolbars and select Customize. Right-click on one of the icons you want to change and select either Change Button Image or Edit Button Image. Change will allow you to select one of several precreated icons. Edit will allow you to customize an icon yourself so you can change the design and color of the icon. I have created some of my own using existing icons. For example, I created a macro to place a red checkmark in a cell. I created a red checkmark button by starting with the spellcheck button icon and modifying it to what I wanted. Have fun. Mike. -----Original Message----- This may be a little OT, but here is where I can find experts. I would like to change the icons on some of my Excel spreadsheets to make them stand out in the crowd of spreadsheets I have on my computer. With all of them having the same icon, it takes time to find the particular one. Does anyone know how to do this. I'm running Excel 2000 on a Win 98 system. TIA Joe . |
| 2904 | Hi Len, You will need to purchase an upgrade package. Skip Excel 2000 and go to Excel 2002. Compatibility is always up never down. Excel 2002 can open an Excel 95 workbook but if you want Excel 95 to open a file made in Excel 2002 you must do a save as and specify the file type. Best wishes Bernard www.stfx.ca/people/bliengme len mygatt wrote: I am currently using windows 98 and running Excel 95, version 7.0. Can I upgrade to Excel 2000 version 9.0 or 2002 through a download or do I have to go to the store and purchase the Excel? Will Excel 2002 be compatible with Excel 95, version 7.0? Will appreciate your assistance. |
| 2909 | There is upgrading information on this web page: /office/howtobuy/upgrading.asp You can buy Excel 2002, and you'll be able to open your Excel 95 files. len mygatt wrote: I am currently using windows 98 and running Excel 95, version 7.0. Can I upgrade to Excel 2000 version 9.0 or 2002 through a download or do I have to go to the store and purchase the Excel? Will Excel 2002 be compatible with Excel 95, version 7.0? Will appreciate your assistance. -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2928 | I am trying to build an excel spreadsheet at work which imports the power price from our power pool website . The machine I am using has Excel 2000 on it .If I try to get the data onto the screen using the web query function , all I get is the Header and the next line says"the report is downloading " and that is it . When I save the worksheet and try it on another machine using Excel 97 , the header and the table with the pool price shows up just fine .It appears as if Excel 2000 is not polling the website long enough in order to get the information . Is there a setting where a person set the amount of time the web query runs for when it refreshes the Data . I have attached the power pool website address and a copy of my worksheet with the web query on it . If anyone can figure this out . I would greatly appreciate it . Thank you . |
| 2981 | Dave, I'm using Excel 2000. But for speaking i'm using SAPI. Thank you for giving me good solution Application.Sum (ActiveCell.EntireColumn). Also can you guide me how to get the range of selected cells? Keshav. |
| 2982 | Got a slight problem with some excel documents, in particular documents that have been saved with the preference of read only when opening. Excel appears to launch (giving the option of Read only) and the document opens, however it then closes the document and opens it again (again giving the option of Read only). It is only a quirky little thing but does anyone know why it happens and is there a way around this without disabling the read only option. Excel 2000 SR-1 Thanks.. Jake |
| 3011 | I only want to copy a certain selected area within one worksheet to another worksheet within the SAME workbook and have the copied material's format {including page orientation, cell formatting, and column widths} to be the same. I know it sounds easy enough . . . but it doesn't work correctly. If I just copy/paste I get the formatted text but not the page orientation and column widths. If I copy/paste special and chose to copy formats, then I get the column widths but LOSE the cell formatting! -----Original Message----- it seems to work for me but you can always click on the worksheet tab and copy to a new sheet that way. would that work for you or is there a reason you have to paste into an existing sheet? HTH "Faith" <ltrawick@faulkner.edu wrote in message news:01e001c23272$7a7c1d10$3bef2ecf@TKMSFTNGXA10... Excel 2000: I want to copy data, including its' formating, column widths, page orientation, etc. from one worksheet within a workbook to another worksheet within the same workbook. When I do this {either using COPY|PASTE and have tried COPY|PASTE SPECIAL} I cannot get all of the above-mentioned copied. There is nothing special that has to be done to accomplish this simple task in Office 97 -- a COPY|PASTE works fine and retains all text and page formatting. Is this a bug in Excel 2000? . |
| 3015 | We have recently upgraded our pc's from NT and Office 97 to W2000 and Excel 2000. Excel '97 files created with Basic macros will now no longer open. An error message occurs saying the file has been locked. People have told me that the macros have to be recreated in Excel 2000. Any help. The macros are very basic Combo Boxes etc. BG |
| 2123 | Hi Anne It is usually considered inadvisable to open any Excel file directly from a floppy disk. Copy the file to a folder on your hard disk first, then you should be able to open it without difficulty. The reason you have been able to open other files, I suspect, is because they have been fairly small (and certainly less than the free space left on the floppy disk), whereas the file giving the problem is larger than the free space remaining on the floppy. -- Regards, Roger Govier Technology 4 U "Anne Eade" <cactus4@tpg.com.au wrote in message news:17d1301c2296c$59f68490$9be62ecf@tkmsftngxa03... When I try to open an Excel 2000 premium file from a floppy disk, I get the following message: file.xls cannot be accessed. The file may be read-only or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding. I have other xls files on the same disc and I can open them. This file is not tagged read-only. Can anyone help??? Thanks |
| 2131 | Hi Anne Normally when you receive that message -- the file on the floppy is corrupt due to a corrupt save process. While floppie are wonderful for transportation, NEVER use them as open/close medium for Excel -- or better yet for ANY application. Hopefully you have this file on a hard drive somewhere. If you want to transfer it, copy (using explorer) to floppy take to destination computer, copy to HD then use Excel to open it "Anne Eade" <cactus4@tpg.com.au wrote in message news:17d1301c2296c$59f68490$9be62ecf@tkmsftngxa03... : When I try to open an Excel 2000 premium file from a : floppy disk, I get the following message: : : file.xls cannot be accessed. The file may be read-only or : you may be trying to access a read-only location. Or, the : server the document is stored on may not be responding. : : I have other xls files on the same disc and I can open : them. This file is not tagged read-only. : Can anyone help??? : Thanks |
| 2172 | I'd like to create a new function (excel 2000) that, for example, makes the difference between two cells and marks the cell red if the difference is <0. I can do it with a macro but i'd like to call it as a function so that any time I change a value, it will automatically calculate the new value. Any idea how to do it? Thanks, Fulvio |
| 2173 | I understood the OP as wanting to add a button directly to the worksheet--not to a toolbar. I think both of you are correct but are answering different questions! So the question is now: Did the OP mean adding a forms button to a worksheet or to a commandbar? RagDyer wrote: I'm probably totally misunderstanding the question, but I *always* apply different colors to buttons I add to toolbars that fire macros. I add these buttons by right clicking in the toolbar and <Customize <Commands tab Scroll down in the "Categories" window and click on "Forms" Then, in the "Commands" window, click and drag the "button" icon to the toolbar. I then click on "Modify" and assign my macro, and then click on "EditButtonImage" and paint it, or the background, almost any color I wish. On some occasions, I change the button image itself. Is this not what the OP requested??? Regards, RD "John Walkenbach" <john@j-walk.com wrote in message news:O9kyY$OKCHA.2500@tkmsftngp10... No. Controls from the Forms toolbar have very few formatting options. John Walkenbach For Excel tips, macros, & downloads... -walk.com/ss "Mike" <dmcsoco@mongol.net wrote in message news:1537c01c228ee$99ac0430$36ef2ecf@tkmsftngxa12... I'm using Excel 2000. When I insert a control button from the Forms Toolbar to run a macro in a spreadsheet is there any way that I can change the background color of the control button? Many thanks for help and suggestions, Mike. -- Dave Peterson ec35720@msn.com |
| 2178 | This sounds like you could just use a regular worksheet formula (like =a1-b1). But after you put your formula in, take a look at Format|conditional Formatting. You'll get up to 3 conditions (and it sounds like you'll only need the first) to specify special conditional formatting. Fulvio wrote: I'd like to create a new function (excel 2000) that, for example, makes the difference between two cells and marks the cell red if the difference is <0. I can do it with a macro but i'd like to call it as a function so that any time I change a value, it will automatically calculate the new value. Any idea how to do it? Thanks, Fulvio -- Dave Peterson ec35720@msn.com |
| 2186 | Just to add One reason Dave isn't suggesting a User defined function which you could use in a worksheet is because such a function can only return a value to a cell - it can't change colors or otherwise affect the environment. Dave Peterson <ec35720@msn.com wrote in message news:3D3028C0.51E5AD7@msn.com... This sounds like you could just use a regular worksheet formula (like =a1-b1). But after you put your formula in, take a look at Format|conditional Formatting. You'll get up to 3 conditions (and it sounds like you'll only need the first) to specify special conditional formatting. Fulvio wrote: I'd like to create a new function (excel 2000) that, for example, makes the difference between two cells and marks the cell red if the difference is <0. I can do it with a macro but i'd like to call it as a function so that any time I change a value, it will automatically calculate the new value. Any idea how to do it? Thanks, Fulvio -- Dave Peterson ec35720@msn.com |