Archivo XLA. no abre

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Data Validation in Excel 2007 I need to set up a data validation for a Social Security Number. The number must be 9 digits long, no dashes and no letters. I am using Excel 2007. -- Bruce Tag: Archivo XLA. no abre Tag: 119657
  - 2
    - Change cell values without creating a new column -- possible? Hello all, Often in excel I find myself changing data in a column (say add 10 to all items in column A). How I do this is to create a column to the right, put =A1+10 in the cell to the right and drag down. Then I select this column and Paste Special-->Values in the original column. After doing this again and again, I am sure there is a better way that some of you have figured out. Any thoughts? Tim Tag: Archivo XLA. no abre Tag: 119652
  - 3
    - Excel 2007 and XML with inline schema Hi. I have XML data that I want to be more user-friendly when its opened in excel. The user can create a web Query which will return the xml to them - ( pointing to the URL with the XML information)- and they can refresh the query each time they open the document in excel. Unfortunately- they have to format the data in excel manually. I wanted to associate an inline schema with the data to format the date cells, number cells etc. but the schema is not recognised in Excel. I have been just trying to get excel to recognise an inline schema- is this possible in the Excel? Any information regarding this would be very helpful as I'm trying to research which would be the best way to implement this - and an inline schema seems the most straightforward. Thanks Tag: Archivo XLA. no abre Tag: 119650
  - 4
    - Making a pup-up Hi Everyone, I was wondering if you can make an pop up, when a answer from a formule is "XXXXXX" My file contains multiple sheets - if sheet "Budget" cell D53 is XXXXXX then a pop up has to appear. The formule in cell D53 is linked to another sheet called "Jobspecs" Hope someone can help me with this! Thank you! Regards Berry Tag: Archivo XLA. no abre Tag: 119649
  - 5
    - refering a blank cell Does anyone knows how can I refer the first blank cell in a column? Tag: Archivo XLA. no abre Tag: 119644
  - 6
    - Spreadsheets not calculating new information At work, our company relies on excel spreadsheets to generate reports to track our daily progress. Under normal circumstances, they work well without incident. We currently use Microsoft Office 2000 in our office, which includes Excel 2000 and we are using Windows XP Professional as our operating systems, although I am not sure which version it is. Recently I experienced a period of about an entire week where the spreadsheets were not calculating any of the new information that was being manually entered. The previous calculations were in tact, but nothing would change with the addition of new figures, unless I would double click on each individual cell and hit enter after. This is a very tedious task and am not sure that all of the calculations are actually correct, since we have cells that generate a daily average once a number is placed in a certain cell. As mysteriously as the problems began, they also mysteriously stopped about a week later. Yesterday the problem returned, and it also seems to be affecting all of the spreadsheets that I have worked on and is also a problem for my boss, so I don't think its isolated to just my PC. We are networked, so apparently it is not just a problem for myself. Has anyone in the discussion group experienced anything like this before, and if so, how can we correct it? Thank you. I appreciate any help that we can get. Tag: Archivo XLA. no abre Tag: 119638
  - 7
    - Combining 2 columns to 1 Hi I have 2 columns A and B. In column A i have one word like "hello". In column B i have a time "19:00" even though the column is pure standard. What i would like to do is combine these two columns to one column, so that i have column C "hello 19:00". I try to do this using the formula =A1&" "&B1 in column C, but when i do that i get the result "hello 0,791666666666667" which is not what i want. How can i do this? Best regards Jimmy Tag: Archivo XLA. no abre Tag: 119637
  - 8
    - Minor loss of fidelity I'm currently evaluating Excel 2007 in our office to see what the issues are. I've got it configured for compatibility mode which I think we will be using as the standard across the company for the foreseeable future as all of our clients are on earlier versions. I've just made some changes to a small spreadsheet and Excel is warning me about minor loss of fidelity: ----cut here--- Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. ----cut here--- This is all well and good but I don't want to turn off the warning (as it's useful) but how do you find out which four cells are effected? I've not entered any formatting that is unusual for Excel 2003. Cheers, Rob. Tag: Archivo XLA. no abre Tag: 119633
  - 9
    - Formatting a date field Is it possible to format a date field in excel such that :- 1) it accepts day, month, year or month, year or just year or blank and 2) you are able to sort properly on the field Bob M Tag: Archivo XLA. no abre Tag: 119628
  - 10
    - Dana: A different bug in Solver? On May 7, 3:34 pm, "Dana DeLouis" <ddelo...@bellsouth.net> wrote: > "Paul Smith" <phh...@gmail.com> wrote in message > > In A1 put =(B3-B4)^2 and in B3 and B4 put 0. Afterwards, > > use Solver to maximize the formula in A1 by changing B3:B4 > > and with the following constraints: > > B3:B4<=1 > > B3:B4>=0 > > The maximum is 1 but Solver founds 0 as the maximum. > > Solver is just quiting early because it got confused when the > starting values in B3:B4 are equal. At least B3:B4 are within their constraints in this case. But consider this following situation, which I have distilled from a more complex formulation. In A1: =510-(IF(A2+510<123700,(A2+510-61300)*25%+8440,(A2+510-123700)*28% +24040) -IF(A2<123700,(A2-61300)*25%+8440,(A2-123700)*28%+24040)) In B1, put 371. Now use Solver to maximize $A$2, changing $A$2 with the constraint $A$1>=$B$1. When A2 is blank or less than 123700 (so far as I can tell), Solver finds the right answer: about 123573.33 in A2 and 371 in A1. All Options are the default. I am using Office Excel 2003. But when A2 is initially 123700, 123750 or 123900 (to name a few), Solver leaves those numbers in A2, with about 367.20 in A1 -- __less_than__ B1, which violates the constraint. In other words, it is not a correct solution. But if A2 is initially 123800, Solver works fine, even though A1 is still initially about 367.20. That is, it finds the correct solution: about 123573.33 in A2 and 371 in A1. Can this really be dismissed as simple "confusion"? How is this not a defect? Tag: Archivo XLA. no abre Tag: 119627
  - 11
    - test test post Tag: Archivo XLA. no abre Tag: 119622
  - 12
    - multiple critera formula In column A1-A20 I have days for a crew. In column B1-B20 I have names of the crew. In column C1-C20 there are hours for the crew. Each crew member has a timesheet made of rows in column E through J making up a week. MON Anderson, Josh 8 MON Bailey, John 8 MON Blakely, Brett 8 TUE Eddings, Cindy 8 TUE Floyd, Bill 8 TUE Anderson, Josh 8 WED Bailey, John 9 WED Blakely, Brett 9 WED Eddings, Cindy 9 THUR Anderson, Josh 10 THUR Bailey, John 10 FRI Anderson, Josh 10 SAT Anderson, Josh 9 SAT Bailey, John 9 SAT Blakely, Brett 9 SAT Eddings, Cindy 9 MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY If an employee works on Monday with those hours listed in column C, we want those hours automatically listed under Monday in that particular individuals timesheet cells. There is a possibility of 20 employees that are all listed in a column titled "Employees" in column K. Assuming that the week day example above is "Anderson, Josh" timesheet, how would we show automatically 8 hours in the Monday cell, 8 hours in the Tuesday cell, 0 hours in the Wednesday cell, 10 hours in the Thursday cell, 10 hours in the Friday cell and 9 hours in the Saturday cell? Thank you, Gary Tag: Archivo XLA. no abre Tag: 119620
  - 13
    - Excel 2007 HUGELY slow on Autosave, can anything be done about it? Excel 2007, when it does Autosave, is pushing CPU for my PC to 100%, and taking 60 seconds or more. Progress meter goes about half way, then stops for 30-45 seconds. However, the open files take about 5 seconds or less to save (they are not ultra-huge or anything). This behavior is extremely irritating. Really interrupts work flow if you're a heavy Excel user, as i have to totally stop using Excel. This was never an issue for me before i upgraded to Excel 2007. Have others seen this? Can anything be done about it? (aside from Autosave less frequently, which is not necessarily desirable, tho maybe i will do it, as this is so irritating). Thanks, tom Tag: Archivo XLA. no abre Tag: 119618
  - 14
    - Locked files My app uses DBF files. When another user on the network wants to open the same DBF in Excel, he gets a "ABC.dbf is locked for editing by 'another user'". Is there a way to open the DBF such that Excel can report the actual user name? BTW, where does Excel store this lock info? Thanks, Jim Tag: Archivo XLA. no abre Tag: 119612
  - 15
    - Bug of Solver? Dear All In A1 put =(B3-B4)^2 and in B3 and B4 put 0. Afterwards, use Solver to maximize the formula in A1 by changing B3:B4 and with the following constraints: B3:B4<=1 B3:B4>=0 The maximum is 1 but Solver founds 0 as the maximum. Is is a bug of Solver? Thanks in advance, Paul Tag: Archivo XLA. no abre Tag: 119611
  - 16
    - Conditional formatting question I have three cells A1,A2,A3 Together (they are not merge) they make up a descpition field. When A1 receives 'PROJECT NOT VALID' the shading turns yellow, text turns red bolded. I want to shade, color and bold on A2 and A3 when this condition occurs (so that the field is all yellow when it occurs) However conditional formatting doesn't allow to reference another cell (or I cannot find how to do it) So if I am on A2 and want to say when A1=PROJECT NOT VALID' this would accomplish what I need. Any help appreciated. Tag: Archivo XLA. no abre Tag: 119607
  - 17
    - ::: More than 8 seconds on space bar = Cursor blocked ! Please HELP ! Hello, I press more than 8 seconds on the space bar. Now my cursor is blocked. Like if I wanted to select many cells. How can I go back to a normal situation ? And free my cursor! Many thanks in advance for your help. Jacques Tag: Archivo XLA. no abre Tag: 119600
  - 18
    - Field required Is there a way to require something in a blank field on a protected document? I have a protected excell doc. and I want some way to require some type on entrey into each unlocked field. Some fields on the form are being left blank and I want some type on reminder to prompt users that there are still blank fields on the form Thanks tboyle Tag: Archivo XLA. no abre Tag: 119596
  - 19
    - Macro to select files with specific dates from a folder I would appreciate your help to create a macro. I have a folder with a particular date say Aug 2006 and it contains various files with specific dates say 1st August, 2nd August etc and some with different date format. The macro should pick up only those files with dates 1st August, 2nd August and NOT select the files with the different date format and deposit these selected files into a new folder named Aug 2007. I want to make the macro code as generic as possible. Thanks, Amit Tag: Archivo XLA. no abre Tag: 119595
  - 20
    - Simple formula not working =IF(F4=1,H4,-1) Nearly all cells have numeric values, and for those with a value of 1 it works correctly, where the values are numeric it also works correctly. BUT - a few cells have 1 or 2 alphabetic characters, which means they are not equal to 1, so should yield a value of -1. For example I want XY, as it is clearly not 1, so condition F4=1 fails, to evaluate to -1 The referenced cells are formatted number. Is Excel flawed or am I missing something? Excel 2002 SP3 Tag: Archivo XLA. no abre Tag: 119589
  - 21
    - Help with counting based on two conditions Using Excel 2000, I want to count how many customers are actively enrolled in a program at a given date. Column A contains the Customer Name Column B contains Program Start Date Column C contains Program End Date If I want to count how many people were on the program from April 1, 1999 to May 31, 2000 which would include those with a start date before April 1, 1999 but who do not have an end date. I tried Column D with my begin date criteria (August 1, 1996) Column E with my end date criteria (March 31, 2001) Column F to hold my counted start dates with the formula =COUNTIF(B11:B19, ">="&D11) - COUNTIF(B11:B19, ">"&E11) Column G to hold my counted end dates with the formula =COUNTIF(C11:C19, ">="&D11) + COUNTIF(C11:C19, "<"&E11) Column H to subtract F from G with the formula simple formula of =F11- G11 I've got something wrong with my formula in Column G as it is resulting of a count of two discharges yet I only have one discharge date in my sample data. It should tell me I have five active on program during my timeframe of 1-Aug-96 and 31-May-00 minus the one person who was discharged on 31-Mar-99. My sample data for six customers is as follows: B11 through B16 start dates 1-Apr-99 1-Apr-99 1-Dec-99 2-Dec-99 2-Jan-00 1-Apr-00 C12 end date of 31-Mar-99, rest are blank Can anyone suggest an easier/better/correct way to arrive at my desired results? Thanks! Les Tag: Archivo XLA. no abre Tag: 119582
  - 22
    - Counting Sales I want to summarise number of sales by salesperson. The raw data is in two columns eg Pat 12 Sarah 4 John 2 Sarah 6 Pat 1 John 5 The answer table I'd be looking for is Pat 13 Sarah 10 John 7 ....if my maths is right <G> Can SKS help Tx Rob Tag: Archivo XLA. no abre Tag: 119580
  - 23
    - Unique Values in a List I've got a 2000 row worksheet (salaries) and I want to count the number of occurences of each salary. eg 15250 25 15855 1 16101 12 Can SKS help Tx Rob Tag: Archivo XLA. no abre Tag: 119579
  - 24
    - How to copy "Ignore Error" all through? Hello I have a formula wherein the result is ok, but gets flagged "missing adjacent cells". I select the "Ignore this error" but how to copy this across all cells? Or do I have to do it on every cell? Thanks Tag: Archivo XLA. no abre Tag: 119567
  - 25
    - Day & Month In B4 & B5 I have the formula - =TODAY() which, correctly, returns 07/05/2007 In C4 I have the formula - =DAY(B4) which, incorrectly, returns Saturday (it is Monday) What have I done wrong here please? Thanks. Bill Ridgeway Tag: Archivo XLA. no abre Tag: 119565
