| Article | Body |
| 88 | Note: If you have Excel 2000 or Excel 2002, EUR is one of the available currency symbols, so steps 5 and 6 are not required. Debra Dalgleish wrote: 1. Select the cells 2. Choose FormatCells 3. On the Number tab, choose Currency or Accounting 4. Select the number of decimal places, and negative number formatting that you prefer; select $ as the Symbol. 5. Choose the Custom Category 6. In the Type box, replace each $ with: "EUR " 7. Click OK Andy Walawender wrote: Does anyone known how to / whether it is possible to insert text into a column of already filled cells. ie column of cells with numeric values to which I want to add the string "EUR " for euro in front of the the monetary values without deleting or clearing the cells. (There's hundreds of them so doing each one manually is pretty tedious !!) Thanks for yr help Andy -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 3869 | Hi Dennis , You have to put in a row for the married (current) name and a row for the maiden (high school) name. The current name should have all of the information. The high school name should simply point to the current name. Then you can sort on the name. Without both rows no one will be able to find information. If you have some famous people you may even have men who changed their names <grin. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "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 |
| 3882 | Thanks for the help Adria and David I added a column E for the "Sorted Name" which should contain the last name of the males and the maiden name (only) for the females. I don't understand formulas well, but looking at Adria's formula I think that gives both names for the ladies which I don't need right here. When I paste the formula in it works OK for the men, but gives a #NAME? when there is a maiden name. I think I need a formula that says if there is a maiden name (col B) use it, if col B is empty, then use col C. Any thoughts if that will work? One more question, once I get the formual, how can I copy it from row to row and have it automatically change the row numbers, so I don't have to manually change each formula? Much thanks, Dennis ========================= Dennis Hughes wrote: 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 |
| 3886 | Adria & David, Got it figured out with your help. The F1 help was no help at all in using the conditional formulas, but I experimented (& learned) =IF(B2="",(C2),(B2)) gives me exactly what I want. The F1 help did clearly explain how to copy the formulas to the entire column, automatically changing the row numbers. Thanks again, Dennis Dennis Hughes wrote: 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 |
| 3924 | An AutoFilter dropdown list will only show 1000 entries. The column that you're filtering probably contains more unique items than that limit. You could add a new column, to extract the first few letters of the item, e.g. =Left(A2,3), and filter on that, then filter by the original column. Or you could split the list into 2 or three groups, e.g.: =IF(LEFT(A2,1)<"N","A-M","N-Z") Another option is to choose Custom from the drop-down list, and type the criteria. Mark wrote: I have a mailing list on Excel 2002 with about 2,500 rows. The autofiltering filters only to around row 1,700. I know Office 97 & 2000 have internal limitations on the autofiltering in Excel, but I thought that limitation was removed in Office XP. Am I overlooking something to make XP filter the entire database, or is that limitation still there & immoveable? -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 4063 | Hi Michael, You would need to use a macro for Excel 2000 and anything earlier. Excel 2002 has the ability to do this but anybody using that file would also have to have Excel 2002 to get the same results. You would install in ThisWorkbook instead of a standard code module. ThisWorkbook is found at the end of all of your object modules and has this specific name. To find use (Alt+F11, Ctrl+R) look at the project, look at "Microsoft Excel Objects" (as opposed to "Modules" and "References"), expand objects and look for ThisWorkbook at the end. Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName End Sub More more information on headers, footers and pathname see /dmcritchie/excel/pathname.htm HTH,, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Michael H" <mhysinger@hlmx.com wrote ... I'd like to set Excel to automatically put the FULL path name of the file into the footer. Currently I'm only able to add the File name in the footer. I'm using Excel 2000 |
| 4140 | In Excel 97 and 2000 you can use an autofilter on a protected sheet if you (1) enable it, and (2) protect the sheet with Userinterfaceonly set to True: Sheet1.EnableAutoFilter = True Sheet1.Protect userinterfaceonly:=True The later setting is not retained with the workbook when saved so it must be reset when the workbook is re-opened. In Excel 2002 you can enable autofilter through the user interface (Tools, Protection, Protect Sheet). -- Jim Rech Excel MVP |
| 4207 | Dear all, I had faced a problem in Excel 2002 on opening the Excel 97 file saved with zoom other than 100%. It takes me hours to open the file. However, after opening the file and save the again with 100% zoom. The problem would be solved. Could you please find any solution to solve the problem? Thank you very much! Best Regards, George Cheng |
| 4208 | Hi, When emailing from Excel 2002, you always get an Outlook warning telling that some process is trying to email on your Behalf. It's really a pain when you're emailing in a loop ... Has someone a tip to avoid that ? TIA, Olivier. |
| 4210 | I don't get that warning, however you would probably be better off posting in an Outlook NG.. microsoft.public.outlook.general -- Regards, Peo Sjoblom "Olivier Sanzot" <olivier.sanzot@solvay.com wrote in message news:144701c23df8$13531170$9ee62ecf@tkmsftngxa05... Hi, When emailing from Excel 2002, you always get an Outlook warning telling that some process is trying to email on your Behalf. It's really a pain when you're emailing in a loop ... Has someone a tip to avoid that ? TIA, Olivier. |
| 4291 | You should always mention your Excel version. I was able to duplicate your problem with Excel 2000 (a 20 character numeric string came in in scientific number format) but it was okay in Excel 2002. So you should upgrade<g. Actually I didn't play with it long but the only way I could get Excel 2000 to work was to precede the string with a character like ^ or '. It would be nice if some invisible character would also do this but the obvious one, a space, didn't. -- Jim Rech Excel MVP |
| 4308 | I noticed that Sue Mosher, an excellent Outlook MVP, responded to this question in the newsgroup "microsoft.public.outlook.program_vba" under the same subject heading. You may want view her page "Outlook Email Security Update" at /outlook/esecup.htm#autosec as well as her home page. -- Dana DeLouis Windows XP & Office XP = = = = = = = = = = = = = = = = = "Olivier Sanzot" <oliviersanzot@msn.com wrote in message news:3d50ef10$0$283$ba620e4c@news.skynet.be... Hi, When emailing from Excel 2002, you always get an Outlook warning telling that some process is trying to email on your Behalf. It's really a pain when you're emailing in a loop ... Has someone a tip to avoid that ? TIA, Olivier. |
| 4326 | I don't think it's really a bug but, regardless, all those ways around Data Validation are still in Excel 2002. I wouldn't expect MS to address them any time soon. -- Jim Rech Excel MVP |
| 4350 | In Excel 2000 I was able to make a PO system that used this numbering add-in to share numbers accross a network (stored in another excel file) - Now when I try to open it up in Excel 2002 it says I need this numbering add-in - I cannot find it any-where.. What is going on here? I upgrade and LOOSE features? HELP! -Michael |
| 4356 | Jim, I run excel 2000 9.0.2720. When in Excel, prepending a coma does indeed prevent reformating to scientific notation (however, prepending a caret simply displays a caret (^) as the first character). Anyways, I modified my app to prepend a single quote (') to my character strings representing numbers in my HTML table. But Excel simply displays the single quote. In other words, the HTML cell "<td'1000100000</td" appears as "'1000100000". The quote only 'disappears' if I put it from within Excel. So, what should/can I do, besides upgrading to 2002 ? By the way, upgrading is not an option : I cannot force everybody using my app to upgrade to Excel 2002. Thanks, Martin. |
| 4428 | No, I didn't mean it was unnatural. However, for many users using VBA is scary. Also, I'm at a different location right now. On this machine (excel 2002) your suggestion works, however at the other location (excel 2000 and 97) I don't believe that worked. "Dave Peterson" <ec35720@msn.com wrote in message news:3D52F41E.B4B336E5@msn.com... You could: Tools|Protection|Protect sheet Then Format|Sheet|Hide (you can't set it to veryhidden via the userinterface, though) Are you saying VBA is unnatural???? <vbg Tom B wrote: Hi, I'd like to password protect and hide a worksheet. I was able to do it using VBA, but am curious if there is a more natural way. Thanks Tom B -- Dave Peterson ec35720@msn.com |
| 4489 | Hi Ed, Did a search on the MSKB for slow save within Excel 2002 XL: Workbook Protected or Saved with a Password Is Saved Very Slowly /default.aspx?scid=kb;en-us;Q212147 The article is for both Excel 2000 and Excel 2002, so it doesn't seem like a new problem with Excel 2002. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Ed Albert" <cea7002@axe.humboldt.edu wrote in message news:3D53051B.E398767A@axe.humboldt.edu... Nothing there to speak of that I need to clear out .... although I did it anyway, and it didn't make a difference. Norton 2000 is configured for every PC the same, Win XP and Win 98 alike; and the Win 98s don't have this problem .... only occurs for the Win XP with Office XP. These spreadsheets were saved "as" the current version of Excel to avoid having issues like you describe with the version saves. For whatever it is worth, the problem is not limited to one spreadsheet ... it seems to universally applied (and ctrl-end on the ones I checked went to where the logical end should have been. FYI: As far as this server goes, I am the administrator for it ... and I've checked the NT settings to be certain nothing odd occurring on the server side. No network blips, space problem or security issues ... wrote: Hi Ed, Try clearing out your internet temporary files. Excel renames files to protect your data while making changes. This conflicts with security issues with Antivirus programs and with your Data Administrator. See if you can get the Data/Network Administrator to turn off Antivirus protection to see if problem goes away. If it does you will have to check with you AV vendor about issues with Excel. If it doesn't go away it is possibly the rules that your Data/Security Administrator has created. If you have Norton AV the following may be helpful though it mentions opening not closing Excel files /search/preview.aspx?scid=kb;en-us;Q262530 Searching the MS KB for your version of Excel and the name of your AV program might prove fruitful. It think there are some Excel issues as well. Make sure that your are not saving in multiple formats (i.e. Microsoft Excel 97-2000 & 5.0/95 Workbook *.xls ) Do you see anything on status bar when saving, or a message asking if you want to store in Excel 2000 format. If your lastcell position, found with Ctrl+End, is way off into the hinterlands on your worksheets, you should check further into this and if incorrect remove the extraneous empty rows and columns at the end. More info in /dmcritchie/excel/lastcell.htm For more information and additonal things to check see Slow Response and Memory Problems /dmcritchie/excel/slowresp.htm HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Ed Albert" <cea7002@humboldt.edu wrote in message news:1f2601c23f06$a2d90340$b1e62ecf@tkmsftngxa04... Several users of Excel 2002/XP have complained about the extreme slowness in saving their spreadsheets to a shared drive on our Windows NT 4.0 (SP6a) server. Have observed that some saves can take as much as 2-3 minutes or more, for a fairly simple spreadsheet with 5-6 columns of data in about 300 rows. This slowness problem did not exist when the Office 2000 Professional version of Excel was being used. These PCs are all Dell 8100s, with Windows XP Professional edition factory installed. |
| 4502 | These are new features so you have to upgrade to Excel 2002 to get them. -- Jim Rech Excel MVP |
| 4560 | I am using Excel 2002 in Windows XP. I would like to activate the "recently used files" option on the TOOLS-OPTIONS-GENERAL TAB. This option is currently grayed out,it was operating for a brief time and then stopped. I am not sure why but it may/may not be related to my installing Tweak UI for XP. I am using Office XP and I think this option is available in all programs. Any help would be greatly appreciated - Thanks Bill Chatfield |
| 4563 | The following MSKB article has information on this: OFFXP: "Most Recently Used" List Missing from File Menu and "Recently Used File List" Option Unavailable /default.aspx?scid=kb;EN-US;q284896 bill chatfield wrote: I am using Excel 2002 in Windows XP. I would like to activate the "recently used files" option on the TOOLS-OPTIONS-GENERAL TAB. This option is currently grayed out,it was operating for a brief time and then stopped. I am not sure why but it may/may not be related to my installing Tweak UI for XP. I am using Office XP and I think this option is available in all programs. Any help would be greatly appreciated - Thanks Bill Chatfield -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 4568 | Debra, Thank you for the reply. I was using a version of TweakUI for XP that did not have the "IE" tab mentioned in the below article. I uninstalled that TweakUI version and installed an older on, I believe it is 1.33. Now all is well with the "recently used files" option in Office XP. I am curious to see what else may pop up with this version of TweakUI in Windows XP. Thanks again, Bill Chatfield "Debra Dalgleish" <dsd@contextures.com wrote in message news:3D566ECF.8010101@contextures.com... The following MSKB article has information on this: OFFXP: "Most Recently Used" List Missing from File Menu and "Recently Used File List" Option Unavailable /default.aspx?scid=kb;EN-US;q284896 bill chatfield wrote: I am using Excel 2002 in Windows XP. I would like to activate the "recently used files" option on the TOOLS-OPTIONS-GENERAL TAB. This option is currently grayed out,it was operating for a brief time and then stopped. I am not sure why but it may/may not be related to my installing Tweak UI for XP. I am using Office XP and I think this option is available in all programs. Any help would be greatly appreciated - Thanks Bill Chatfield -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 4699 | On Tue, 13 Aug 2002 09:13:14 +0600, Zargham Malik <zhmalik@yahoo.com wrote: Hi, Apologize for the botheration but can you recommended the best two (2) books which will allow a person wanting to fully learn VBA (taking from beginner to ideally the advanced level). Any URL's in this regard would also be appreciated. John Walkenbach's book is often recommended /asp/full_details.asp?isbn=0764547992 as is Rob Bovey et al's Excel 2002 VBA: /asp/full_details.asp?isbn=1861005709 (I'm sure there are more comprehensive summaries at the publishers' web sites, but the ones above give you the general idea.) --------------------------------------------------------- Hank Scorpio apolloXVIII@ozemail.com.au Change XVIII to 18 for real address. * Please keep all replies in this Newsgroup. Thanks! * |
| 4827 | Hello, All, Word 2002 and Excel 2002 I've tried searching both the Excel and Word newsgroups but haven't found anything quite like this problem. . . . Previous employees here have created hundreds of instruction/training documents in Word using a standard format. Format includes, on separate lines, "Scenario Name:", "Scenario Number:" and "Scenario Description:". In Excel, I would like to open each file, extract the information for each of the three lines, and make a cross reference index of each of the three fields. Hyperlinks are unnecessary, I only want to get the data compiled into an Excel file wgere they can look up which Word document to open. I am unable to even figure out how to get the Word documents to open with Excel, and/or how to locate each of the lines beginning with the above texts. If it would be easier to create the index in Word and copy it to Excel, that would work for me, too. Any suggestions? TIA, Steve |
| 4944 | Hi Sam, Based on your maximizing the window to see the rest of your spreadsheet tabs indicates you were not talking about hidden sheets. Here are some more suggestions. You can move the vertical bar between the sheet names and the horizontal scroll bar. You can use any of the four buttons to the left of the sheet names (tabs) to see other sheet tabs. You can right click on any of those four buttons to the left of the sheet names to pull up a list of sheetnames in the same order as you see them and navigate to the sheet from that list. Once you have more than 15 names things can become a bit unwieldy with the navigation in trying to find them relative to where you are looking, so at some point it would be practical to sort the sheet names into alphabetical order and rename sheets you want in front and rename some sheets so they are seen as part of groups. i.e. $$ TOC, k.Function keys, k.keyboard shortcuts You can rearrange a few sheets by dragging to sheet tab before or after another tab, but to really do this efficiently you would need a macro to sort your worksheets tabs, such the SortAllSheets macro by Bill Manville, which you can see at /dmcritchie/excel/buildtoc.htm Excel 2002 has colored worksheet tabs, wonder if anyone who just had to have this feature really found it really that useful I expect not, but there were a lot of Lotus 1-2-3 users very dissatisfied that Excel did not have coloured sheet tabs. (Excel 2002 only): RClick on sheet tab, Color and considered that as the means to organize sheet tabs. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Sam" <strammel@wctc.net wrote ... Thanks a lot ,Don [Guillett] . This was my first experience with the ng. I found a similar problem question and a suggestion to maximize the file, and voila!, it worked. |
| 4945 | I have a merged cell the contains a lot of data. For some reason, it is all not displayed. All of the data will "pop" in there when I double-click on the cell. I cannot figure out why it is all not showing to begin with. I have 11 other merged cells that are behaving normal. Just this ONE cell is making me double-click. An suggestions on what I can check ? I am using Excel 2002, however the spreadsheet is acting the same in 2000. I even copied & pasted the data into Word, then copied & pasted it back into a brand new spreadsheet, but I still had to double click to see the data. HELP ! |
| 4948 | Check the alignment of the cell. Make sure it is wrap text and left-aligned. "lynn" <lynn_1968@yahoo.com wrote in message news:277201c24472$5cf7cf20$2ae2c90a@phx.gbl... I have a merged cell the contains a lot of data. For some reason, it is all not displayed. All of the data will "pop" in there when I double-click on the cell. I cannot figure out why it is all not showing to begin with. I have 11 other merged cells that are behaving normal. Just this ONE cell is making me double-click. An suggestions on what I can check ? I am using Excel 2002, however the spreadsheet is acting the same in 2000. I even copied & pasted the data into Word, then copied & pasted it back into a brand new spreadsheet, but I still had to double click to see the data. HELP ! |
| 4963 | Also how much data is actually in the cell, refer to "Specification" in HELP. Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. "Bob Umlas" <rumlas@kpmg.com wrote in message news:OmzZdMHRCHA.2512@tkmsftngp11... Check the alignment of the cell. Make sure it is wrap text and left-aligned. "lynn" <lynn_1968@yahoo.com wrote in message news:277201c24472$5cf7cf20$2ae2c90a@phx.gbl... I have a merged cell the contains a lot of data. For some reason, it is all not displayed. All of the data will "pop" in there when I double-click on the cell. I cannot figure out why it is all not showing to begin with. I have 11 other merged cells that are behaving normal. Just this ONE cell is making me double-click. An suggestions on what I can check ? I am using Excel 2002, however the spreadsheet is acting the same in 2000. I even copied & pasted the data into Word, then copied & pasted it back into a brand new spreadsheet, but I still had to double click to see the data. HELP ! |
| 5024 | Running Excel 2002, Windows 2000 machine, 256MB memory. I am trying to import a data file from an AS400 using the Transfer Data From AS400 add-in. There is no problem connecting to the AS400, but the data import does not get all the rows that are available. It will only get the first 16,000 rows; I am able to get the entire 35,000 rows on another machine using the exact same query. Does anyone know what would cause this? Thanks. |
| 5087 | Client Access? I think the author of the addin assumed that everyone ran xl95 where 16384 rows were the limit. Can you transfer the file to a .txt file and use xl to import it (instead of using the addin). C wrote: Running Excel 2002, Windows 2000 machine, 256MB memory. I am trying to import a data file from an AS400 using the Transfer Data From AS400 add-in. There is no problem connecting to the AS400, but the data import does not get all the rows that are available. It will only get the first 16,000 rows; I am able to get the entire 35,000 rows on another machine using the exact same query. Does anyone know what would cause this? Thanks. -- Dave Peterson ec35720@msn.com |
| 5171 | Thanks, Dave. On speaking with IBM, we need to upgrade our version of Client Access. Clay On Fri, 16 Aug 2002 17:27:22 -0500, Dave Peterson <ec35720@msn.com wrote: Client Access? I think the author of the addin assumed that everyone ran xl95 where 16384 rows were the limit. Can you transfer the file to a .txt file and use xl to import it (instead of using the addin). C wrote: Running Excel 2002, Windows 2000 machine, 256MB memory. I am trying to import a data file from an AS400 using the Transfer Data From AS400 add-in. There is no problem connecting to the AS400, but the data import does not get all the rows that are available. It will only get the first 16,000 rows; I am able to get the entire 35,000 rows on another machine using the exact same query. Does anyone know what would cause this? Thanks. |
| 5443 | Can anyone help me with regard to the import of a .csv file into excel? I'm running Excel 2002 and windows 2000 on my PC, and when our accounts package creates a .csv file, excel persists in switching the dates from United Kingdom style dates (dd/mm/yyyy) to United Dates style dates (mm/dd/yyyy)where the date is below 12. For example, dates from 01/10/2001 - 12/10/2001 are converted into 10/01/2001 - 10/12/2001. It does not happen where the date is above 12 i.e. it does not switch 13/10/2001 to 10/13/2001. This problem never used to happen when I was using the same accounts package and Excel 97 and Windows 98, so it must be something to do with the set up of the latter 2 programs. Incidentally, when I ask our accounts package to produce a .txt file, the dates are shown in the correct format i.e. dd/mm/yyyy , and therefore proves that it is not the accounts package which is at fault. I hope somebody can help. Many Thanks |
| 5462 | When attempting to save an Excel file as a website onto an linux/FTP site, Excel 2000 would create the following files on the server: filename.htm (File) filename_files/file1 (Directory/file) filename_files/file2 So there was one file and then all the other gif files, etc were created under a directory. Now with Excel 2002 and also Word 2002, if the site you are saving to is a unix/linux host, the backslash directory convention used by Microsoft causes new the directory not to be created. What you end up with is: filename.htm (FILE) filename_files\file1 (FILE) filename_files\file2 (FILE) This causes the unix/site admin to have to manually create a directory and move the files. Any ideas if or when Microsoft will fix this? This seems to me to be another case of unfair business practices my microsoft. They are trying to exclude Linux/Unix from the market? Anyone want to join a class action law suit? Thanks. |
| 5564 | Don, Thanks for the reply. I should have mentioned that I'm using Excel 2002. There isn't an option to "Save". Nina -----Original Message----- It doesn't say so but, maybe, SAVE. then close. -- Don Guillett SalesAid Software Granite Shoals, TX donaldb@281.com "Nina D." <nina_dilorenzo@dai.com wrote in message news:c6b701c24958$7677af20$39ef2ecf@TKMSFTNGXA08... Hi - I'm trying to permanently remove smart tags in Excel. I've done the following: 1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tags tab. 2. Clear the Label data with smart tags check box, and clear the Embed smart tags in this workbook check box. 3. Close and reopen the workbook for your changes to take effect. For some reason, the above changes do not take affect. Any advice? Thanks! . |
| 5568 | I'm not sure what you're still seeing, but try the following: 1. Choose ToolsOptions 2. On the Edit tab, remove check marks from 'Show Paste Options buttons' and 'Show Insert Options buttons' 3. Click OK Nina D. wrote: Don, Thanks for the reply. I should have mentioned that I'm using Excel 2002. There isn't an option to "Save". Nina -----Original Message----- It doesn't say so but, maybe, SAVE. then close. -- Don Guillett SalesAid Software Granite Shoals, TX donaldb@281.com "Nina D." <nina_dilorenzo@dai.com wrote in message news:c6b701c24958$7677af20$39ef2ecf@TKMSFTNGXA08... Hi - I'm trying to permanently remove smart tags in Excel. I've done the following: 1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tags tab. 2. Clear the Label data with smart tags check box, and clear the Embed smart tags in this workbook check box. 3. Close and reopen the workbook for your changes to take effect. For some reason, the above changes do not take affect. Any advice? Thanks! . -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 5641 | One instance of when posting to multiple newsgroups is okay is when you have something to do with Word *and* Excel, but that would be to *one* Word newsgroup and *one* Excel newsgroup. The word newsgroup people are usually the people who answer, but in the Excel newsgroup we might learn something about Word -- you never know. The only thing in Word, I'm much familiar with is using MS Word to print address labels using Excel as a database to feed it the information. If that is what you want take a look at /dmcritchie/excel/mailmerg.htm then since nobody but you would know if a wild guess was what you wanted post back here; otherwise, you'll probably have to wait for a person from a Word newsgroup to come into the Excel newsgroup, and probably ask you more questions, about what you want to do. At the bottom of my mailmerg.htm page are some references to some MS Word websites you might find useful. HTH, More friendly if you use a name we can call you by. , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Excel" <Excel@word wrote in message news:6c6601c24a00$36d02020$35ef2ecf@TKMSFTNGXA11... I need to transfer an existing Excel 2002 document that is not a numerical document into Word 2002. I checked the Q articles. Nothing helped. Also, edit, copy, open up word and paste, did not work. What should I do? |
| 5651 | Note that Excel 2002 now supports this. The &Z formatting code inserts the Path in the header. Therefore, the &Z&F code combination will insert the FullName in to the header. Both are available in the FilePage SetupHeader And Footer dialog. &Z is available only in Excel 2002 -- it is not supported in earlier versions. For earlier versions, use J.E.'s code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com chip@cpearson.com "J.E. McGimpsey" <jemcgimpsey@mvps.org wrote in message news:220820021757049379%jemcgimpsey@mvps.org... One way: Put this in the ThisWorkbook code module (right-click on the workbook title bar, choose View Code, paste the following in the window that opens, then click the XL icon on the toolbar to return to XL): Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In ActiveWindow.SelectedSheets wkSht.PageSetup.LeftFooter = ActiveWorkbook.FullName Next wkSht End Sub In article <3D657852.7719F69B@gis.net, Rubem Fabisiewicz <rubee@gis.net wrote: Hi, How can I put a "file and path" automatically on footer of my Excel worksheet like in Microsoft word? So if I change directory or folder the footer will change automatically. Thank you. Rubem |
| 5667 | hi, In excel 97 and even in excel 2002 that we have in our office, if you try and enter any date beyond 2029 in the ddmmmyy format e.g 28aug30, the year in the date defaults back to 1930 instead of 2030. Have any of you faced this problem and any remedy for the same ? |
| 5670 | Don't recall if it was added in XL02, but in XL01 and XLv.X (Mac versions), there's a spinner control in Preferences/Options/Edit (Tools/Options/Edit for WinXL) labeled "Assume 21st century for two-digit years bfore:". The default is 30, but if you set it to, say, 60, then entering 28aug59 will result in the date having the year 2059, not 1959. In article <657301c24a63$0b545890$37ef2ecf@TKMSFTNGXA13, gordon rodrigues <gordonrodrigues@hsbc.com wrote: hi, In excel 97 and even in excel 2002 that we have in our office, if you try and enter any date beyond 2029 in the ddmmmyy format e.g 28aug30, the year in the date defaults back to 1930 instead of 2030. Have any of you faced this problem and any remedy for the same ? |
| 5671 | From Help Note When you enter a date in Microsoft Excel 97 and you=20 enter only two digits for the year, Microsoft Excel enters=20 the year as follows: =B7 The years 2000 through 2029 if you type 00 through=20 29 for the year. For example, if you type 5/28/19,=20 Microsoft Excel assumes the date is May 28, 2019. =B7 The years 1930 through 1999 if you type 30 through=20 99 for the year. For example, if you type 5/28/91,=20 Microsoft Excel assumes the date is May 28, 1991. Until the defaults are changed type these dates in full or=20 add 36525 to each of your dates. Alan -----Original Message----- hi, In excel 97 and even in excel 2002 that we have in our=20 office, if you try and enter any date beyond 2029 in the=20 ddmmmyy format e.g 28aug30, the year in the date defaults=20 back to 1930 instead of 2030. Have any of you faced this problem and any remedy for the=20 same ? . |
| 5673 | On Thu, 22 Aug 2002 22:07:57 -0700, "gordon rodrigues" <gordonrodrigues@hsbc.com wrote: hi, In excel 97 and even in excel 2002 that we have in our office, if you try and enter any date beyond 2029 in the ddmmmyy format e.g 28aug30, the year in the date defaults back to 1930 instead of 2030. Have any of you faced this problem and any remedy for the same ? It's not really a problem, it's by design. See the on-line help topic "How Microsoft Excel performs date and time calculations" in 97, or "About dates and date systems" in 2002/XP. Short of building clairvoyance into the next release of Excel (and I shudder to think what that damn paper clip would do with THAT; probably try to stop me from changing to the dog for one thing), Excel can only apply an arbitrary rule to determine which century you're referring to. MS think it reasonable that if you enter the year (say) "12", you're more likely to be referring to 2012 than 1912. However most people probably work more with past data than future data for analysis purposes (except maybe for Enron, Arthur Andersen and HIH), so a year like "50" is more likely to be 1950 than 2050. (Let's face it, a forecast out to 2050 would be fairly meaningless.) Personally, I think MS has got it pretty much right. The cut-off date will change as we go forward, as indeed it has in the past. In Excel 95 and prior, it was 2020. (/default.aspx?scid=kb;en-us;Q164406). In the meantime the only solution is to enter 4 digit years for years beyond 2030. --------------------------------------------------------- Hank Scorpio apolloXVIII@ozemail.com.au Change XVIII to 18 for real address. * Please keep all replies in this Newsgroup. Thanks! * |
| 5674 | On Fri, 23 Aug 2002 00:34:25 -0600, "J.E. McGimpsey" <jemcgimpsey@mvps.org wrote: Don't recall if it was added in XL02, but in XL01 and XLv.X (Mac versions), there's a spinner control in Preferences/Options/Edit (Tools/Options/Edit for WinXL) labeled "Assume 21st century for two-digit years bfore:". The default is 30, but if you set it to, say, 60, then entering 28aug59 will result in the date having the year 2059, not 1959. That's not in Tools - Options - Edit for Excel 2002 (you're a Mac user? It doesn't show [grin]), but your post did trigger a vague memory at the back of my mind. As per my own post on this lower down, there isn't any way to change this in Excel itself. However in Windows (98 at least; can't say for other versions but it's PROBABLY in ME and XP) you can change your preference globally through the Start menu - Control Panel - Regional Settings - Date tab. You can set the end year for the "20" prefix there; so if you set it to 2050, a date entered as 1/1/48 will translate to 2048 rather than 1948. HOWEVER, that setting only seems to have an effect on Excel 2002. When I entered the date in Excel 97, it still applied the 2029 rule. The other thing is that it may (probably will) affect some other applications as well. It may be risky to use it given that (as Excel 97 demonstrates), it's not TRULY a universal setting. In article <657301c24a63$0b545890$37ef2ecf@TKMSFTNGXA13, gordon rodrigues <gordonrodrigues@hsbc.com wrote: hi, In excel 97 and even in excel 2002 that we have in our office, if you try and enter any date beyond 2029 in the ddmmmyy format e.g 28aug30, the year in the date defaults back to 1930 instead of 2030. Have any of you faced this problem and any remedy for the same ? --------------------------------------------------------- Hank Scorpio apolloXVIII@ozemail.com.au Change XVIII to 18 for real address. * Please keep all replies in this Newsgroup. Thanks! * |
| 5681 | Hi Lloyd My copy of Excel 2002 (XP) behaves the same as previous versions and opens files in the cell that was active at the time of the save, unless there is a macro instructing it to go to a specific location upon opening. Try checking to see if there are any macros being invoked when the file opens. Press Alt+F11 to invoke the VB Editor Ctrl+R to go to the Project Explorer, and double click on the This Workbook object and see if there are any macros there. If not, check in any other modules attached to the workbook. -- Regards, Roger Govier Technology 4 U "Lloyd H. London" <lhlondon@ix.netcom.com wrote in message news:3D65704E.AC7CD8D7@ix.netcom.com... In Excel 97, I am used to the last cell I was in when I saved a workbook, closed it and reopened it at a later time. In Excel XP, it always returns to the same cell on the same worksheet everytime I open a file, even if I had closed the file from a different sheet. Example: I close a file being in cell D456 two days ago, and from G552 yesterday , both on sheet 4. But when I opened it, it opened in cell B66 on sheet2, every time. I would like to open a file in the cell that it was closed, to continue entering data. Is there a setting some where, that I have missed. Thanks for any suggestions |
| 5688 | Dear All, In the instance that I have come across, I cannot turn off the autofilter feature becausedthe toggle feature does not work - this must be a bug. However, I have found a work around - if I delete the data and restate it (using "undo" feature in Excel 2002), then the autofilter is finally removed. Regards, Gavin. -----Original Message----- I have used a filter to sort a data list, but I cannot seem to get rid of the autofilter. How do I turn the autofilter feature off altogether? |
| 5702 | For reference to Excel 97 .. XL: How Microsoft Excel Works with Two-Digit Year Numbers /default.aspx?scid=kb;en-us;Q164406 -- Dana DeLouis Windows XP & Office XP = = = = = = = = = = = = = = = = = "Hank Scorpio" <ApolloXVIII@Hates.Spam wrote in message news:3d65d9bd.15158526@msnews.microsoft.com... On Thu, 22 Aug 2002 22:07:57 -0700, "gordon rodrigues" <gordonrodrigues@hsbc.com wrote: hi, In excel 97 and even in excel 2002 that we have in our office, if you try and enter any date beyond 2029 in the ddmmmyy format e.g 28aug30, the year in the date defaults back to 1930 instead of 2030. Have any of you faced this problem and any remedy for the same ? It's not really a problem, it's by design. See the on-line help topic "How Microsoft Excel performs date and time calculations" in 97, or "About dates and date systems" in 2002/XP. Short of building clairvoyance into the next release of Excel (and I shudder to think what that damn paper clip would do with THAT; probably try to stop me from changing to the dog for one thing), Excel can only apply an arbitrary rule to determine which century you're referring to. MS think it reasonable that if you enter the year (say) "12", you're more likely to be referring to 2012 than 1912. However most people probably work more with past data than future data for analysis purposes (except maybe for Enron, Arthur Andersen and HIH), so a year like "50" is more likely to be 1950 than 2050. (Let's face it, a forecast out to 2050 would be fairly meaningless.) Personally, I think MS has got it pretty much right. The cut-off date will change as we go forward, as indeed it has in the past. In Excel 95 and prior, it was 2020. (/default.aspx?scid=kb;en-us;Q164406). In the meantime the only solution is to enter 4 digit years for years beyond 2030. --------------------------------------------------------- Hank Scorpio apolloXVIII@ozemail.com.au Change XVIII to 18 for real address. * Please keep all replies in this Newsgroup. Thanks! * |
| 5706 | David didn't mention a macro so I assumed he was opening the file manually. RE Excel 2002 though there is a new argument ("Local") for the OpenText method that should fix your problem. For example: Workbooks.OpenText Filename:="c:\File.csv", Local:=True -- Jim Rech Excel MVP |
| 5710 | And if you don't want to array enter it =SUMPRODUCT(A1:A3+0) -- Regards, Peo Sjoblom Dana DeLouis wrote: In Excel XP, the following Array formula worked. Cells A1:A3 had text, which were numbers. =SUM(A1:A3+0) "Matt Dwyer" <mdwyer@dwyer.com wrote in message news:301177ec.0208211301.5849945b@posting.google.com... Ok, I have some 2000 stations and some 2002 stations. I have a spreadsheet that lists 3 numbers, each of which is pulled from another spreadsheet by reference (e.g., a1 might be =+[281sch.xls]Rack B'!$G$30) a1: 3 a2: 2 a3: 8 a5: 2 Cell A5 is =sum(a1:a3), which you probably already figured out is not 2, it's 13 (numbers simplified for this example). Now, it turns out that the referenced cells, if you look at them with Excel 2002 are flagged as being screwed up !! - Numbers formatted as Text. If you fix this problem with 2002, the formula correctly displays the right answer. But there is NO way to fix this with 2000. Is there? Changing the cell format has no affect. Anything I am missing? Just wondering... (and carefully not opining on how stupid this is...) |
| 5750 | Yes. I had a 6 Meg. upgrade also, lowered apparenently from previous updates. :) Found this Kb article by accident as it applies to Excel if anyone is interested... XL2002: Issues Fixed in Excel 2002 by Office XP Service Pack 2 /default.aspx?scid=kb;en-us;q325668 -- Dana DeLouis Windows XP & Office XP = = = = = = = = = = = = = = = = = "Jim Rech" <jarech@kpmg.com wrote in message news:#eWFe1pSCHA.2344@tkmsftngp13... can detect what version of the update your computer requires. Right. You have to have installed SP-1 before you can install SP-2. -- Jim Rech Excel MVP |
| 5810 | My Excel 2002 (part of Office XP) is extremely slow when i try to save files under Windows XP Professional ! I'm lost ! -- Carlos Vaz |
| 5812 | Do you have the Journalizing feature turned on in Outlook 2002 (Tools--Options--Journal Options--"Also record fiels from" section)? Make sure Excel is not checked. Also check your Virus software (if you have one) to see if it's getting in the way. ______________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Carlos Vaz" <carvaz@terra.com.br wrote in message news:OFDXsi6SCHA.2400@tkmsftngp13... My Excel 2002 (part of Office XP) is extremely slow when i try to save files under Windows XP Professional ! I'm lost ! -- Carlos Vaz |
| 5945 | TOOLS - Share Workbook .... allow it posted on a problem like you Try it Regards Ron "Rocky2889" <rocklam@yahoo.com schreef in bericht news:#IFpEneTCHA.3764@tkmsftngp08... I have just upgrade to Windows Xp and using Excel 2002. I save my files on a network drive. Even since I upgraded my to XP I have problem on exit the program. I have to wait forever to exit Exel when I save the file and exit. Can it be the XP, before I using Windowx 2000 pro. I have no problem, it happened to all the computers on the network. All the five computers on the network is fairly fast with CPU from 1 gig to 1.7 gighz. It happen only to the office programs included Excel and Word programs. Thanks for any help. Rocky |
| 5947 | Hi Rocky See if Journalling is turned on in Outlook (somewhere in it's Tools I believe). Journalling takes about forever. HTH. Best wishes Harald "Rocky2889" <rocklam@yahoo.com wrote in message news:#IFpEneTCHA.3764@tkmsftngp08... I have just upgrade to Windows Xp and using Excel 2002. I save my files on a network drive. Even since I upgraded my to XP I have problem on exit the program. I have to wait forever to exit Exel when I save the file and exit. Can it be the XP, before I using Windowx 2000 pro. I have no problem, it happened to all the computers on the network. All the five computers on the network is fairly fast with CPU from 1 gig to 1.7 gighz. It happen only to the office programs included Excel and Word programs. Thanks for any help. Rocky |
| 5949 | save it also Regards Ron "Ron de Bruin" <rondebruin@kabelfoon.nl schreef in bericht news:usBFOseTCHA.2336@tkmsftngp08... TOOLS - Share Workbook .... allow it posted on a problem like you Try it Regards Ron "Rocky2889" <rocklam@yahoo.com schreef in bericht news:#IFpEneTCHA.3764@tkmsftngp08... I have just upgrade to Windows Xp and using Excel 2002. I save my files on a network drive. Even since I upgraded my to XP I have problem on exit the program. I have to wait forever to exit Exel when I save the file and exit. Can it be the XP, before I using Windowx 2000 pro. I have no problem, it happened to all the computers on the network. All the five computers on the network is fairly fast with CPU from 1 gig to 1.7 gighz. It happen only to the office programs included Excel and Word programs. Thanks for any help. Rocky |
| 6010 | Excel 2002 introduced the GETPIVOTTABLE function, which addresses this problem. If you're using an earlier version, you might be able to use an array formula, like this: =INDIRECT(ADDRESS(MAX(ROW(D1:D200)*(D1:D200<"")),COLUMN(D1))) When you enter this formula, use Ctrl+Shift+Enter (not just Enter). This formula assumes that the cell of interestest is the last one in the column. This formula returns the contents of the last non-empty cell in the range D1:D200. Adjust as necessary. John Walkenbach For Excel tips, macros, & downloads... -walk.com/ss "Bill" <oberhelm@itronix.com wrote in message news:9a9801c24e14$d7dd1d20$9ee62ecf@tkmsftngxa05... I have a pivot table and need to run a formula off the pivot table's total. Problem is that when the data changes, the total of the pivot table moves to a different cell. How do I reference that "moving cell" so that I am always "on target?" I have tried absolute cell referencing and I have tried named cells. Thanks. |
| 6016 | Take a look at 's Slow response site. Journalling causes problems, Antivirus can cause problems. /dmcritchie/excel/slowresp.htm Another thing that is mentioned a lot is to delete the files in your windows temp folder. (Although, I'm not sure that it's mentioned when saving an excel file--but it can't hurt!) Justin Jackowski wrote: When I try to save an Excel document from Excel 2002, intermittently it will hang for about 30-45 seconds. I am running Windows XP Pro and Office XP Pro Sp2, on a Windows 2000 domain with Active Directory. Any ideas? Thank you, Justin -- Dave Peterson ec35720@msn.com |
| 6105 | Greetings all, I have a user running a new Dell gx260. Excel 2002 sp2 & he's having problems closing Excel, basically the app hangs for about 2 minutes before shutting down. Getting eroneous message in event viewer simply stating that it detected an application hang. All available service packs have been installed & he's running WinXP. Any ideas? Thanks, Marty |
| 6116 | I'm using Excel 2002 (XP), and I would like to lock down a worksheet in a way that it will always require a password to open it, even if someone forgets to "protect" the sheet after unprotecting it and closing the document. I started by trying Tools -- Protection -- Protect Sheet, but quickly realized that, if someone opens the document, unprotects a sheet, and then closes the document without protecting the sheet again, the sheet will be readable to anyone who opens the document next. I want the sheets to be password-protected by default, without relying on users to "protect" the sheets after viewing them. Is there a way to do this? TIA, David |
| 6122 | Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If ActiveSheet.ProtectContents = False Then MsgBox "you can't save this workbook the sheet is not protect" Cancel = True End If End Sub try this under thisworkbook Regards Ron "DT" <dt@sra.com schreef in bericht news:#t56QrsTCHA.1936@tkmsftngp10... I'm using Excel 2002 (XP), and I would like to lock down a worksheet in a way that it will always require a password to open it, even if someone forgets to "protect" the sheet after unprotecting it and closing the document. I started by trying Tools -- Protection -- Protect Sheet, but quickly realized that, if someone opens the document, unprotects a sheet, and then closes the document without protecting the sheet again, the sheet will be readable to anyone who opens the document next. I want the sheets to be password-protected by default, without relying on users to "protect" the sheets after viewing them. Is there a way to do this? TIA, David |
| 6129 | I have tried everythings as suggested from the newsgroup. The problem is still the same. Thanks William "Rocky2889" <rocklam@yahoo.com wrote in message news:#IFpEneTCHA.3764@tkmsftngp08... I have just upgrade to Windows Xp and using Excel 2002. I save my files on a network drive. Even since I upgraded my to XP I have problem on exit the program. I have to wait forever to exit Exel when I save the file and exit. Can it be the XP, before I using Windowx 2000 pro. I have no problem, it happened to all the computers on the network. All the five computers on the network is fairly fast with CPU from 1 gig to 1.7 gighz. It happen only to the office programs included Excel and Word programs. Thanks for any help. Rocky |
| 6192 | Annyoing, isn't it? Another example of Excel trying to be too helpful. This technique works with Excel 2002. I don't know about Excel 97. 1. Put your HTML code in a file and give it a *txt extension 2. Use File * Open, and locate that *.txt file 3. Excel will display the Text Import Wizard -- at least Excel 2002 does. 4. Specify delimted, and then dont' specify a delimiter character. John Walkenbach For Excel tips, macros, & downloads... -walk.com/ss "programmerX47" <wvrmfg@worldnet.att.net wrote in message news:_Srb9.41116$Ke2.2895811@bgtnsc04-news.ops.worldnet.att.net... Hello folks - I'd like to use the spreadsheet to alter some html coding, but excel automatically renders it as html like a browser - is there a way to disable or stop this formatting render rendering? ive tried paste special 'text' and it still does it. somehow i got some html into a spreadsheet but don't know how it happened. even leaving off <html and some big tags, if it finds a hyperlink in the code, it'l render it. Anyone, anyone? Thanks, Chris |
| 6195 | Yes, Thanks John. It is indeed annoying. Found ms site /default.aspx?scid=KB;EN-US;Q233073& article saying this. Unfortunately, even in ".txt" in excel 97, the file import wizard does not come up. Is there a way to get the file import wizard manually, and then select this text file? Thanks, Chris "John Walkenbach" <john@j-walk.com wrote in message news:#a3IF33TCHA.3556@tkmsftngp08... Annyoing, isn't it? Another example of Excel trying to be too helpful. This technique works with Excel 2002. I don't know about Excel 97. 1. Put your HTML code in a file and give it a *txt extension 2. Use File * Open, and locate that *.txt file 3. Excel will display the Text Import Wizard -- at least Excel 2002 does. 4. Specify delimted, and then dont' specify a delimiter character. John Walkenbach For Excel tips, macros, & downloads... -walk.com/ss "programmerX47" <wvrmfg@worldnet.att.net wrote in message news:_Srb9.41116$Ke2.2895811@bgtnsc04-news.ops.worldnet.att.net... Hello folks - I'd like to use the spreadsheet to alter some html coding, but excel automatically renders it as html like a browser - is there a way to disable or stop this formatting render rendering? ive tried paste special 'text' and it still does it. somehow i got some html into a spreadsheet but don't know how it happened. even leaving off <html and some big tags, if it finds a hyperlink in the code, it'l render it. Anyone, anyone? Thanks, Chris |
| 6198 | OK, one more idea. Use a text editor to replace all "<" with something else (e.g., "<<<"). Then, Excel won't recognize it as an HTML file (at least Excel 2002 doesn't). Then you can import it into Excel, and replace the "<<<" with "<". -John "programmerX47" <wvrmfg@worldnet.att.net wrote in message news:xysb9.41268$Ke2.2898923@bgtnsc04-news.ops.worldnet.att.net... Yes, Thanks John. It is indeed annoying. Found ms site /default.aspx?scid=KB;EN-US;Q233073& article saying this. Unfortunately, even in ".txt" in excel 97, the file import wizard does not come up. Is there a way to get the file import wizard manually, and then select this text file? Thanks, Chris "John Walkenbach" <john@j-walk.com wrote in message news:#a3IF33TCHA.3556@tkmsftngp08... Annyoing, isn't it? Another example of Excel trying to be too helpful. This technique works with Excel 2002. I don't know about Excel 97. 1. Put your HTML code in a file and give it a *txt extension 2. Use File * Open, and locate that *.txt file 3. Excel will display the Text Import Wizard -- at least Excel 2002 does. 4. Specify delimted, and then dont' specify a delimiter character. John Walkenbach For Excel tips, macros, & downloads... -walk.com/ss "programmerX47" <wvrmfg@worldnet.att.net wrote in message news:_Srb9.41116$Ke2.2895811@bgtnsc04-news.ops.worldnet.att.net... Hello folks - I'd like to use the spreadsheet to alter some html coding, but excel automatically renders it as html like a browser - is there a way to disable or stop this formatting render rendering? ive tried paste special 'text' and it still does it. somehow i got some html into a spreadsheet but don't know how it happened. even leaving off <html and some big tags, if it finds a hyperlink in the code, it'l render it. Anyone, anyone? Thanks, Chris |
| 6215 | But of course - the ol' text technique - i guess i've gotten lazy! Thanks so much. Chris "John Walkenbach" <john@j-walk.com wrote in message news:Oe6oaG4TCHA.3944@tkmsftngp11... OK, one more idea. Use a text editor to replace all "<" with something else (e.g., "<<<"). Then, Excel won't recognize it as an HTML file (at least Excel 2002 doesn't). Then you can import it into Excel, and replace the "<<<" with "<". -John "programmerX47" <wvrmfg@worldnet.att.net wrote in message news:xysb9.41268$Ke2.2898923@bgtnsc04-news.ops.worldnet.att.net... Yes, Thanks John. It is indeed annoying. Found ms site /default.aspx?scid=KB;EN-US;Q233073& article saying this. Unfortunately, even in ".txt" in excel 97, the file import wizard does not come up. Is there a way to get the file import wizard manually, and then select this text file? Thanks, Chris "John Walkenbach" <john@j-walk.com wrote in message news:#a3IF33TCHA.3556@tkmsftngp08... Annyoing, isn't it? Another example of Excel trying to be too helpful. This technique works with Excel 2002. I don't know about Excel 97. 1. Put your HTML code in a file and give it a *txt extension 2. Use File * Open, and locate that *.txt file 3. Excel will display the Text Import Wizard -- at least Excel 2002 does. 4. Specify delimted, and then dont' specify a delimiter character. John Walkenbach For Excel tips, macros, & downloads... -walk.com/ss "programmerX47" <wvrmfg@worldnet.att.net wrote in message news:_Srb9.41116$Ke2.2895811@bgtnsc04-news.ops.worldnet.att.net... Hello folks - I'd like to use the spreadsheet to alter some html coding, but excel automatically renders it as html like a browser - is there a way to disable or stop this formatting render rendering? ive tried paste special 'text' and it still does it. somehow i got some html into a spreadsheet but don't know how it happened. even leaving off <html and some big tags, if it finds a hyperlink in the code, it'l render it. Anyone, anyone? Thanks, Chris |
| 6340 | HAVe you tried creating that directory and trying to change the options again? "Dan Ellison" <danellison@bellsouth.net wrote in message news:a60c01c25039$a2338ac0$a5e62ecf@tkmsftngxa07... : When I try to change any options in Excel 2002, by : clicking on <TOOLS, <OPTIONS, <VIEW TAB, then : deselecting <GRIDLINES, when I click on <OK I get a : message the says 'Can not find directory C:\DOCUMENTS AND : SETTINGS\DAN ELLISON\MY DOCUMENTS\TEMPORARY FILES' : : Has anyone experienced this problem, and how did you fix : it? Does anyone have any suggestions? |
| 6370 | We've had this problem officewide since "upgrading" to Excel 2002. Running the spreadsheets locally haven't helped the slowdown when closing. Our network bandwidth, servers, and client machines are pretty fast, and so I'm wondering if this is an issue with the software. Our workstations are at least 1ghz/256mb RAM. -----Original Message----- I've seen this or closely related problems in this Newsgroup and others before, but I don't know if I've ever seen a solution. When running Windows XP Pro and Office XP Pro and saving to the network, Excel takes an extremely long time (60+ secs) to close. It's not that the worksheets are all that large either. The same file will save and close in seconds when the client is running Windows 2000 and Office XP. Any clues? Thanks, Wes . |
| 6422 | Just to throw this out if it's what you are thinking.... If you give your list the range name "database", and then add data to this list by selecting <Data<Form, then Excel will automatically adjust the range "database" as records are added and deleted. Don't quote me on this, but I do not think that Validation, and Data - Form worked together in the past. However, it appears that Validation works with a data entry form in Excel XP. Is this a "fix" to this feature? I don't remember. I don't know much about the following to know if it could offer any help or not. Excel 2002 Add-in: Template Wizard with Data Tracking The Microsoft Excel 2002 Template Wizard is an add-in program that sets up a database to store data entered from an Excel form /downloads/2002/tmplwiz.aspx -- Dana DeLouis Windows XP & Office XP = = = = = = = = = = = = = = = = = "Robert Shiffman" <tcebob@attbi.com wrote in message news:ei7pqyIUCHA.4156@tkmsftngp08... I've set up a data validation / list which helps enter project numbers / descriptions in a cell. There's a fair list of them which is added to and subtracted from frequently. It was my impression that named regions expanded automatically as new data are added. Doesn't seem to work that way. Any workarounds? RS |
| 6423 | Bryan, Get the Text Write Program (and Excel Workbook) at www.tushar-mehta.com. It will let you specify a tab character for the field delimiter. You'd specify Character - 09, which is the tab character, or whatever). It won't add quotes unless it sees that character in your data. You can specify any field and record delimiter you want, character or code. It's a workbook that you have open, and then you go to the sheet in your workbook you want written and press Crtl-Shift-W. Done. -- Regards from Virginia Beach, EarlK ------------------------------------------------------------- "Bryan" <webmail@lunchboxpad.com wrote in message news:aaf101c2509c$23d6b8b0$a5e62ecf@tkmsftngxa07... If anyone can help me with my problem, I would be really appreciative! I'm using Excel 2002. Now, I have a spreadsheet with movie posters, prices, etc. I want to save as a tab delimited txt file. It will do this with no problems. But when it saves the spreadsheet as a txt file, it adds quotes "at the front and back of any cell that has a comma in it. So instead of a field looking like Beatles, The - it looks like "Beatles, The". I know that MS Works spreadsheet used commas as new fields. Is there any way in Excel 2002 so that when you save as to a tab delimited txt file, you can do so without have fields with commas have quotes added to them? Any help will be appreciated! Bryan |
| 6441 | Hi Sorin! Try using Help! What you want is to create a Template that you store in the XLStart directory. The instructions are different for different versions of Excel but the following is a simple copy and paste job from Excel 2002 Help, which I located in about 30 seconds. Don't follow the (misinformed) view that Help is useless. Yes! there are problems and limitations but it should still be your first port of call. How I got there: Help Contents Tab Customizing Excel Controlling what happens when you start Excel Save workbook settings you want to use every time you start Excel with a workbook template book.xlt START OF COPY Decide which type of template you want: Workbook template Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting you want in new workbooks based on the template. Worksheet template Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type. To display a picture of the first page of a template in the Preview box of the Templates dialog box (General Templates..., New Workbook task pane), click Properties on the File menu, click the Summary tab, and then select the Save preview picture check box. On the File menu, click Save As. In the Save as type box, click Template. In the Save in box, select the folder where you want to store the template. To create the default workbook template or default worksheet template, select either the XLStart folder or the alternate startup folder. The XLStart folder is usually C:\Program Files\Microsoft Office\Office10\XLStart To create a custom workbook or worksheet template, select the Templates folder, which is usually C:\Documents and Settings\user_name\Application Data\Microsoft\Templates Enter the name of the template in the File name box. Do one of the following: Workbook template Type book to create the default workbook template. To create a custom workbook template, type any valid file name. Worksheet template Type sheet to create a template for default worksheets. To create a custom sheet template, type any valid file name. Click Save, and then click Close on the File menu. END OF COPY Now what could be easier? Sees Ya! Happy Labor Day to those in US -- Norman Harker Sydney, Australia Off-group contact welcomed as long as it's Excel related or sending money! "Hershcu Sorin" <sorin@zahav.net.il wrote in message news:#FcXdGdUCHA.3764@tkmsftngp08... Hello I want to change the default behavior of excel97 so that the default number format when open a new file will be text and not General. Can an how to do it? Sorin |
| 6595 | All numbers in a cell range are keyed in with only 2 decimal points(it's not just the format), but the total will have 9 or 10 decimal places(more or less) whether your adding or subtracting. It's not consistant on this either. Is there a ghost in the machine? I was using Excel 97 which did this, and now Excel 2002 still does. Any info is most appreciated. |
| 6644 | Brenda <bstullos@yahoo.com wrote... All numbers in a cell range are keyed in with only 2 decimal points(it's not just the format), but the total will have 9 or 10 decimal places(more or less) whether your adding or subtracting. It's not consistant on this either. Is there a ghost in the machine? I was using Excel 97 which did this, and now Excel 2002 still does. Any info is most appreciated. These are natural and unavoidable consequences of floating point math. Excel makes uses of base-2 (binary) floating point math operations. That means the fractional parts of numbers are stored as sums of reciprocals of powers of 2. 0.5 = 1/2, 0.75 = 1/2 + 1/4, but 0.40 = 1/4 + 1/8 + 1/64 + 1/128 + 1/1024 + 1/2048 . . . Using a 'decimal' point, 0.40 decimal is 0.01100110011001100... binary. This is similar to the way fractions that aren't sums reciprocals of powers of 2 and 5 are represented as decimal fractions: 1/6 = 0.166666... You could use Precision as Displayed to avoid this, but it has its own complications. Read about it in online help. |