| 1472 | There are some (many?) format/content related settings that XL will reset to the default values for a PT. You can control some through the 'Preserve formatting' option of a PT. Check XL help for more or check support.microsoft.com XL2000: Changing a PivotChart Removes Series Formatting (Q215904) /default.aspx?scid=kb;EN-US;Q215904 XL2000: PivotTable Does Not Preserve Conditional Formatting (Q215986) /search/preview.aspx?scid=kb;en-us;Q215986 XL2000: Data Number Formatting Is Lost After You Create a PivotTable (Q214021) /search/preview.aspx?scid=kb;en-us;Q214021 -- Regards, Tushar Mehta www.tushar-mehta.com Microsoft MVP -- Excel -- In <1052201c22353$ef7ba230$95e62ecf@tkmsftngxs02, Jacob Enevoldsen <jen@bankdata.dk wrote How du I prevent Excel from using the default colors on the matrix instead of my definitions whenever I update the sheet it's (the pivot table) using. Technical spec. Excel 2002 on Win NT Thanks Jacob |
| 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 |
| 1503 | Thanks Nick! I went back to Excel and selected the thickest border and got the desired result which appears to survive re-publishing. John D. Peterson jdpeterson@glpwgroup.com "Nick Hodge" <nick_hodge@btinternet.com wrote in message news:uwLu5XtICHA.2232@tkmsftngp12... John Borders don't seem to transfer well in XL to HTML. Open the resulting file in notepad and look for the Border setting. Increasing the number parameter may help. -- HTH Nick Hodge Southampton, England Microsoft MVP - Excel nick_hodge@btinternet.com Excel XP\WinXP "John Peterson" <johndpeterson@hotmail.com wrote in message news:Oxutl2rICHA.2060@tkmsftngp11... Using the File/Save as Web Page.../Publish command in Excel 2002 SP-1 on a cell range, everything works as advertised except that the heavy outline border that I created around the range does not appear in the published web page, only a thin line, although it is certainly present in the worksheet. The interior grid lines in the worksheet do transfer to the published web page. I tried creating an outer heavy border around adjacent surrounding cells, thinking that the now interior heavy border was just getting clipped, but that was not the case. The line thickness just gets lost and I just end up with a thin double line frame. Do I need to set some obscure flag somewhere to get the border formatting to completely carry through to the published data? I didn't see anything at Tools/Options/Web Options... that appeared to apply. Or is this a "feature"? John D. Peterson jdpeterson@glpwgroup.com |
| 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 |
| 1612 | Hi Excel Users and Experts, Windows XP, Excel 2002 I am using Dana's macro and I get a compile error, "User-defined type not defined" and the code line "Dim CB as New DataObject" is highlighted. I checked under the VBA Tools References and cannot find the Microsoft Forms 2.0 object library which I am guessing is the problem. There are several MS ActiveX libraries, one of which is 2.0 but no luck on Forms. The macro worked fine on a previous computer and version of Excel, however cannot get past this compile error. Sub GoogleExcelHelp() '================================================== ' By: Dana DeLouis ' Looks for a words that are copied to ' the clipboard in the Google Newgroups... ' limited to the "Excel" groups. ' As always, feedback is welcomed... '================================================== ' You must have a reference set in your VBA project ' to the Microsoft Forms 2.0 object library. '================================================== Dim LookFor As String Dim CB As New DataObject ' This should be a string, and not a link as ' it is displayed in this newsgroup. On Error Resume Next Const GoogleExcel As String = _ "/groups?as_q=##&as_ugroup=*excel*&lr=lang_en&nu m=100&hl=en" CB.GetFromClipboard LookFor = CB.GetText() ' Now, clean it up With Application LookFor = Replace(LookFor, vbCrLf, Space(1)) LookFor = .Clean(LookFor) LookFor = .Trim(LookFor) End With ' As a guess, adjust to a format for Google LookFor = Replace(LookFor, Space(1), "+") ActiveWorkbook.FollowHyperlink Address:=Replace(GoogleExcel, "##", LookFor), NewWindow:=True End Sub Thanks, Howard |
| 1614 | Insert a userform in your project and it will create a reference to it. You can then delete the userform I would think. L. Howard Kittle <lhkittle@attbi.com wrote in message news:jYIV8.105515$Uu2.18431@sccrnsc03... Hi Excel Users and Experts, Windows XP, Excel 2002 I am using Dana's macro and I get a compile error, "User-defined type not defined" and the code line "Dim CB as New DataObject" is highlighted. I checked under the VBA Tools References and cannot find the Microsoft Forms 2.0 object library which I am guessing is the problem. There are several MS ActiveX libraries, one of which is 2.0 but no luck on Forms. The macro worked fine on a previous computer and version of Excel, however cannot get past this compile error. Sub GoogleExcelHelp() '================================================== ' By: Dana DeLouis ' Looks for a words that are copied to ' the clipboard in the Google Newgroups... ' limited to the "Excel" groups. ' As always, feedback is welcomed... '================================================== ' You must have a reference set in your VBA project ' to the Microsoft Forms 2.0 object library. '================================================== Dim LookFor As String Dim CB As New DataObject ' This should be a string, and not a link as ' it is displayed in this newsgroup. On Error Resume Next Const GoogleExcel As String = _ "/groups?as_q=##&as_ugroup=*excel*&lr=lang_en&nu m=100&hl=en" CB.GetFromClipboard LookFor = CB.GetText() ' Now, clean it up With Application LookFor = Replace(LookFor, vbCrLf, Space(1)) LookFor = .Clean(LookFor) LookFor = .Trim(LookFor) End With ' As a guess, adjust to a format for Google LookFor = Replace(LookFor, Space(1), "+") ActiveWorkbook.FollowHyperlink Address:=Replace(GoogleExcel, "##", LookFor), NewWindow:=True End Sub Thanks, Howard |
| 1615 | Thanks, Tom. That did the trick and it worked fine. Thanks again, Regards, Howard "L. Howard Kittle" <lhkittle@attbi.com wrote in message news:jYIV8.105515$Uu2.18431@sccrnsc03... Hi Excel Users and Experts, Windows XP, Excel 2002 I am using Dana's macro and I get a compile error, "User-defined type not defined" and the code line "Dim CB as New DataObject" is highlighted. I checked under the VBA Tools References and cannot find the Microsoft Forms 2.0 object library which I am guessing is the problem. There are several MS ActiveX libraries, one of which is 2.0 but no luck on Forms. The macro worked fine on a previous computer and version of Excel, however cannot get past this compile error. Sub GoogleExcelHelp() '================================================== ' By: Dana DeLouis ' Looks for a words that are copied to ' the clipboard in the Google Newgroups... ' limited to the "Excel" groups. ' As always, feedback is welcomed... '================================================== ' You must have a reference set in your VBA project ' to the Microsoft Forms 2.0 object library. '================================================== Dim LookFor As String Dim CB As New DataObject ' This should be a string, and not a link as ' it is displayed in this newsgroup. On Error Resume Next Const GoogleExcel As String = _ "/groups?as_q=##&as_ugroup=*excel*&lr=lang_en&nu m=100&hl=en" CB.GetFromClipboard LookFor = CB.GetText() ' Now, clean it up With Application LookFor = Replace(LookFor, vbCrLf, Space(1)) LookFor = .Clean(LookFor) LookFor = .Trim(LookFor) End With ' As a guess, adjust to a format for Google LookFor = Replace(LookFor, Space(1), "+") ActiveWorkbook.FollowHyperlink Address:=Replace(GoogleExcel, "##", LookFor), NewWindow:=True End Sub Thanks, Howard |
| 1650 | Re the Out of Memory message it sounds as though you have hit an excel memory limit, probably the limit of approx 80MB of formulae and pivot caches. see /memlimitsc.htm for some more details. If that is the problem then the bypasses are either to upgrade to Excel 2002 or to close some of your open workbooks. Charles Williams ______________________ Decision Models The Excel Calculation Site www.DecisionModels.com |
| 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 |
| 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 |
| 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 |
| 1806 | Excel 2002 uses the same fileformat as 97 and 2000.. -- Regards, Peo Sjoblom "Tng Hau" <thau@gwbakeries.com wrote in message news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. |
| 1812 | That's what I thought. But why did we get the message about "This file was created using a later version of Excel ....". Why did it keep coming up even after we clicked yes (to lose any new information)? -----Original Message----- Excel 2002 uses the same fileformat as 97 and 2000.. -- Regards, Peo Sjoblom "Tng Hau" <thau@gwbakeries.com wrote in message news:1456701c22776$9ab87800$37ef2ecf@TKMSFTNGXA13... I am the only one in my office so far to have the XP version of Excel. My problem is that any file I saved in XP will be upgraded to the XP. When other users use my files and try to save them, they would get a message saying the file was created using a later version of Excel, if you click yes you will lose the new information, I told the users to go ahead click yes. But the message keeps coming back no matter how many times they do that. Does any one how to get rid of that? I could not find anything in the Excel XP help or in the Knowledge Base to help me solve this problem. Excel XP does not have an option to save file as Excel 97 type. It only has a "Excel 97-2000 & 5.0/95 workbook" which doubles the size of the file. Thanks. . |
| 1816 | you can run this line to disable it Application.CommandBars("Reviewing").Enabled = False Set it true to use it again Regards Ron "David M Wicker" <david.wicker@NOSPAMnet.ntl.com schreef in bericht news:683miukjj5svioo4je35c89g3usaoh9qs8@4ax.com... On Tue, 9 Jul 2002 06:58:38 -0400, "Jim Rech" <jarech@kpmg.com wrote: Try using the last button on the Excel 2002 Reviewing toolbar, "End Review". Jim that button is 'greyed out' David |
| 2016 | The following pages have some introductory info. If you keep the client info in one list it will probably be easier to manage, and to create reports. Using Access 2002 or Excel 2002 to Manage Your Data /assistance/2002/articles/oStoreDataAcEx.aspx Using Excel 97 for List Management /cits/learning/docs/pdf/s13.pdf PivotTable Reports 101 for Excel 2002, Part 1 /assistance/2002/articles/xlconPT101.aspx Joan wrote: Are there any online sites with info on databases in excel. I have lots of books,but the database format doesn't feature alot. What are the accepted rules when making one eg. for a client details. Should you just have say a sheet for each different town they in or just one big sheet and filter out info?? Are there any examples on the net?? Many thanks -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2061 | My toolbar file in Excel 97 and Windows 98SE is: C:\WINDOWS\UserName8.xlb My toolbar file in Excel 2000 and Windows 98SE is: C:\WINDOWS\Application Data\Microsoft\Excel\Excel.xlb This is UN-tested: Find the Excel.xlb file on the destination machine. Rename the Excel.xlb file on the destination machine to Excel.bak (or something else that isn't used) Copy the xxxx8.xlb file from the source machine. Paste the xxxx8.xlb file in the same location as the Excel.bak Rename the xxxx8.xlb to Excel.xlb "Tom S" <Sinskit@usa.redcross.org wrote in message news:173d301c2290b$47e4c7f0$b1e62ecf@tkmsftngxa04... How do I convert an Excel 97 file with vba code and custom menus to excel 2002. The MS Knowledge Base web site says custom toolbars will not be migrated. Then to open the *8.xlb file to view the toolbars in 2002. Problem is my computer with Windows 2000 on it does not have a *8.xlb file to open. |
| 2096 | Many thanks, those articles are great. I have bookmarked the microsoft office assistance site, sad to say I hadn't even looked there..talk about missing the obvious. "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D2D6C43.8010008@contextures.com... The following pages have some introductory info. If you keep the client info in one list it will probably be easier to manage, and to create reports. Using Access 2002 or Excel 2002 to Manage Your Data /assistance/2002/articles/oStoreDataAcEx.aspx Using Excel 97 for List Management /cits/learning/docs/pdf/s13.pdf PivotTable Reports 101 for Excel 2002, Part 1 /assistance/2002/articles/xlconPT101.aspx Joan wrote: Are there any online sites with info on databases in excel. I have lots of books,but the database format doesn't feature alot. What are the accepted rules when making one eg. for a client details. Should you just have say a sheet for each different town they in or just one big sheet and filter out info?? Are there any examples on the net?? Many thanks -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2160 | Has anyone had any experience with performance problems moving from Excel 79 to 2002? My specific problem appears to be related to very large spreadsheets that contain macros. In Excel 97 the module runs in 3 minutes. In Excel 2002 the module takes 24 minutes. Others have complained that performance is poor even in spreadsheets not containing macros. Any help? |
| 2163 | What are the system specs how was in installed (Clean build?) Most importantly how much memory is in your machines? -----Original Message----- Has anyone had any experience with performance problems moving from Excel 79 to 2002? My specific problem appears to be related to very large spreadsheets that contain macros. In Excel 97 the module runs in 3 minutes. In Excel 2002 the module takes 24 minutes. Others have complained that performance is poor even in spreadsheets not containing macros. Any help? . |
| 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 |
| 2420 | If you use Excel 2002 then go to Edit/Links/Startup Prompt, where you can choose the option "Do not show the alert and do not update the links." This option may or may not be available in older versions of Excel as I believe there were some changes in newer versions of Excel regarding links to other spreadsheets. Deepesh |
| 2450 | Can't see a way of doing this in 97 or 2000 - suggest you try a macro that runs automatically when you open the main workbook HTH Phil Deepesh <mdeepesh@rediffmail.com wrote in message news:16b0b01c22d19$0820b9f0$9ee62ecf@tkmsftngxa05... If you use Excel 2002 then go to Edit/Links/Startup Prompt, where you can choose the option "Do not show the alert and do not update the links." This option may or may not be available in older versions of Excel as I believe there were some changes in newer versions of Excel regarding links to other spreadsheets. Deepesh |
| 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? |
| 2519 | Hi Machine, a) Check that Excel 97 is at the SR2 level. b) check out the Slow Open/close section at /optspeedd.htm to see if anything there helps. c) See if you get the same problem when you copy the workbook to a local drive. d) If you still have the problem then you probably have a corrupt workbook: try opening it in Excel 2002 or rebuilding it. Charles Williams ______________________ Decision Models The Excel Calculation Site www.DecisionModels.com "machine" <machine@machine.com.it wrote in message news:YHcZ8.37053$Hj3.110860@newsfeeds.bigpond.com... hi guys...i really need someone to throw me a freakin' bone on this one. when i open an excel document on any PC in a particular network i maintain (workstations all NT and office 97), the cpu usage goes straight up to 100% and stays there and the application stops responding - no other applications open at all. there are other networks that i maintain that have exactly the same SOE yet they do not behave in this way. i'm not even sure where to start looking to get to the bottom of this one...so any and all suggestions are most welcome. hardware is mostly PII 550, 64MB...slow by todays standards, but it works (usually). all documents stored on network drives. office 97 installed on each individual machine...obviously. |
| 2537 | Excel 2002 - We have a spreadsheet (actually several, but this one is the only one that does this) that we use on our network that is automatically saving a back-up everytime we make changes to it. We open the spreadsheet, make changes, do a save as and change the name, so the original is always there. Then, when we open the new one and make more changes to it and close it, a backup is saved automatically. Is there a setting we are missing to turn this off? Thank you!! |
| 2538 | Excel 2002 - We have a spreadsheet (actually several, but this one is the only one that does this) that we use on our network that is automatically saving a back-up everytime we make changes to it. We open the spreadsheet, make changes, do a save as and change the name, so the original is always there. Then, when we open the new one and make more changes to it and close it, a backup is saved automatically. Is there a setting we are missing to turn this off? Thank you!! |
| 2562 | tami Next time you do a "saveas" click on "Options" and de-check "always create a backup". HTH Gord Dibben Excel MVP - XL97 SR2 On Wed, 17 Jul 2002 14:57:08 -0700, "tami" <tamir@rileycon.com wrote: Excel 2002 - We have a spreadsheet (actually several, but this one is the only one that does this) that we use on our network that is automatically saving a back-up everytime we make changes to it. We open the spreadsheet, make changes, do a save as and change the name, so the original is always there. Then, when we open the new one and make more changes to it and close it, a backup is saved automatically. Is there a setting we are missing to turn this off? Thank you!! |
| 2571 | In xl2002, it's hidden under: File|SaveAs|Tools (top right corner), then General Options. Gord Dibben wrote: tami Next time you do a "saveas" click on "Options" and de-check "always create a backup". HTH Gord Dibben Excel MVP - XL97 SR2 On Wed, 17 Jul 2002 14:57:08 -0700, "tami" <tamir@rileycon.com wrote: Excel 2002 - We have a spreadsheet (actually several, but this one is the only one that does this) that we use on our network that is automatically saving a back-up everytime we make changes to it. We open the spreadsheet, make changes, do a save as and change the name, so the original is always there. Then, when we open the new one and make more changes to it and close it, a backup is saved automatically. Is there a setting we are missing to turn this off? Thank you!! -- Dave Peterson ec35720@msn.com |
| 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. |
| 2639 | Using Excel 2002, I could only reproduce your symptoms when the period crossed into a second year and does not cross a 2/28-3/1 boundary, in which case Excel uses the shorter of the two years (365). I don't know if this is standard in the financial world, or an Excel thing. Tim C "Joe" <johnsonj@fhlbsf.com wrote in message news:19f9701c22eab$e2e551c0$19ef2ecf@tkmsftngxa01... I am using excel 97. I am using the YEARFRAC function to determine the interest payment period for financial instruments with Actual/Actual day counts. I entered "1" as the final argument, but the function does not account for lear year. Example, the fraction is the same for a 31 day period in 2003 as it is in 2004. What am I doing wrong? |
| 2741 | We have this same problem, and we've found a temporary fix. In NAV CE 7.6, go to configure, and File Realtime Protection, and then File Types. Change it from all types to selected types, and then pull up the list of protected extensions and remove the xls extension. This disables realtime protection for Excel documents (not necessarily a good thing), but it does prevent the close problem for the time being. The Symantec site doesn't show anything about this problem yet, and I think anyone with this issue should email or report it to them. michalak@mindspring.com (Steve Michalak) wrote in message news:<af18b15c.0207110747.5e712698@posting.google.com... This is a clear problem with Excel 2002 accessing files from a network share on which file system realtime protection is running (NAV CE 7.6). Each file can take up to 30-40 seconds apiece to close, whether saving or not. No problem with files on a local drive, even with NAV realtime protection. This is occuring on many workstations with licensed, full retail versions installed, all available Windows XP updates applied and Office XP SP1 in place. Does anyone know of a solutions yet? |
| 2788 | I would like to open different spreadsheets in a different Excel Window....I have dual screens and would like Excel by default to open in a different window...we are usually Excel 2002. Thanks Stuart |
| 2791 | You'd need to open the workbook (file), then use the Window--New Window command to create a second window for the workbook. You can then select the worksheets you want in each window and also use the Window--Arrange command to arrange them on the screen. This is saved with the workbook so the next time you open it it will still have the dual screens. ______________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Stuart R. Crawford" <scrawford@itmatters.spamguard.ca wrote in message news:aLm_8.18194$v53.892389@news3.calgary.shaw.ca... I would like to open different spreadsheets in a different Excel Window....I have dual screens and would like Excel by default to open in a different window...we are usually Excel 2002. Thanks Stuart |
| 2798 | No. However, there is a Paste Values button that you can add to any toolbar. Just access the Tools--Customize command and on the Commands Tab, Click the Edit category. Scroll down the list of commands to the right and you'll see it (along with other Paste Special commands). Drag it onto any toolbar. FYI: If you have Excel 2002, the Paste button on the Standard toolbar has a drop-down arrow that lists different paste methods, Values being one of them. ______________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Wonggie" <mewong@maxis.net.my wrote in message news:17d4501c23080$d8b5b790$a5e62ecf@tkmsftngxa07... Hi there, When I clicked on "Paste Special", it opens and automatically selects "All". Is it possible to customize it so that it points to "Values" instead? Thanks. Regards, Wonggie |
| 2821 | 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 |
| 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 |
| 2866 | Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene |
| 2872 | Opps...darn wrapping link...try this link: /?W25B42351 "Laura Wilde" <laura@top-brands.com wrote in message news:ujKJ8TcMCHA.2372@tkmsftngp11... Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene |
| 2878 | Or, you can get rid of all the Google stuff, for a shorter, direct link to the article: /default.aspx?scid=kb;[LN];Q171217 Laura Wilde wrote: Opps...darn wrapping link...try this link: /?W25B42351 "Laura Wilde" <laura@top-brands.com wrote in message news:ujKJ8TcMCHA.2372@tkmsftngp11... Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2880 | But that would be too simple, a lot less complicated, and far too easy for others understand... :) "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D3C7BDE.2060704@contextures.com... Or, you can get rid of all the Google stuff, for a shorter, direct link to the article: /default.aspx?scid=kb;[LN];Q171217 Laura Wilde wrote: Opps...darn wrapping link...try this link: /?W25B42351 "Laura Wilde" <laura@top-brands.com wrote in message news:ujKJ8TcMCHA.2372@tkmsftngp11... Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2883 | Thank you so much for your quick reply! I checked the link but now I am confused. I never use anything from an extended character set. In fact, I never saved the original file as an Excel Add In. Additionally, the Excel97 machine already has SR-1, which the link says may fix the problem. I am still having issues with this. I hope you are still reading this chain of replies. Again, thank you for your help on this..... Gene -----Original Message----- Gene, Check out this link: /url? sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene . |
| 2884 | Actually, that was the *new, improved* MSKB link, which seems to have broken at the first square bracket. The old style still seems to work, and stays glued together <fingers crossed: /default.aspx?scid=kb;en-us;Q171217 Laura Wilde wrote: But that would be too simple, a lot less complicated, and far too easy for others understand... :) "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D3C7BDE.2060704@contextures.com... Or, you can get rid of all the Google stuff, for a shorter, direct link to the article: /default.aspx?scid=kb;[LN];Q171217 Laura Wilde wrote: Opps...darn wrapping link...try this link: /?W25B42351 "Laura Wilde" <laura@top-brands.com wrote in message news:ujKJ8TcMCHA.2372@tkmsftngp11... Gene, Check out this link: /url?sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2887 | Sometimes I just crack myself up. I double checked the module names and the ones that it is choking on are ones that have an underscore in the name. I didn't think underscores were considered extended characters. Well if you can't laugh at yourself, who can you laugh at. Obscure problems are a headache to solve. That is why I REALLY REALLY REALLY apprciate your help on this problem. Gene -----Original Message----- Thank you so much for your quick reply! I checked the link but now I am confused. I never use anything from an extended character set. In fact, I never saved the original file as an Excel Add In. Additionally, the Excel97 machine already has SR-1, which the link says may fix the problem. I am still having issues with this. I hope you are still reading this chain of replies. Again, thank you for your help on this..... Gene -----Original Message----- Gene, Check out this link: /url? sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene . . |
| 2893 | Glad it's fixed, but I've used underscore in a lot of my module names since xl97. They've never (cross fingers here) given me trouble. (Well, the code does, but not the module names!) FYI only. Gene LaForest wrote: Sometimes I just crack myself up. I double checked the module names and the ones that it is choking on are ones that have an underscore in the name. I didn't think underscores were considered extended characters. Well if you can't laugh at yourself, who can you laugh at. Obscure problems are a headache to solve. That is why I REALLY REALLY REALLY apprciate your help on this problem. Gene -----Original Message----- Thank you so much for your quick reply! I checked the link but now I am confused. I never use anything from an extended character set. In fact, I never saved the original file as an Excel Add In. Additionally, the Excel97 machine already has SR-1, which the link says may fix the problem. I am still having issues with this. I hope you are still reading this chain of replies. Again, thank you for your help on this..... Gene -----Original Message----- Gene, Check out this link: /url? sa=U&start=1&q=/suppor t/kb/articles/Q171/2/17.ASP&e=912 HTH, Laura "Gene LaForest" <gno22@hotmail.com wrote in message news:1af0a01c231c1$c4971500$9ae62ecf@tkmsftngxa02... Hello. I am looking for some help regarding a really vague error message. I created a file in excel 2002 and saved it as a '97-2002 & 5.0/95'. I then move the file to another computer with Excel 97 on it. I open the file and the following message occurs: System Error &H80070057 (-2147024809). The Parameter is incorrect. The message box is labled Microsoft Visual Basic. OK and HELP are the only buttons. Help says it's a 'system generated error', but nothing else. If I hit OK, it procedes to the file where operation LOOKS normal. In this file I have a dozen sheets, 1 form, and several modules. If I remove the modules, it then opens fine. From a previous version, I only changed code in 2 of the modules, nothing of which should make this thing choke. Does anyone know why this may be happening?? ANY help would be appreciated! Thanks in advance..... Gene . . -- Dave Peterson ec35720@msn.com |
| 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. |
| 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 |
| 3078 | And as replied on the L-List, that doesn't work. Reason: Excel 2002 is already defined in the Open With dialog, and choosing "Other.." then selecting the XL2000 exe file, actually causes windows to register the file with XL2002, because the exe for XL97, XL2000 & XL2002 are all "Excel.exe".....and since XL2002 is the one ALREADY defined in the Open With dialog, Windows automatically chooses that one! -- Regards Julian Milano "Don Guillett" <donaldb@281.com wrote in message news:OqDQGxyMCHA.2320@tkmsftngp11... Just discussed on the L list Right click on an xls file while holding down the shift key, then select Open with... and either locate the version of Excel from the list or Browse for it. When you locate the file, be sure that the "Always use this program to open this type of file" is checked. HTH. -- Don Guillett SalesAid Software Granite Shoals, TX donaldb@281.com "Julian Milano" <jdmils@pacific.net.au wrote in message news:#gqHjsyMCHA.1744@tkmsftngp10... I have XL97, XL2000 & XL2002 on my system. At the moment, XL2002 is the default editor for XLS files on my system. I want to have XL2000 as the default. Is there a quick & easy way to achieve this? -- Regards Julian Milano |
| 3100 | hi running excel 2002 and windows 2k. despite having the box, tools:options:view: show startup task pane ticked, on opening excel the task pane shows for about a second on the right hand sideand then closes itself, anybody know a way to resolve this. tks and rgds steve |
| 3106 | A couple of queries, can anyone help ? I have just upgraded to Excel 2002. In a spreadsheet written in Excel 97 I had cells with data validation (from list) criteria. These cells were locked and when the sheet was protected, the user could still change the cell selection from the list. In Excel 2002, the validation still works but the cells that were locked cannot now be changed - the normal "the cell or chart...is protected" message comes up. Am I doing something wrong or is a new feature of 2002 ? I have checked the file on another PC still on Excel 97 and it still works as before. And.. as a general point, can anyone advise where I can get a useful summary of the new features/key changes in Excel 2002 ? Many thanks |
| 3108 | If you have a workbook that opens automatically as Excel starts up (e.g. Personal.xls), the Task Pane closes, despite the Task Pane setting. ************** Jim Rech posted the following solution: "I force mine to stay open despite Personal.xls with this registry setting: HKCU\Software\Microsoft\Office\10.0\Common\General\DoNotDismissFileNewTaskPane This is a DWORD key, set it to 1." ************************** To change the registry: 1. From the Start button, choose Run 2. Type regedit then click OK 3. Click the + sign to the left of HKEY_CURRENT_USER 4. Open Software, Microsoft, Office, 10.0, Common, and click on General 5. Choose EditNewDWORD Value 6. Type the name for the DWORD: DoNotDismissFileNewTaskPane 7. Press Enter to complete the renaming 8. Choose EditModify 9. Type 1 as the value and click OK 10. Close the Registry Editor steve wrote: hi running excel 2002 and windows 2k. despite having the box, tools:options:view: show startup task pane ticked, on opening excel the task pane shows for about a second on the right hand sideand then closes itself, anybody know a way to resolve this. tks and rgds steve -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 3127 | Thank you, I will give this a try. I should have said I am running Windows 98 and Excel 2000. "Dave Peterson" <ec35720@msn.com wrote in message news:3D3F26E4.99F6855A@msn.com... #1. I've always found the printing stuff a pain. Some printers work nicely, some don't (as you've seen). The best I can suggest is to format the worksheet for the worst printer you know about. Change the margins accordingly. Fiddle with the font size. (I always found it a hit and miss technique.) #2. This worked for me in xl2002 (you'll have to test it with your version). Option Explicit Sub testme() Dim wks As Worksheet Set wks = ActiveSheet With wks .Cells.CheckSpelling End With End Sub In excel 2002, it didn't matter if the worksheet was protected or not! I don't recall if that's how previous versions worked, though. If it doesn't work in your version, maybe you could try this: If you protect a sheet in VBA code, you can allow the program to make changes that the user couldn't from the userinterface. The bad news is that excel doesn't remember this between sessions for that workbook. It might be best to put something like this in the Auto_Open or workbook_open code. Sub Auto_Open() worksheets("sheet1").protect password:="topsecret", _ userinterfaceonly:=true end sub Then tell them to run a macro like this: Option Explicit Sub testme() Dim wks As Worksheet Set wks = ActiveSheet With wks .Cells.CheckSpelling End With End Sub (tools|macros|macros...|click and Run). <<I really don't remember this working with xl2k or xl97, so try it before you rely on it. Also, in xl2002, it allowed the locked cells of a protected worksheet to have spelling errors corrected. I'm not sure if you want that. You may want to limit the range, like: with wks .range("a9:b19").checkspelling end with Sharon Turner wrote: I work at a primary school and have designed the school reports using Excel and have locked the relevant cells and protected the worksheet so that the teachers cannot alter cell sizes or fonts (so that the report size remains constant) it was used last year, and is being used again this year. The two main problems that the teachers complain about are: The text fills the cells on screen, but when the reports are printed out the text overflows the cells, or the line breaks are not in the same place as on screen. Some teachers say that printing out on 100% (view is set to 66%, so you can see entire page without having to scroll around too much), sorts it out, others find that it doesn't. I find if on page break preview I drag the page break one cell over it helps, but some teacher are still having problems, it also seems ok on some printers and not on others (their home ones!). 1. Does anyone know how to get it so that what you see on screen is the same as what is printed out? 2. Is there a way to get the spell check to work when the spreadsheet is protected? Any help gratefully received. Sharon Turner -- Dave Peterson ec35720@msn.com |
| 3132 | You could unprotect the sheet, select the cells with validation, do formatcellsprotection, uncheck locked for the validation cells, then protect the sheet again. -- Regards, Peo Sjoblom "Ian" <badgerzz1@yahoo.co.uk wrote in message news:0f0301c233c0$76194460$3bef2ecf@TKMSFTNGXA10... A couple of queries, can anyone help ? I have just upgraded to Excel 2002. In a spreadsheet written in Excel 97 I had cells with data validation (from list) criteria. These cells were locked and when the sheet was protected, the user could still change the cell selection from the list. In Excel 2002, the validation still works but the cells that were locked cannot now be changed - the normal "the cell or chart...is protected" message comes up. Am I doing something wrong or is a new feature of 2002 ? I have checked the file on another PC still on Excel 97 and it still works as before. And.. as a general point, can anyone advise where I can get a useful summary of the new features/key changes in Excel 2002 ? Many thanks |
| 3161 | Is there any reason why I can't closed Excel 2002 by using the close button in the top right hand corner. Why would it be grayed out. The minimize and maximize button both work. The sheet is not protected. any ideas |
| 3176 | I have just converted to Excel 2002 and am having a bit of trouble with macros !! I have a macro which opens up a csv file (output file from an accounting package) and copies various columns of data into an existing excel file. My problem is that the the date column is coming as a mixture of formats. If I view the csv file through wordpad all the formats are dd/mm/yy (as text). If I open the csv file and copy and paste the data to excel, the formats are OK. If however, the csv file is opened using a macro, the mixture of formats ocurrs? I have looked at all the Windows settings and tried various options. This problem onlyocurrs when the csv file is opened using a macro and as soon as it is opened. HELP !! Thanks |
| 3177 | I have just converted to Excel 2002 and am having a bit of trouble with macros !! I have a macro which opens up a csv file (output file from an accounting package) and copies various columns of data into an existing excel file. My problem is that the the date column is coming as a mixture of formats. If I view the csv file through wordpad all the formats are dd/mm/yy (as text). If I open the csv file and copy and paste the data to excel, the formats are OK. If however, the csv file is opened using a macro, the mixture of formats ocurrs? I have looked at all the Windows settings and tried various options. This problem onlyocurrs when the csv file is opened using a macro and as soon as it is opened. HELP !! Thanks |
| 3188 | I just tried .spellchecking with xl2k (at work). I had to use the .userinterfaceonly:=true, to spell check a protected worksheet. Dave Peterson <ec35720@msn.com wrote in message news:<3D3F26E4.99F6855A@msn.com... #1. I've always found the printing stuff a pain. Some printers work nicely, some don't (as you've seen). The best I can suggest is to format the worksheet for the worst printer you know about. Change the margins accordingly. Fiddle with the font size. (I always found it a hit and miss technique.) #2. This worked for me in xl2002 (you'll have to test it with your version). Option Explicit Sub testme() Dim wks As Worksheet Set wks = ActiveSheet With wks .Cells.CheckSpelling End With End Sub In excel 2002, it didn't matter if the worksheet was protected or not! I don't recall if that's how previous versions worked, though. If it doesn't work in your version, maybe you could try this: If you protect a sheet in VBA code, you can allow the program to make changes that the user couldn't from the userinterface. The bad news is that excel doesn't remember this between sessions for that workbook. It might be best to put something like this in the Auto_Open or workbook_open code. Sub Auto_Open() worksheets("sheet1").protect password:="topsecret", _ userinterfaceonly:=true end sub Then tell them to run a macro like this: Option Explicit Sub testme() Dim wks As Worksheet Set wks = ActiveSheet With wks .Cells.CheckSpelling End With End Sub (tools|macros|macros...|click and Run). <<I really don't remember this working with xl2k or xl97, so try it before you rely on it. Also, in xl2002, it allowed the locked cells of a protected worksheet to have spelling errors corrected. I'm not sure if you want that. You may want to limit the range, like: with wks .range("a9:b19").checkspelling end with Sharon Turner wrote: I work at a primary school and have designed the school reports using Excel and have locked the relevant cells and protected the worksheet so that the teachers cannot alter cell sizes or fonts (so that the report size remains constant) it was used last year, and is being used again this year. The two main problems that the teachers complain about are: The text fills the cells on screen, but when the reports are printed out the text overflows the cells, or the line breaks are not in the same place as on screen. Some teachers say that printing out on 100% (view is set to 66%, so you can see entire page without having to scroll around too much), sorts it out, others find that it doesn't. I find if on page break preview I drag the page break one cell over it helps, but some teacher are still having problems, it also seems ok on some printers and not on others (their home ones!). 1. Does anyone know how to get it so that what you see on screen is the same as what is printed out? 2. Is there a way to get the spell check to work when the spreadsheet is protected? Any help gratefully received. Sharon Turner |
| 3197 | Hi Martin: I highly recommend Excel 2002 formulas by John Walkenbach published by Hungry Minds. It is an excellent source of info an the matters you are interested in. Give it a look. Robert Eslinger -----Original Message----- Hello all, I'm looking for a book to help me increase my knowledge of Excel 2000. I consider myself a pretty competent user, but I want to move to the next level - using database functions, array formulas, VBA programming etc. Can anyone recommend a good book? There appear to be lots of them out there - I could use some guidance on which is the best. Thanks, Martin . |
| 3209 | I have developed a spreadsheet in Excel 97 on a computer I no longer have access to and I believe it has commercial application. I want to buy a licensed copy of Excel but am concerned that if I buy Excel 2002 and send the file to someone who only has Excel 97 or 2000, then the file may lose some functionality. Can I buy 2002 and save the file in 97 format without causing a problem in backwards compatibility? Am I better to buy Excel 97 so that my version is always behind or level with that of any potential clients? If I am better off doing this, how can I buy a copy of 97? |
| 3223 | Dear John Re the last question, I recently bought a legal new copy of Office 97 Pro in a small computer shop for UK£70. That's a lot of processing power for a small outlay. It's also available from time-to-time via Auction sites like Ebay (but it must have the original packaging and product id). For obvious reasons Microsoft frowns on people trying to buy cheaper, earlier versions. Nobody has yet given me any persuasive reason to upgrade. (at work, there is a mixture of 97 and 2000, and no problems with compatibility). Cheers Andrew "John percy" <linkagesolutions@bigpond.com.au wrote in message news:134f01c23453$532e5330$9be62ecf@tkmsftngxa03... I have developed a spreadsheet in Excel 97 on a computer I no longer have access to and I believe it has commercial application. I want to buy a licensed copy of Excel but am concerned that if I buy Excel 2002 and send the file to someone who only has Excel 97 or 2000, then the file may lose some functionality. Can I buy 2002 and save the file in 97 format without causing a problem in backwards compatibility? Am I better to buy Excel 97 so that my version is always behind or level with that of any potential clients? If I am better off doing this, how can I buy a copy of 97? |
| 3233 | Hi John I think the warning message you get when saving to an older version is overstated. Excel 97 is a comprehensive package and the improvements you may lose in later versions don't have much practical effect eg can't have the filename & path in the footer. I work in a company with 4000+ users and we upgraded from 95 to 97 to 2000 within 6 months with no instances of users losing functionality as it seems you have to be a professional developer to use the functions affected. You can also "Save As" Microsoft Excel Workbook rather than a specific version to avoid down saving to a specific older version. Tim Tim -----Original Message----- I have developed a spreadsheet in Excel 97 on a computer I no longer have access to and I believe it has commercial application. I want to buy a licensed copy of Excel but am concerned that if I buy Excel 2002 and send the file to someone who only has Excel 97 or 2000, then the file may lose some functionality. Can I buy 2002 and save the file in 97 format without causing a problem in backwards compatibility? Am I better to buy Excel 97 so that my version is always behind or level with that of any potential clients? If I am better off doing this, how can I buy a copy of 97? . |
| 3257 | I don't have 97 installed (it's in Swedish and I don't want to mix different language versions), I usually just click in one cell somewhere, then press F5.. -- Regards, Peo Sjoblom "Dave Peterson" <ec35720@msn.com wrote in message news:3D40AF7F.ED65D6E@msn.com... Hmmm. I like to press ctrl-A just to make sure there isn't a current multicell selection. Sometimes I forget what I have selected! (Do you still have xl97? Did/does it work that way???) Peo Sjoblom wrote: You don't even have to press ctrl+A, just press F5 or editgo to, it will select those cells regardless. And I can only agree with the last point regarding Dave's memory <g -- Regards, Peo Sjoblom "Dave Peterson" <ec35720@msn.com wrote in message news:3D406CA5.80C9DF08@msn.com... And if you want to get all the cells with validation in one shot, you can do: ctrl-A (to select the whole sheet) Edit|goto|special click on Data Validation (bottom right corner) Then Cells|format|protection tab stuff that Peo describes. (But I don't recall that xl97 worked this way. Are you sure???) ==== As for the what's new in xl2002, notice the little combobox on the far right of the menubar. Type "what's new" in that box and hit enter. Then click on the first option. You'll see a pretty substantial list. ===== Not to harp too much, but are you sure that you had data|validation dropdowns with xl97??? (I'm getting older and my memory ain't what it used to be....) Peo Sjoblom wrote: You could unprotect the sheet, select the cells with validation, do formatcellsprotection, uncheck locked for the validation cells, then protect the sheet again. -- Regards, Peo Sjoblom "Ian" <badgerzz1@yahoo.co.uk wrote in message news:0f0301c233c0$76194460$3bef2ecf@TKMSFTNGXA10... A couple of queries, can anyone help ? I have just upgraded to Excel 2002. In a spreadsheet written in Excel 97 I had cells with data validation (from list) criteria. These cells were locked and when the sheet was protected, the user could still change the cell selection from the list. In Excel 2002, the validation still works but the cells that were locked cannot now be changed - the normal "the cell or chart...is protected" message comes up. Am I doing something wrong or is a new feature of 2002 ? I have checked the file on another PC still on Excel 97 and it still works as before. And.. as a general point, can anyone advise where I can get a useful summary of the new features/key changes in Excel 2002 ? Many thanks -- Dave Peterson ec35720@msn.com -- Dave Peterson ec35720@msn.com |
| 3649 | I'm using the same... Excel 2002 (10.2614.2625) Windows XP (6.00.2600.0000) "Bruce Sinclair" <bruce.sinclair@NOSPAMagresearch.NOTco.NOTnz wrote in message news:vQp19.287$wn1.69121@news02.tsnz.net... In article <#AF8CnqNCHA.1608@tkmsftngp09, "DeeLight" <deelight@f-m.fm wrote: Each time I try to use font size 7, it automaticaly uses font 'small fonts' as if Tahoma or Verdana was unreadable at size 7. If there a way to bypass this, and be able to actualy see the normal font at size 7? It just does what I tell it (I tried Times new roman and tahoma). I'm using XP and office 2002. What versions of things are you running ? Might make a difference :) Bruce -------------------------------------------------------------------- Oook ! NOTE remove the not_ from the address to reply. NO SPAM ! |
| 3680 | In article <OoW2k0COCHA.1620@tkmsftngp10, "DeeLight" <deelight@f-m.fm wrote: I'm using the same... Excel 2002 (10.2614.2625) Windows XP (6.00.2600.0000) Then I'm left totally confused ... sorry :) "Bruce Sinclair" <bruce.sinclair@NOSPAMagresearch.NOTco.NOTnz wrote in message news:vQp19.287$wn1.69121@news02.tsnz.net... In article <#AF8CnqNCHA.1608@tkmsftngp09, "DeeLight" <deelight@f-m.fm wrote: Each time I try to use font size 7, it automaticaly uses font 'small fonts' as if Tahoma or Verdana was unreadable at size 7. If there a way to bypass this, and be able to actualy see the normal font at size 7? It just does what I tell it (I tried Times new roman and tahoma). I'm using XP and office 2002. What versions of things are you running ? Might make a difference :) -------------------------------------------------------------------- Oook ! NOTE remove the not_ from the address to reply. NO SPAM ! |
| 3698 | The file is corrupt. Depending on how corrupt, you may be able to open it with Excel 2000, but will probably lose the formatting. Excel 2002 can probably open and repair it. I get these types of errors when BackupExec 7.5 on my Novell 3.12 server backs up an excel file that is in use. Tim C "John Longsworth" <j_longsworth@hotmail.com wrote in message news:00c001c238cc$06656f70$9ae62ecf@tkmsftngxa02... Hi, I've been trying to open an excel file for the last hour or so. When I open it I get the following error: 'File' 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 resonding. We've tried this all over the network, on about 9 different computers, under admin logon and user logon and under the logon of the user that created the file. I tried cutting and pasting the file into another location, that worked fine, so no other user could have exclusive access to it. The permissions on the folder and the file are set for everyone to use. No locks on any of it. Any ideas on what could be causing the problem?? Thanks. |
| 3699 | I can publish a spreadsheet or chart to the web with no problems using Excel 2002. If I add controls such as a button, this never shows up in the web page - can you add these controls from within Excel and export to the web? |
| 3842 | Sorting Maiden & Married Names for a Directory I am doing a reunion directory and have been furnished a simple Excel spreadsheet with columns for maiden name (col B), last name (col C), and first name (col D) (and address, phone, etc.). The men have no entries in the maiden names column. I’m using Excel 2002 with XP Pro. I want to import this into an MS Word directory so the directory is sorted on the last name, if there is no maiden name. If there is a maiden name, it should be sorted with the men’s last name like: Adams, John Burgess Simon, Patricia (Burgess is the maiden name, Simon is the last name) Caldwell, Mike Diamond Putnam, Julie (Diamond is the maiden name) I can do the import into MS Word OK except for the complex sort. Is there a way to sort the spreadsheet to get the above result? Hope I have made my dilemma clear. Thanks for any help. Dennis |
| 3843 | Just create a column E and put this formula in it: =IF(B1="",(C1&","&D1),(B1&" "&C1&","&D1)) not tested, adria "Dennis Hughes" <dvhughes@mindspring.com wrote in message news:3D4A0577.CEF62B29@mindspring.com... Sorting Maiden & Married Names for a Directory I am doing a reunion directory and have been furnished a simple Excel spreadsheet with columns for maiden name (col B), last name (col C), and first name (col D) (and address, phone, etc.). The men have no entries in the maiden names column. I'm using Excel 2002 with XP Pro. I want to import this into an MS Word directory so the directory is sorted on the last name, if there is no maiden name. If there is a maiden name, it should be sorted with the men's last name like: Adams, John Burgess Simon, Patricia (Burgess is the maiden name, Simon is the last name) Caldwell, Mike Diamond Putnam, Julie (Diamond is the maiden name) I can do the import into MS Word OK except for the complex sort. Is there a way to sort the spreadsheet to get the above result? Hope I have made my dilemma clear. Thanks for any help. Dennis |