help excel freezing up

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
    - treat as text hi, i have two questions. 1) there is something you can select in excel so that when you writ really long numbers it treats it as text and doesn't truncate it or pu it scientific notation. I was wondering what exactly the menu was an what needed to be selected. I'm using office 97 2) i have a text file that when i convert to csv and open it up, som of the information is missing. Espeacially if it seems to begin with 1 or a 0. I'm just wondering how this can be avoided since excel i what is reading the csv file. Thank you very much. this problem is really frustrasting me -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34986
  - 2
    - file and folder help. Please :) Hi I have a list of files in an excel sheet in the first column I would like to know is there a way I can get excel to search for these files by giving it a dirctory and then it would copy the files to a directory I set, so say I have the following in an excel document 15632.dxf 55555.dxf 95854.dxf now they are under directory X and the directory I want them to be copier to is XX is there a way to do this, I would appreciate any help Thanks. Ali Tag: help excel freezing up Tag: 34971
  - 3
    - Opening Workbooks When I open up many separate excel files, the files all open up in th same excel workbook. How can I have the files open up in separate workbooks on my toolbar a the bottom instead of always having to go to window and choosing th next file I want to view? I would rather click on the windows tool bar at the bottom. Thanks for your help -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34968
  - 4
    - Word Mail Merge with Excel Data--Missing Data I have created a mail merge document in Word2002, using Excel2002 for m data source. When I merge the document, some of my fields hav incomplete data. The only records affected are those where the dat from the Excel fields is fairly long. Only about 200 characters wil show up on the Word doc. I am not exceeding any limits in my Exce fields. I've tried everything I know to do, but can't get this one t budge. Any suggestions are welcome -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34965
  - 5
    - Drop down box values I've been given this task to do in Excel and I need help. I have a column/list in worksheet2. The list is indexed and must stay intact as many cells in the workbook use this list. Lets say in this column I have the following information: Absorp ABSC0112 ABSC0129 ABSC0148 Cen CVAE 18 CVAE 19 CVAE 21 Wate GEVA 1/2 - 2 1/2 GEVA 3 -5 GEHA 1/2 - 2 1/2 GEHA 3 -5 Now I want to add two drop down boxes on another worksheet. Drop down box 1 would have the values: Absorp Cen Wate The list in Drop down box 2 would be dependent on what value is selected in drop down box 1 so if Absorp is selected in drop down box1 then ABSC0112, ABSC0129 and ABSC0148 would display in drop down box 2. Any ideas on how to do this? Thanks in advance. Tag: help excel freezing up Tag: 34964
  - 6
    - Numeric Overflow Error I have an Access Database linked to an Excel Worksheet. In my attempt to massage the data, I changed their refernces from Right 2 character to DatePart. Now I consistently am getting a Numeric Overflow error? Can someone explain this -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34955
  - 7
    - Global Variables losing scope in Excel when developing This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C42C80.D0AD9790 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a vba module inside an Excel add-in with a global variable = pointing to a class in an external dll, in the form Public MyVar as new MyLibrary.MyClass The problem is that when I am developing and testing the add-in, the = variable loses scope (not initialize). I have to close everything and = restart Excel. Then all is OK. Any suggestion? PD. If a declare the variable without "new", where is the best place to = initialize it? Thanks in advance ------=_NextPart_000_000C_01C42C80.D0AD9790 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have a vba module inside an Excel = add-in with a=20 global variable pointing to a class in an external dll, in the = form</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Public MyVar as new = MyLibrary.MyClass</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The problem is that when I am = developing and=20 testing the add-in, the variable loses scope (not initialize). I have to = close=20 everything and restart Excel. Then all is OK.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any suggestion?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>PD. If a declare the variable without = "new", where=20 is the best place to initialize it?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks in = advance</FONT></DIV></BODY></HTML> ------=_NextPart_000_000C_01C42C80.D0AD9790-- Tag: help excel freezing up Tag: 34951
  - 8
    - match record field I have a simple excel table where 5 users enter records on the same spreadsheet throughout the week. In one of the fields (columns) the user will enter his name to identify who the record belongs to, and in another field is the date that record was entered. I end up with a table like the following: name entry_date Joe 04/16/04 Bill 04/17/04 Joe 04/18/04 Bill 04/19/04 Joe 04/20/04 Ed 04/21/04 My problem: In another cell on another worksheet I would like to return the latest entry date for a particular user as such: Joe 04/20/04 I can't seem to use index(), match(), or max() functions to do the job. I have used the formula array {=MAX((E2:E19=A4)*(F2:F19))} but I can't get that to work for an entire column - only for a defined array. Any suggestions? Thanks, Gary Tag: help excel freezing up Tag: 34950
  - 9
    - Text formatting Hi gurus... I would like to run it by you, experts... Here is the problem: I woul like to build a macro that format the text so that the first letter of each word is a capital... For Instance a1= "perform backup" I would like the macro to transform the entry in a1= "Perform Backup"... Can someone provide guidance as to what the macro should look like or what function to use? Many thanks from Brew City Michel Tag: help excel freezing up Tag: 34947
  - 10
    - Format Painter keyboard shortcut? Hello, Does anybody know the keyboard shortcut for Format Painter? Thanks, Dave Tag: help excel freezing up Tag: 34946
  - 11
    - Can a workbook be used as a function Hi, I have an excel workbook (A) that givern three parameters, temp1, temp and flow calculates the energy transfer for a process we conduct, have another workbook (B) which contains the hourly logged data for th process from which we generate monthly reports. Is it possible to use workbook (A) like a function and pass to it th three parameters from workbook (B) and return to workbook (B) th answer ie. energy transfered. Workbook (B) contain approx 750 logs so i need to repeat th calculation 750 times I could link the two which works for the first piece of logged data bu how to automatically change the links for the next 749 ?? alternatively make workbook (A) a function and call it 750 time - ho ?? Any suggestions !! D -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34945
  - 12
    - Detecting Screen res Is there a way Excel can auto detect the screen res of a VDU an automatically resize thing like msg boxes so that text is centred o both big and small screen resolutions rather than ending with the tex all over the place ? Cheeeeeeeeeeers -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34941
  - 13
    - Kiviat Graph People, I am working with Excel 97 and I need to do a Graph named 'Kiviat'. Does anybody know how to do it? Thanks, Andres Tag: help excel freezing up Tag: 34937
  - 14
    - Unable to open excel file Hi. I have problem openning an excel file from windows explorer or from my desktop. However, when I open the excel program and open a file manually(File-Open----) everything works fine. I get an error message that the file could not be located. I noticed that it adds .xls to every word separated by space. For example: My file is in C:/Shared/Folder/test.xls, it tries to open: C:/Shared.xls then Folder.xls then test.xls Please help. Thanks. --- Message posted from http://www.ExcelForum.com/ Tag: help excel freezing up Tag: 34931
  - 15
    - Locking a Cell after It's Value is Calculated. I have One Cell whose value is constantly changing once a week. The results of that cell, I would like to have placed in differents cells, once a week. EX: In worksheet1 Input in cell WK3, resulting calculation ends in cell M3, then cell M3 is copied to worksheet2, A1 (=worksheet1M3) I got this! Input in cell WL3, resulting calculation ends in cell M3, then M3 is copied to worksheet2, A2: The problem is that cell A1 changes to the new number HELP! Can I lock cell A1 after the value is copied to it? Can I set conditions (time / date) on the cell after the value i copied to it so it won't change? I use the results of worksheet2, A1, A2, etc. for seperat calculations. If more clarification is needed I can email a copy of the sheet. Tom picktr@wowway.co -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34930
  - 16
    - Copying toolbars from one PC to another Is there a way to copy a customized Excel toolbar from one PC to another? tia, sh Tag: help excel freezing up Tag: 34925
  - 17
    - Unable to lock scroll area or Cell selection Hi, I'm trying to lock the scroll area on my worksheet. In VB I've got: Private Sub Workbook_Open() Worksheets("Board").EnableSelection = xlUnlockedCells Worksheets("Board").ScrollArea = "$A$1:$u$21" End Sub In the sheet Properties I input: EnableSelection 1-xlUnlockedCells ScrollArea $A$1:$u$21 I save. I protect the sheet. I save again. This works when I go into the sheet, the necessary cells cannot be selected and the scroll area is locked the way I want. I save and close, but upon opening the VB code is still there but EnableSelection and ScrollArea within properties are blank, and I am once again able to select any cell and scroll wherever I want. Any ideas? Thanks Paul Tag: help excel freezing up Tag: 34924
  - 18
    - Formatting issue with numbers when saving as csv Hi - I am using excel 2000. I have a spreadsheet that is an export from ms access which contains prices of products in one column. The number format of these cells is general. When I save this spreadsheet as a .csv file, the prices that showed as 95.00 now show as 95 and prices that showed as 95.99 still show as 95.99 which is exactly as I want - if there are no pennies then drop the decimal places. I have a problem that when this .csv file is imported into a thrid party application it is rejected. The 3rd party application developers have taken this spreadsheet, saved it as a .csv file and loaded it without any problems. I have compared my .csv file against their .csv file in notepad and found that mine displays 95.00 in the price column and theirs displays 95. I have llooked hard and cannot see why there should be a difference. What do I need to change to achieve the same as the 3rd party developers? Tag: help excel freezing up Tag: 34922
  - 19
    - Control Panel. Hello again :), I need after opennig Workbook disable all control panel a set fullscren: Application.DisplayFullScreen = True Is it possible? Thanks Tom Tag: help excel freezing up Tag: 34918
  - 20
    - Is open. Hello, how is most easy way for finding workbook (for example data.xls) is open? Thanks Tom Tag: help excel freezing up Tag: 34917
  - 21
    - Last protect proble. Hello, now how can I lock all macros and forms againts editing? Its possible do that in Workbook_open(), or I have to do it in VisualBasic Editor? Thanks Tom Tag: help excel freezing up Tag: 34909
  - 22
    - Another protect proble. Hello, now I need protect macro (againts using Ctrl-Break) in Sub Auto_open(), but this dosnt work: With Application .EnableCancelKey = xlDisabled End With Can you help me. I'd like to protect all macros at once, is it possible? Thanks Tom Tag: help excel freezing up Tag: 34906
  - 23
    - Re - GGVT Excel To Return an Array of Values following Modification Re - GGVT Excel To Return an Array of Values following Modification In the beginning, 1. Look at a range of values entered into the worksheet cells A1:A10. 2. A10 contains "ZZ" (which is essentially unique within the scope of the given range). 3. The following formula returns the given range of values following modification :- 4. =IF(A1:A10=A10,"@",A1:A10) ; meaning to have replaced "ZZ" with "@" and that the other values remain unchanged. 5. Note that it's the returning array being modified after the given range ; otherwise, the physical contents of the range of cells (located on the worksheet) remain intact. And now, 1. Look at the given range A1:A10 again. 2. A10 has become an empty cell ; in addition, other cells within the given range may or may not be empty. 3. The question is, how is it possible to modify and return the array just like {A1,A2,A3,A4,A5,A6,A7,A8,A9,"@"} ? Meaning that a means is to be devised in order to target A10 specifically for modification. 4. Note that the above expression of an array is given for the sake of clarification. Pedantically speaking, Excel would not accept an array containing variables expressed such as A1, A2 and etcetera. 5. Again, note that it's the returning array being modified after the given range ; otherwise, the physical contents of the range of cells (located on the worksheet) remain intact. Regards. Tag: help excel freezing up Tag: 34904
  - 24
    - search of a string in a cell and counting occurences using COUNTIF i need to separate out items which are in a column with cells containing 1 or more of these items delimited by commas. i need to export them to another worksheet within the spreadsheet which lists down the items individually per cell and then, i need to count the occurences. i tried to use the asterisk i.e. '*cell_contents*' in the countif formula but i get an error. please help! ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Business Software Galore! Free Excel Forum http://www.ozgrid.com/forum *** Tag: help excel freezing up Tag: 34897
  - 25
    - Excel Help I want to make a cell as a list box. How do I do this without actuall putting a list box in that cell? Thanks TyeJa -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34893