- Next
  - 1
    - Password locking one row and colum containing formula To stop "nuisence experts" changing my spreadsheet formula (haven't we all met these people!!) I want to secure one row of cells and one column of cells whilst leaving the remaining worksheet accessable for data entry. I can lock the whole worksheet but have got bogged down trying to just secure (with Password) the cell and column containing the worksheet formula. Tag: Archivo XLA. no abre Tag: 119561
  - 2
    - SUM HELP PLZ I have a row of numbers where I need to total those with header A only if some number is in B. example A B A B A B A B 7 3 2 4 1 5 i..e. a1="A",b1="B",c1="A",d1="B",e1="A",f1="B",g1="A",h1="B" a2=7, b2=3, c2=2, d2="",e2=4, f2=1, g2=5, h2="" The total should be 7 + 4 = 11 (because there's a 3 for the 7 and 1 for the 4) I can do this with something like =IF(LEN(B2)>0,A2)+IF(LEN(D2)>0,C2)+IF(LEN(F2)>0,E2)+IF(LEN(H2)>0,G2) But I have 50 columns and sense there is a more elegant solution. I tried some SUMPRODUCT variations but can't seem to get the exclusion. Any help would be appreciated. Tag: Archivo XLA. no abre Tag: 119559
  - 3
    - Changing colour of cell on a certain date hi guys is it possible to change the colour a cell when the date in the box is reached. I have a spread sheet at work and have to do certain action on the 10th 14th & 28th day i.e if the 10th day is 07/05/07 (today) can i get it to change colour thanks Tag: Archivo XLA. no abre Tag: 119558
  - 4
    - Column of names I have a bunch of names (shown as Doe, John) in column A. How can I show the first names in B column and last in C? I understand how to copy formulas in B and C and paste values. Tag: Archivo XLA. no abre Tag: 119548
  - 5
    - Excel 2000 crashes during cut and paste Running Office 2K Professional under XP. Service pack 3 for Office. Cut and paste operations frequently cause Excel to crash. Debug reporting option appears, but nothing that explains the problem. The problem seems worse if the clipboard has more than one entry. Any ideas? Tag: Archivo XLA. no abre Tag: 119541
  - 6
    - Clicking on file icon in Excel does not work Hello, I have a recent problem with the excel program in XP. Whenever I click on the file icon nothing happens on the screen except that a gray space shows up where the spreadsheet should appear. The word "ready" appears where normally the words "running virus scan" occurs. The only way now I can open excel files is to go to "open" in the top menu of the excel program . Its a hassle then going to search for the file in the directories to open it that way rather than just clicking on the file icon. What could be the problem? Have I accidentally changed the settings and preferences for Exel? Thanks Tag: Archivo XLA. no abre Tag: 119537
  - 7
    - referances in difernt sheets same work book hiw do i use refferance a cell in a differnt shet for formular i rember my teachure teling me in collage but cant find it any book i know it has some thing to do with absolute cell reffeerances and the $ key Tag: Archivo XLA. no abre Tag: 119522
  - 8
    - Help me!! Excel API Viewer I need such a Viewer just like Microsoft provided in VB6 and VB7. In these products, we can look up some API fuctions and find out his parameters and value returned and the data type. VBA is available in using API but they didn't provide any helper of this, it is always very hard for me who don't have much experience in VB or Delphi. Tag: Archivo XLA. no abre Tag: 119520
  - 9
    - Importing Text (Word) in to Excel I am trying to, without much luck, to import text from Word in to Excel. I have a list of addresses, names, phone numbers, etc. that I need to import in to single cells in Excel to use in creating mailing labels. When I try to import the text it places all the data in to one cell. Is what I am attemting to due possible? If so, how can I successfully complete this. Thank you for your time, Tom t.parrish@bresnan.net Tag: Archivo XLA. no abre Tag: 119519
  - 10
    - Excel API Viewer I need such a Viewer just like Microsoft provided in VB6 and VB7. In these products, we can look up some API fuctions and find out his parameters and value returned and the data type. VBA is available in using API but they didn't provide any helper of this, it is always very hard for me who don't have much experience in VB or Delphi. Tag: Archivo XLA. no abre Tag: 119518
  - 11
    - if function not working Suppose that a3 is a date that has format dd/mm/yy, b3 format (dddd) cell of B3 =A3 (B3 value = sunday) cell of F3 =if(B3 = "sunday", "Void"), iget a 0 instead of value Sunday. Anyting wrong>? Tag: Archivo XLA. no abre Tag: 119505
  - 12
    - I want to remove numbers but leave text in cells. Hi, using Excel 2003,I'm pasting information into numerous cells of a worksheet. Each cell is a mixture of text and numbers eg. (123 test example 3210 ), can I remove the numbers and just leave text. regards, Tag: Archivo XLA. no abre Tag: 119504
  - 13
    - Looking for help with database functions I am working with a non-profit rural community development group. We are trying to put together a "database" to put people looking for work together with people needing services. A sample would might be: Joe Blow; [carpenter, woodworker]; free on tues & thur; willing to trade (equal to $10.00 hr); References: Heidi Hoe, 555-5555, John Doh, 555-5555 ext 100 Jane Doe, needing porch repaired and general yardwork, work on your own schedule, open to Barter; References: Seymour Johnson, 555-5555, Ivan Tootall, 555-5555 Winnie Pooh, looking for someone to read news, books, and visit a couple of times a month or more, You can use my dock and camp area on the lake in trade. Orville Wrightenbacker, Have some time on thurs to volunteer, have CNA license, can do housecleaning for disabled or elderly. Willing to pet or house sit in your home for extended periods. References: W. Oman 555-5555, Simon Saez, 555- 5555 We are looking to put seekers and providers togehter on a community website, but we would also like to set up a database to track these types of sevices and connect seekers to providers. Does anyone have any clue about how we could do this or templates that would work with excel or openoffice? Thanks, Bob Tag: Archivo XLA. no abre Tag: 119503
  - 14
    - F9 vs. Calculate Sheet Folks: I know that I can configure my spreadsheet to manually "re-calculate" by doing: TOOLS >> Options >> Calculation Tab >>. * What is the difference between "Calculate Now(F9) " and "Calculate Sheet" ? Thanks, John. Tag: Archivo XLA. no abre Tag: 119500
  - 15
    - Cut characters from one cell to form a newcell Hello, I have a cell that contains an address line, plus a postal code (zip code). The postal code is 7 characters long and is always at the end of the address line. I need to place the postal code in another new cell .. would like to create a macro to do this and would appreciate any help on this. Abay Tag: Archivo XLA. no abre Tag: 119495
  - 16
    - Referencing cells Is ther a way in Excel 2003 to use labels or words to refernce cells. For example instead of a formula being A1+C1, is there a way to call column A something like Jan_Sales and column B something like Feb_Sales and then the formula would be Jan_Sales1 + Feb_Sales1? Thanks for your help JF http:\\www.discountdrivingschool.com Best regards, JAF http://www.discountdrivingschool.com Tag: Archivo XLA. no abre Tag: 119485
  - 17
    - automate dates Dear Excel Expert, I have a workbook with 27 tabs titled "Timesheet". The first tab is a title page that remains the same over the years with the exception of the "Year" being changed each January. The remaining 26 tabs contain names of employees with the number of hours for a day's work. In each tab there are 3 governing dates in 3 different cells including (1) end of 1st week date (2) end of 2nd week date (3) pay date. These 3 dates represent a work period that consist of two weeks with each week beginning on a Monday and finishing on the following Sunday, and a pay date that is always on a Monday that is 8 days from the end Sunday of the second week. An example would be: For year 2007 a tab is labeled "Week 1-2" that has a (1) end of 1st week date = 1/07/2007 (2) end of 2nd week date = 1/14/2007 (3) pay date = 1/22/2007. The next tab is labeled "Week 3-4" that has a (1) end of 1st week date = 1/21/2007 (2) end of 2nd week date = 1/28/2007 (3) pay date = 2/05/2007. This continues through tab "Week 51-52". Year 2008 and beyond is identical with the exception of the dates being different. I there a way to automate the cells (1) end of 1st week date (2) end of 2nd week date (3) pay date, on each tab of each year by simply changing the year on the title page? Regards, Gary Tag: Archivo XLA. no abre Tag: 119484
  - 18
    - last three of four Hi, A cell in sheet1 (say B14) has either four words or five words. I want to copy the value to anothe cell in sheet2 (say to G15) in a way that: If B14 has 4 words I should have the last three word. (delete first word only). If B14 has five words I should take the last three word. (delete first 2 words). Note: all words are seperated by spaces. Is there more than one way to do it? Tag: Archivo XLA. no abre Tag: 119479
  - 19
    - Determine if data is trending UP or DOWN All I posted this question in another area with little activity. Please review my question and reply with any suggestions http://groups.google.com/group/microsoft.public.excel.worksheetfunctinos/browse_thread/thread/51433fe1f0242504/f908dfbcb5ae9487?hl=en#f908dfbcb5ae9487 Tag: Archivo XLA. no abre Tag: 119475
  - 20
    - inventory monte carlo simulating model I am buiding a model using ramdom numbers . whenever I hit the enter key the program generat new numbers. How can I avoid it. it take time when I just writting text on the model to explain the procedures Thanks Tag: Archivo XLA. no abre Tag: 119469
  - 21
    - If Function help I have what should be a simple IF then formula, which is copied below, where both criteria must be met: Z9 must be true and S9 must = COS. Any assistance why this isn't working would be greatly appreciated. =IF(AND(Z9=TRUE,S9="COS"),B9,"N/A") Thanks! Tag: Archivo XLA. no abre Tag: 119459
  - 22
    - Problem using Find and Replace ,B with ,C within an Excel Formula Hi, I am trying to replace ,B with ,C in the following formula and get an incorrect result. =SUMPRODUCT(BB$2:BB$377,BL$2:BL$377)/(SUMPRODUCT(BB$2:BB$377,BO$2:BO$377)+SUMPRODUCT(BB$2:BB$377,BG$2:BG$377)+SUMPRODUCT(BB$2:BB$377,BH$2:BH$377)+SUMPRODUCT(BB$2:BB$377,BI$2:BI$377)+SUMPRODUCT(BB$2:BB$377,BJ$2:BJ$377)+SUMPRODUCT(BB$2:BB$377,BK$2:BK$377)+SUMPRODUCT(BB$2:BB$377,BL$2:BL$377)+SUMPRODUCT(BB$2:BB$377,BM$2:BM$377)+SUMPRODUCT(BB$2:BB$377,BN$2:BN$377)) When I do a find and replace of ,B with ,C Excel replaces the :B with :C instead of replacing ,B with ,C . See the result below after the find and replace: =SUMPRODUCT(BB$2:BB$377,BL$2:CL$377)/(SUMPRODUCT(BB$2:BB$377,BO$2:CO$377)+SUMPRODUCT(BB$2:BB$377,BG$2:CG$377)+SUMPRODUCT(BB$2:BB$377,BH$2:CH$377)+SUMPRODUCT(BB$2:BB$377,BI$2:CI$377)+SUMPRODUCT(BB$2:BB$377,BJ$2:CJ$377)+SUMPRODUCT(BB$2:BB$377,BK$2:CK$377)+SUMPRODUCT(BB$2:BB$377,BL$2:CL$377)+SUMPRODUCT(BB$2:BB$377,BM$2:CM$377)+SUMPRODUCT(BB$2:BB$377,BN$2:CN$377)) Please advise. Thanks. Darrell Tag: Archivo XLA. no abre Tag: 119455
  - 23
    - Equation Editor I have recently lost the Equation Editor from my "Insert | Objects" list. Can anyone tell me how I lost it and how can I get it back? Thanks, Mike Tag: Archivo XLA. no abre Tag: 119453
  - 24
    - Count Folks: I have a single column of information. Only SOME of the cells within this column contain a string of alphabetic characters. Some cells are empty. For example: Column A ABC ZEP POW ZAP * What Excel command would allow me to count the # of cells that actually contain alphabetic information within a certain range like A2:A100 Thanks, John. Tag: Archivo XLA. no abre Tag: 119447
  - 25
    - More than one column in a PivotTable Hi, I have a set of time-series waterlevel data, from which I wish to extract the daily maxima and minima. I've had no problem doing this using a PivotTable for each query (using two helper columns that extract the months and day from the date column). However I would like to do this using just one table, and to display the results in two adjacent columns (headed Maxima and Minima). I've tried adding the two fields to the DATA section of the diagram, but this just produces the PivotTable to take up two rows per day rather than to display the values adjacently! Hope someone can help - cheers in advance. Mark. Tag: Archivo XLA. no abre Tag: 119441

Tengo un complemento de Excel, el cual no lo puedo abrir, al parecer,
al actualizar el archivo hice dos macros con el mismo nombre no me
entere de esto y lo grabe asi, mi problema es que no puedo abrirlo
para corregir este problema.

Si alguien tiene alguna sugerencia, se los agradecece bastante

Re: Archivo XLA. no abre by H�ctor

Héctor
Tue May 08 19:26:51 CDT 2007

hola, jose !

> Tengo un complemento de Excel, el cual no lo puedo abrir
> al parecer, al actualizar el archivo hice dos macros con el mismo nombre
> no me entere de esto y lo grabe asi
> mi problema es que no puedo abrirlo para corregir este problema.
> Si alguien tiene alguna sugerencia, se los agradecece bastante

suponiendo que conservaste el archivo 'original' [el .XLS como fuente del .XLA]...
prueba abriendo este documento fuente sin habilitar las macros y haces las correcciones

si eliminaste el archivo .XLS ??? [supongo que tendras que empezar de nuevo] :-(

saludos,
hector.

Re: Archivo XLA. no abre by Pepito

Pepito
Wed May 09 08:51:13 CDT 2007

On 8 mayo, 19:26, "H=E9ctor Miguel" <NOhemiordiS...@PLShotmail.com>
wrote:
> hola, jose !
>
> > Tengo un complemento de Excel, el cual no lo puedo abrir
> > al parecer, al actualizar el archivo hice dos macros con el mismo nombre
> > no me entere de esto y lo grabe asi
> > mi problema es que no puedo abrirlo para corregir este problema.
> > Si alguien tiene alguna sugerencia, se los agradecece bastante
>
> suponiendo que conservaste el archivo 'original' [el .XLS como fuente del=
=2EXLA]...
> prueba abriendo este documento fuente sin habilitar las macros y haces la=
s correcciones
>
> si eliminaste el archivo .XLS ??? [supongo que tendras que empezar de =
nuevo] :-(
>
> saludos,
> hector.

Hola Hector :

Desafortunadamente el archivo original XLS, se extravio, ni modo
tendre que empezar de cero.

Saludos,
Jose