- Next
  - 1
    - Run-time error 6 Gretings, As part of a routine to create worksheets the following macro looks at a list and deletes any duplicates. The routine works great unless there is only one cell occupied in which case I get a "Run-time error "6" overflow. Is there any way of resolving this short of starting again. As you may have guessed my VB skills are lacking - this code was lifted off one of the posts here but has served me well thus far. Sub DeleteDuplicates() Dim X, C, xMax, y As Integer Dim S As String Range("A1").Select Range(ActiveCell, ActiveCell.End(xlDown)).Select X = Selection.Cells(1).Row xMax = Selection.Cells(Selection.Cells.Count).Row C = Selection.Cells(1).Column Do While X < xMax S = ActiveSheet.Cells(X, C).Value y = X + 1 Do While y <= xMax If ActiveSheet.Cells(y, C).Value = S Then ActiveSheet.Cells(y, C).Delete xMax = xMax - 1 y = y - 1 End If 'error occurs in the following line y = y + 1 Loop X = X + 1 Loop Range("A1").Select End Sub Tag: help excel freezing up Tag: 34890
  - 2
    - Problem I have One Cell whose value is constantly changing once a week. Input in WK3, resulting calculation ends in cell M3 M3 is copied to worksheet2, A1 (=worksheet1M3) I got this! Input in WL3, resulting calculation ends in cell M3 (again) M3 is copied to worksheet2, A2 (cell A1 changes to the new number) HELP! Can I lock a cell after the value is copied to it? Can I set conditions (time / date) on the cell after the value i copied to it so it won't change? Any help is always appreciated. Tom picktr@wowway.co -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34889
  - 3
    - Template Wizard with Data Tracking (wztemplt.xla) Path We moved a Excel template utilizing the Template Wizard with Data Tracking (wztemplt.xla) add-in to a new server. We where able to update the database path in the Excel template, but now I'm wondering how I change the path in the Excel Spreadsheets created by this template. Where does the wztemplt.xla (3424.xls) store the database path information? Thank You! Tag: help excel freezing up Tag: 34883
  - 4
    - Automatically copy input from one cell to another After I enter a value in one cell, how can I have it automatically enter it into another cell, within the same worksheet, or into a different worksheet. Thanks, Tom picktr@wowway.co -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34874
  - 5
    - One more question... not quite as idiotic I've gotten the numerical problem handled, and now I have a differen hitch in the getalong. I have a table in Access and I need to get all the info from the Exce spreadsheet into this table. It won't let me cut and paste the whol thing, maybe because I don't have the same number of rows. I can't seem to get Excel to create new rows for me unless I add the one at a time (and I'm not doing that 2500 times), and I'm not sure ho in the world to get this data over there. Arrgghhh... Any ideas? Thanks in advance, Wheele -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34863
  - 6
    - can i use an autofilter in a protected worksheet Hi there I have created a spreadsheet and locked certain cells so that users cannot change the information apart from one column. I then want to be able to filter the data using the editable column. Can this be done? Even using the Allow Users to edit ranges (with a different password) I cant get the filter to run when the workbook is protected. Any help would be appreciated thanks Jackie Tag: help excel freezing up Tag: 34857
  - 7
    - Consolidate rows on susequent sheets. Excel 2002 On sheet 1 I have data imported from an Access database. The data consists of individual sales that are made by a number of different sales people. In column "B" are the salesperson's names, and going accross in the subsequent columns is related information about that particular sale. There are quite a number of sales by each person on the sheet and so I want to copy all the sales from each person to a seperate sheet in the same book. I would also like to rename the Tab of that sheet with the salesperson's name if possible. The problem is that each time I import data to sheet 1 those names may change. If this makes any sense to anyone I would appreciate some direction. Thanks in advance. Rick Tag: help excel freezing up Tag: 34855
  - 8
    - Formula or VBA help Hi group - I have a very simple task, but having trouble figuring how to do it. I have values in a range of cells, let's say A1:A10. In cell A11, I have a formula that sums that range. In cell A12, I have a value that reads =$10,000.00. What I'm trying to accomplish is a prompt or something that will not allow any more data to be entered when the value in A12 has been reached. In this example, it's $10,000. Any help is greatly appreciated. My brain is now warped from thinking too much :-) Thanks in advance, Newtechie Tag: help excel freezing up Tag: 34854
  - 9
    - This will sound ridiculous but... I'm having trouble with a basic function. I have an entire column of prices in the format $xx.xx I need to take that entire column, say Column C, (titled "price") an multiply each cell by a number and paste such that Column D become those numbers plus tax. I have cut and pasted the entire contents of the original column in new column next to the original, so they're identical, now I need t multiply each and every cell in Column D by 1.0825. Any ideas how I can accomplish that? And before you start, I'm a techno-moron. I'll need very basi instructions. Thanks in advance, Wheele -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34846
  - 10
    - counting characters within a cell Is there a way to count the occurrences of a certain character within a cell? For instance cell A1 contains 1-20/2-12/3-9 I need to find how many times '-' or '/' occurs in A1 thanks in advance, Rowland Tag: help excel freezing up Tag: 34844
  - 11
    - Changing Comment font size? Is there a way to change the default font size for the comment box t something larger than 8? These old eyes having trouble reading th comments, especially if the sheet is shown on the screen at less tha 100% size. It is time consuming to have to individually change th comment size one comment at a time -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34840
  - 12
    - getting started... Hi, is it possible to create a macro that receives arguments? What I mean is without using offset, for example: one time to run the macro with cells A1 A2 as parameters and write the result into B2 and another time to run the macro over cells D5 E9 and write the result into F8? ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Business Software Galore! Free Excel Forum http://www.ozgrid.com/forum *** Tag: help excel freezing up Tag: 34826
  - 13
    - Excel Challenge Guys I have been given a very difficult task and I need help. Please!!!!!!!!!!!!!!!!! The issue has more to do with maths than excel. What we have is 10 Athletes who will compete in 9 different competitions. Each athlete with complete against every other athlete only once. So the total number of match will be 45. A v E B v E C v E D v E A v F B v F C v F D v F E v F A v G B v G C v G D v G E v G F v G A v H B v H C v H D v H E v H F v H G v H A v I B v I C v I D v I E v I F v I G v I H v I A v J B v J C v J D v J E v J F v J G v J H v J I v J We will film these matchs and need to produce 5 shows. This is where the problem arises. Every show must show all the nine completions and must not show each athlete more than twice. I will need to come with a list of matches that can be part of each show so that the above two conditions are satisfied. Can this be done or it is too challenging? Tag: help excel freezing up Tag: 34823
  - 14
    - Automatic Calculation Not happening Using Excel 2002 on XP Pro, some of my network users (2 so far) have reported that Automatic Calculation of their spreadsheets is not happening. This seems selective in that some spreadsheets work and some don't. Automatic Calculation IS turned on in Optioons, but does not happen. Only way to calculate is to F9 and perform a manual calculation. There are no macros running anywhere . Can anyone suggest any advice? Thanks Tag: help excel freezing up Tag: 34822
  - 15
    - Copying from Access to Excel problem I have a large Access database (20000 records of 30 fields each) whic has been imported from Paradox. Periodically I need to export this to Excel and have long ago given u on the 2 standard exporting techniques supplied: 1. File: Export and 2 Tools:OfficeLinks:AnalyzeItWithExcel since both generate errors after long time thinking about it! If anyone has any comments on this, pleas feel free to say! Incidentally, I have a 2.6GHz P4 with 1Gb RAM. I now manually transfer the data 6 cols at a time by 'copying' an 'pasting'. It is slightly tedious but it does the job in about minutes. (Previously I could wait 15 mins or longer before it reporte failure). Finally to my problem. The copied version keeps formats (which i excellent) but unfortunately also has each cell outlined in black. Whe I try to get rid of this via Format:Cells:Borders:Remove, Excel doe not leave the normal light grey edge to the cells. They are no effectively not bounded as if the gridlines had been switched off which is quite 'spooky'. How do I get rid of the black outlines t leave the normal light-grey border -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34821
  - 16
    - Lock workbook. Hello everybody, I have two workbooks, in the first I have some Forms (for me its programs workbook) and in the second I have datas. Is there some way how can I lock (write) the data workbook only for Macros-Forms. I dont want still open and close this workbook Thanks Tom Tag: help excel freezing up Tag: 34820
  - 17
    - Charts Hi, Im trying to make a chart in Excel, I have a list of addresses and states, I want to make a pie chart of the states to show what percentage of all the states each state is. But if I select the columns and click on the chart and choose pie, in the end I just have a line. Ok im not that great at this yet, just looking for a little help. -- Sincerly, Nick Pavlovich Tag: help excel freezing up Tag: 34815
  - 18
    - More than 65536 entries... When trying to import a text file that has more than 65536 entries, I get a message saying that there is more data than will fit on a single worksheet & to get it all you can repeat the import on another worksheet & tell the import wizard to exclude data already imported. I've tried Excel 2000 & Excel 2003 & cannot find this option anywhere. Can someone tell me where it can be found, or is there a way to "link" worksheets so it can automatically flow to the next sheet? Thanks- Tag: help excel freezing up Tag: 34811
  - 19
    - Rescale I need to rescale student scores to reduce the fail rate, for example if our exam failure rate exceeds 25% (ie 25% of students receive exam score of less than 50%) then I need to amend the pass score so that at least 75% of students have passed. How can I acheive this using Excel? Any help would be appreciated. Thank you in advance. Tomai Tag: help excel freezing up Tag: 34809
  - 20
    - Re: how do you have one cell alter another cell? For example: say I want cell A3 to do a logic test and if cell A1 i True th en have it enter a 4 into cell A2. I don't want to place any formula in ce ll A2 because if A1 is false then I want the user to be able to plac their own amount into A2. Is this possible and if so how do I do it. though tt he formula for A3 would be =if(A1=TRUE,A2=4,A2="") but this doesn work. Ca n anyone help me out? Thank - juniu ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message601750.htm Tag: help excel freezing up Tag: 34807
  - 21
    - Help Please What i want to do is really simple. I have column B with 50 numbers. I want to set up column C so that in C2, if B2=B1 and then it returns a value or something like false. It really doesn't matter what it returns though. Then in C3, if B3=B2 OR B3=B1 then it returns the false value Then in C4, if B4=B3 OR B4=B2 OR B4=B1 then it returns the false. Then in C5, if B5=B4 OR B5=B3 OR B5=B2 OR B5=B1 then it returns the false value. Can anyone help please? I think I could do it with alot of logical statements, but you can only put 30 conditions into one cell. With a list of 50 numbers that isn't enough, so Im kinda of stuck. Tag: help excel freezing up Tag: 34801
  - 22
    - Running Total in a cell. As I change the numbers in each of 4 given cells, I would like the 5th cell, holding the sum of the other 4 cells, to keep a running total. ex: cell a1 today input 2, and the other 3 cells also 2 for a total of 8 showing in the 5th cell tommorrow I change the four cells numbers to 3, 6, 6, 4. for a total of 19 but the 5th cell should show 27 Any help would be appreciated. Tom Pickett, picktr@wowway.co -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34799
  - 23
    - minimum and max figures in a cell Hello, This may be a very simple / studpid question but I'm stuck and was hoping someone could help me. I am using a basic spreadsheet that adds up figures and calculates 15% from a specifi set of figures. The problem I have is that I need the cell containing the 15% figure to be a minimum of 139.45 and the max to be 2440.45. sometimes the 15% figure is lower or higher than these limits and that is no use for my purposes. I'm not very experienced at using formulae or equations and can't figure out how to alter my equation to calculate 15% to return values within this range. The cell validation tool doesn't apply as it won't work for a cell with this equation. Any suggestions? Thanks for any help. Ian Tag: help excel freezing up Tag: 34793
  - 24
    - Auto FIll Weekdays dates Hi All, I need to create a spreadsheet that automatically fills in the dates(weekdays only) across the top. There are six separate periods to be inputted. The user inputs the start and end date of each period. Any ideas? TIA Tera ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Business Software Galore! Free Excel Forum http://www.ozgrid.com/forum *** Tag: help excel freezing up Tag: 34787
  - 25
    - Distmon error I am having the same prob that everyone else is describing, however have looked on the Microsoft support forum. I did a search and did no find the 2 Adobe files anywhere on my computer. I also disabled the NAV plugin...... I am still haveing the sam prob. Is there any OTHER way to fix this without reformatting!!?? Thanks in advance -- Message posted from http://www.ExcelForum.com Tag: help excel freezing up Tag: 34784

my excel 2003 keeps freezing when try to scroll or move my mouse over the
worksheet.

--
Mark Anthony Stephenson

Re: help excel freezing up by Seldar

Seldar
Wed Apr 28 11:40:05 CDT 2004

is it only that program or others also?

1: if this is the only program that freezes, uninstall program an
reinstall.

2: if other programs also freeze u may have a os issue or a hardwar
issue

3: if it does it randomely u may have a memory leak.

4: last but not least try rebooting a couple of times, u may just hav
a power surge

--
Message posted from http://www.ExcelForum.com

Top