Freeze pane issue

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
    - Scanning and Finding Barcodes I am trying to develop a tool for taking inventory. I have a spreadsheet with three columns - QTY, ITEM#, DESC. The sheet lists the items#'s of every item and their description. The QTY column is blank. When I scan a barcode, I want it to find the item# and then automatically put my cursor into the QTY cell next to the found item# so I can manually punch in how many I count. I think this should be easy, I just don't even know the first thing about programming this sort of thing. Can someone help me? Tag: Freeze pane issue Tag: 139067
  - 2
    - crazy chart task excel 2003 on XP We are tracking some workload variables. We have date, some classification and tracking information, some values to track, and some descriptive and comment data. I want to make a chart showing the tracking values by calendar week. I almost have the week function working with match() and index(). I am having no luck at all getting the right information to the chart (a clustered column chart). I used to know how to set up x and y axis data, but the new "whizzard" tools defeat me at every turn. Could i just use a manual chart (do they still exist)? Tag: Freeze pane issue Tag: 139063
  - 3
    - Column alignment I've been asked to design a "ticket" in Excel (Office 2000) which has quite a lot of pre-existing text, and several boxes which the person issuing the ticket must fill in. Some of the boxes will contain formulae which will be calculated based on the numbers that the user types in to other boxes. The problem is that in the design I've been given, the boxes do not all line up in regular column widths and row heights across the whole ticket. I know that I can merge some cells horizontally but (as far as I know) you can't merge cells vertically - and in any case this will only help a little. What I really need is to be able to move column and row boundaries for *some* groups of cells, independantly of other groups of cells. I think I can do this with Word tables, but I also need the ability to enter formulae into some of the cells like Excel. What is the best way to get the result I need? Tag: Freeze pane issue Tag: 139061
  - 4
    - Issue with CSV file I am programmatically creating a CSV file that has a list of formulae from a workbook/worksheet (see example below). Note that there are 5 records in the file, tho the text might wrap below in your newsreader to appear to have more lines. Double clicking on the CSV file causes Excel to issue #NAME? errors for the records marked as BAD, The records marked as "BAD" cause Excel to try to update the text due to the included references to worksheets. This occurs for a formula that begin with a "-" character. And, ditto for a "+". I can avoid the problem by sticking an apostrophe at the beginning of a formula that begins with "-". or by multiplying by -1 at the end of the formula. I can avoid the problem by sticking an apostrophe at the beginning of a formula that begins with "+". or by deleting the "+". Is there a better solution? "BAD","$I$11","-('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal ue)", "GOOD","$I$12","('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal ue)", "BAD","$I$13","-1*('123456789'!CurrentValue+'987654321'!CurrentValue+'00000' !CurrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentV alue)", "GOOD","$I$14","('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal ue)*(-1)", "GOOD","$I$15","(-1)*('123456789'!CurrentValue+'987654321'!CurrentValue+'000 00'!CurrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!Curre ntValue)", Tag: Freeze pane issue Tag: 139058
  - 5
    - Replace a comma with a period in a cell containing a lastname, first Hello - I am trying to clean some data and need to change all of my names from McLaughlin, Victor, (i.e, comma) W to McLaughlin, Victor.(i.e., period) W Is there an extract and replace formula or method of som sort (in excel or access) that will allow me to pull the first comma from the right and replace it with a period. Thanks for any suggestions! Tag: Freeze pane issue Tag: 139055
  - 6
    - open excel whenever I open excel the new workbook has 2 sheets named as sheet 2 and sheet3 why not sheet1 and 2 and 3. afd Tag: Freeze pane issue Tag: 139042
  - 7
    - Conditional Formatting - Date Initiated I have the sum of £900 in cell D4 (and other cells with sums) which I want to read zero on the 1st March 2009. Is there a formula I can use to return a cell to zero on a specific date? TIA Ed Tag: Freeze pane issue Tag: 139034
  - 8
    - Merge adjacent columns? Using Excel 2007, I have three text columns right next to each other. Can I merge these three columns into one? Thanks. Tag: Freeze pane issue Tag: 139033
  - 9
    - Reopens file on first click Anyone seen this behavior? When I open an .xlsx file from explorer (excel not yet open), then after the file is open, when I click on a cell the file refreshes like it just opened again and I have to select the cell again. It only happens on the first click then things are normal. Annoying! Any fix for this? Thanks, Joe Tag: Freeze pane issue Tag: 139027
  - 10
    - Printing names There is a View option to see formulae, so I can print the formulas. What about names? I can write code to list the names, put I'd rather print with names displayed. Is there an option to do this in Excel 97, 2000, 2002, or 2003? Tag: Freeze pane issue Tag: 139020
  - 11
    - locating duplicate records in a 300,000 record file I previously had help with writing a macro to eliminate duplicate records, and it worked great which told me there are two duplicate records. Now I need to quickly identify them. There is one column of numbers, sorted in numeric order. I just need to place an X in a helper column for each duplicate record so I can then sort by the helper column. Basically for this to be fast, I just want to compare one cell with the one above it. I've yet to figure out how to do that. Any help appreciated! I've googled up a storm and all I'm finding is deleting dupes or placing an X in a helper column but comparing all records in column A which will take too long with 300,000 records. Thanks! Tag: Freeze pane issue Tag: 139012
  - 12
    - Access problems with Excel spreadsheet I have a column labeled date, in which some putz has typed in text, such as "Closed", or "OnGoing". Some of the records actually have dates in them, though. When I link to the sheet in Access, it sees that the first several records are text and shows the field as text in Access, causing headaches.The spreadsheet is a report based on several sources and I'm pretty much stuck with it. However, I'm thinking of adding a column to the spreadsheet that could put a bogus date in when it finds nulls, empty strings, or text, such as "1/1/2099" or something, and returns the short date when it finds one. Any ideas? -- Bill Reed "If you can't laugh at yourself, laugh at somebody else" Message posted via http://www.officekb.com Tag: Freeze pane issue Tag: 139008
  - 13
    - Drop Down Menu Options? Need a PRO Big thanks to groups user huntermcg for this find. I have entered this into my "ThisWorkbook" - Private Sub Workbook_Open() Dim sh As Object On Error Resume Next Application.CommandBars("Navigate XL-Dennis").Delete Application.CommandBars("Navigate Sheets").Delete On Error GoTo 0 With Application.CommandBars.Add("Navigate Sheets", , False, True) With .Controls.Add(msoControlButton) .TooltipText = "Move Back" .FaceId = 1017 .OnAction = "Move_Back" .BeginGroup = True End With With .Controls.Add(msoControlDropdown) For Each sh In ThisWorkbook.Sheets .AddItem sh.Name Next sh .TooltipText = "SheetNavigate" .OnAction = "Sheet_Navigate" End With With .Controls.Add(msoControlButton) .TooltipText = "Move next" .FaceId = 1018 .OnAction = "Move_Next" End With .Protection = msoBarNoCustomize .Position = msoBarFloating .Visible = True End With End Sub and then I entered this into a module - Private Sub Sheet_Navigate() Dim stActiveSheet As String With CommandBars.ActionControl stActiveSheet = .List(.ListIndex) ThisWorkbook.Sheets(stActiveSheet).Activate End With End Sub Private Sub Move_Back() On Error Resume Next ActiveSheet.Previous.Select End Sub Private Sub Move_Next() On Error Resume Next ActiveSheet.Next.Select End Sub This created a neat little drop down menu for sheet navigation. (thanks to Bob Phillips for the code at http://www.excelforum.com/newreply.php?do=newreply&noquote=1&p=1358771) QUESTION - I've applied this to a project of mine and it works great. Although with my project I have a workbook with over 250 sheets :-) Is their a way to limit the amount of sheets displayed in the drop down box? also if the above is possible... Is their a way to have different set of sheets displayed for each worksheet? For example, on "sheet 1", the drop down only displays sheets 2-5. Upon the users arrival to sheet 4, the drop down menu displays sheets 30-50. Thanks for the help in advance. Tag: Freeze pane issue Tag: 139002
  - 14
    - Attempting to use data Validation I am attempting to use Data Validation to create a lookup from a different sheet. What do I need to input into the Source Field so that sheet 1 will pull data from sheet 2? I can see that the souce will populate =$A$2:$A$6. Tag: Freeze pane issue Tag: 139001
  - 15
    - Help HI I am trying to count the total of leave taken without the holidays and the weekends i have used the NETWORKDAYS but i dont know what is the formula in order to have a total of vacation taken excluding weekends and holidays so this is the table that i have i am using network days but its not working Total =NETWORKDAYS(B17,C17) B= from C=To Holidays Example B C C52 New Year 1/1/2008 C53 Labor Day 1/5/2008 C54 Independence Day 22/11/2008 C5 Christmas 25/12/2008 PLEASE ADVISE TIA Tag: Freeze pane issue Tag: 138996
  - 16
    - Latest MS Update KB943985 Breaks Excel CSV Capabilities Hi, After I installed KB943985 (the one released on March 11th, 2008), my Excel stopped properly opening CSV files. Prior to installation of this update, Excel 2003 was opening the files properly and automatically splitting them into columns. After I installed the update, when opening the exact same CSV file, all the data would appear in the first column (A). I went ahead and uninstalled the update. Now, I am able to open the same CSV file again without problems - it gets split into columns and everything looks good. Did anyone else encounter the same issue? Is MS going to fix it? Thanks, Arsen Tag: Freeze pane issue Tag: 138993
  - 17
    - Mass find/replace tool for Excel documents Hello, Not sure if this is where I should be, but I am referring to Excel docs, so I'll start here. I received this email today, and was wondering if anyone had any suggestions: "Wondering if anyone had any recommendations for a mass find/replace tool for use with Excel documents. Many of our departments have dozens if not hundreds of Excel documents that are linked to other spreadsheets on the server. The AD migration has changed the G:\ drive mapping, and now these links need to be updated. Rather than update each spreadsheet manually, weâ??d like to run some type of find/replace on the departmentâ??s G:\ drive to update all the links in one shot. We found a tool called â??ExcelPipeâ?? which seems to work fairly well, but itâ??s pricey and the company is inconveniently located in Australia. Iâ??ve found several shareware/freeware tools, but they seemed either unreliable or lacking features." Any suggestions? Do you need any further information? Thanks! Tag: Freeze pane issue Tag: 138992
  - 18
    - Exclude matches in a list --____YYFNYPCQEPRARTJPNJTN____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Sat, 14 Mar 2008 05:35:30 -0500" QWxsLA0KDQpJIGhhdmUgYSBkeW5hbWljIHJhbmdlIGxpc3QgYnV0IHRoZXJlIGFyZSBtYW55IGR1 cGxpY2F0ZXMgd2l0aGluIDkwMCsgZW50cmllcy4gSXMgdGhlcmUgYW55d2F5IHRvIHByZXZlbnQg ZHVwbGljYXRlcyBmcm9tIHNob3dpbmcgaW4gYSBkcm9wZG93bj8NCg0KRGF2aWQ= --____YYFNYPCQEPRARTJPNJTN____ Content-Type: multipart/related; boundary="____FLAHYDPYDBEUWALLZPCC____" --____FLAHYDPYDBEUWALLZPCC____ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Sat, 14 Mar 2008 05:35:30 -0500" PEhUTUw+PEhFQUQ+DQo8TUVUQSBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZSBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPE1FVEEgY29udGVudD0iTVNIVE1MIDYuMDAuMjkwMC4z MjY4IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiA0cHggNHB4 IDFweDsgRk9OVDogMTBwdCBUYWhvbWEiPg0KPERJVj5BbGwsPC9ESVY+DQo8RElWPiZuYnNwOzwv RElWPg0KPERJVj5JIGhhdmUgYSBkeW5hbWljIHJhbmdlIGxpc3QgYnV0IHRoZXJlIGFyZSBtYW55 IGR1cGxpY2F0ZXMgd2l0aGluIDkwMCsgZW50cmllcy4gSXMgdGhlcmUgYW55d2F5IHRvIHByZXZl bnQgZHVwbGljYXRlcyBmcm9tIHNob3dpbmcgaW4gYSBkcm9wZG93bj88L0RJVj4NCjxESVY+Jm5i c3A7PC9ESVY+DQo8RElWPkRhdmlkPC9ESVY+PC9CT0RZPjwvSFRNTD4= --____FLAHYDPYDBEUWALLZPCC____-- --____YYFNYPCQEPRARTJPNJTN____-- Tag: Freeze pane issue Tag: 138991
  - 19
    - problem importing xmlss - Worsheet Setting problem during load trying to open an xmlss and I get a message problem during load and in the text box it says: Worksheet Setting I sess the errors are listed in a file c:\documents and settings\xxx\local settings\temporary internet files\content.MSO\580887f9/log but I can't find that file. How can I determine what's wrong with my xml file? Thanks in advance Tag: Freeze pane issue Tag: 138990
  - 20
    - Date Comparison Formula Looks like I need some help, please: I have a column (A1:A12) of dates representing the twelve months of a company year (e.g. A1 = April 2007 to A12 = March 2008). In the second column (B1:B12) is a 'cumulative amount due' currency figure representing the sum to date of the monthly expenses claimed by an employee over the company year. The third column (C1:C20) contains the various dates that expenses were reimbursed to the employee. The fourth column (D1-D20) contains a record of the expense amounts reimbursed to the employee over the year. These reimbursements are random and not necessarily on a monthly basis. There might be more than one reimbursement in a month, or there might not be any. The number of reimbursements could exceed twelve in the year, hence using D1:D20 for this column. In the fifth column (E1:E20) I want to show the 'balance of expenses due' (or overpaid) to the employee at the date the reimbursement was made. What I would like to do is calculate the 'balance of expenses due' based on the date that the reimbursement was made (C1:C20), using the 'cumulative amount due' figure (B1:B12) for the same year & month. Example: If a reimbursement was made on 18 June 2007 (assume reimbursement date entered in cell C4 and reimbursement amount entered in cell D4) , then the amount reimbursed to date (sum cells D1:D4) should be subtracted from the 'cumulative amount due' figure in column B1:B12 that corresponds to June 2007 (June 2007 would be in cell A3 and the corresponding 'cumulative amount due' would be in cell B3). Therefore the sum would be (B3-SUM(D1:D4)). The answer should appear in cell E4 How easy is it to compare the year and month of the reimbursement date with the dates in column A1:A12, find the year/month match and use the corresponding 'cumulative amount due' in the calculation? Is this a task for VLOOKUP? I've tried VLOOPUP, but keep getting a #REF! error. Thanks -- Mike -Please remove 'safetycatch' from email address before firing off your reply- Tag: Freeze pane issue Tag: 138983
  - 21
    - VBA code needed to AUTOMATE SELECTION of names within VALIDATION I have searched the blogs and cannot seem to locate anything related to my challenge. I know you guys are gurus when It comes to things like this. I have a worksheet that tracks employee productivity for each cost center with a region. My excel worksheet contains three validation dropdowns that use the "indirect" function with various named ranges that link these dropdowns . So for instance lets say that the first dropdown relates to a region, the second relates to a cost center (there can be many cost centers in a region), and the third is a worker in that cost center (there can be many workers in a cost center). So, lets say that I select Northwest Region =E0 10001 (Cost Center) =E0 and Jim Stu, John Doe, Bob Doe, and Jane Done can all be selected from this cost center individually which changes the productivity data for each worker. Drop Down 1 (region) --> Drop Down 2 (cost center) -> Drop Down 3 (Worker) Range1 =3D Region Range2 =3D (indirect function from cell in Range 1) Range3 =3D (indirect function from cell in Range 2) What I would like to do is automate the printing process of the workers within a selected cost center using these already defined ranges. So for example in the example above I want to print all four names dynamically if some one decides that they would like to print all of the workers in ANY cost center. I am looking for the VBA code for this endeavor. Is this feat possible without having to select each and every worker within that cost center? Also, to take it a step further, is it possible to select all workers from every cost center and print all cost centers at once? Tag: Freeze pane issue Tag: 138981
  - 22
    - Excel 2007 Problem I just upgraded from Excel 2002 --> 2007 A particular file behaves strangely when saved in the original .xls format. EOMONTH function gets replaced with a currently unused NAME that refers to a formula upon Save. (This screws everything up, of course). Enabling the ATP add-in in the Name manager doesn't seem to make any difference. Saving in .xlsm format does seem to result in a proper file. What is going on? How to prevent it? Do I need to enable the either the regular, or the VBA ATP add-ins? Thanks. --ron Tag: Freeze pane issue Tag: 138979
  - 23
    - Combo Box I am trying to duplicate what another person did for consistency but can't figure it out. A Combo Box appears with the black upside-down triangle at the right side of the object. This triangle appears on a printed page just as it appears onscreen. There is another option for a "drop-down box", however, that I can not figure out how to duplicate. A cell appears to just have numbers or text in it, but when the cell is selected the black triangle appears, giving options to select. I can not figure out how to create this in other cells, or even edit the referenced cells which provide the options. The cell prints just like a normal cell - without showing the black triangle drop-down box. Please help! Our company is cheap and out-dated, so we have excel 2000. Tag: Freeze pane issue Tag: 138977
  - 24
    - Excel Data Not Visible in Cells 2007 I have two users in my office that use 2007 - myself and my manager. This morning something strange happened to a spreadsheet he was working on. There was data in the first 200 lines of the spreadsheet. somewhere around line 35 and up to line 60 the data - dissapeared. You couldn't see the text in the cells. BUT if you clicked in the cells you could see the info in the formula bar. He clicked save, and then it showed all the information again. This has happend several times over several spreadsheets. Can anyone help explain this?? Thanks Tag: Freeze pane issue Tag: 138976
  - 25
    - Problem keeping data synchronised with database query. Hi all, I'm using Excel 2003. I have a spreadsheet containing a database query (inserted using Data->Import External Data->New Database Query) with 5 columns. The 6th column is a notes column, in which the user can type little comments to help them. When clicking "Refresh Data" on the data, I have a problem if a row is deleted, because the Notes cell that was on that line is now inline with the next row. I would prefer it if the notes cell was deleted entirely (or, more specifically, if the entire row was deleted). Is this possible in Excel 2003? I've been through the 3 options in "Data Range Properties" for "If the number of rows in the data range changes upon refresh", but none of them will delete entire rows - only the cells in the data set. I currently have it set to "Insert entire rows for new data, clear unused cells.", and am using a Dictionary object in VBA to read in the "Notes" values, then write them back out after the refresh is completed - is there a better way?! Cheers, RB. Tag: Freeze pane issue Tag: 138975
- Next
  - 1
    - Strange behavior This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C88562.E7DE8BB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable A B C D as tr cf x er wr =20 sg rt yu x =20 sd ff x df qw cv x In the above array, columns A,B, & C are formulas. Theey represent a = first name, last name and email address, respectively. The formula for = column D is =3Dif(C2<>"","x",""). I've replicated it down the column.=20 When note that line 3 works correctly, but line 5 does not. Nor does the = formula work in any following rows.=20 I tried the same thing, programming in VB, with similar results. This = must be a setup problem, but I can't figure it out. I'm using Office 2007 SP1, and Vista Home Professional. Any suggestions would be appreciated... Jim ------=_NextPart_000_0006_01C88562.E7DE8BB0 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.6000.16609" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>A    B    = C    D</FONT></DIV> <DIV><FONT face=3DArial size=3D2>as    = tr   =20 cf   x</FONT></DIV> <DIV><FONT face=3DArial size=3D2>er   =20 wr           = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>sg   =20 rt   yu   x    = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>sd   =20 ff          x</FONT></DIV> <DIV><FONT face=3DArial size=3D2>df    qw   = cv  =20 x</FONT></DIV> <DIV><FONT face=3DArial size=3D2>In the above array, columns A,B, & = C are=20 formulas. Theey represent a first name, last name and email address,=20 respectively. The formula for column D is =3Dif(C2<>"","x",""). = I've=20 replicated it down the column. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>When note that line 3 works correctly, = but line 5=20 does not. Nor does the formula work in any following=20 rows. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I tried the same thing, programming in = VB, with=20 similar results. This must be a setup problem, but I can't figure it=20 out.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I'm using Office 2007 SP1,  and = Vista Home=20 Professional.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any suggestions would be=20 appreciated...</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Jim</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C88562.E7DE8BB0-- Tag: Freeze pane issue Tag: 138972
  - 2
    - Excel 2003 / Windows Explorer (XP) sort order differs - How to fix? In Excel 2003, mpeg2_MP@H1440_1280x720p_29.97fps_CBR_40Mbs_openGOP_zzscan.mpv comes before mpeg2_MP@H1440_720x576i_25fps_CBR_45Mbs_closedGOP_alternatescan_LFF.mpv In XP's Windows Explorer and also using DIR/ON in a command prompt shell window, the sort order is reversed. How do I reconcile the two so they sort in the same order? Thank you kindly. Tag: Freeze pane issue Tag: 138961
  - 3
    - ActiveCell I am trying to achieve If ActiveCell In Range ("C22:K22,C24:K24") Then but I require assistance with the correct syntax. Thanks Sandy Tag: Freeze pane issue Tag: 138956
  - 4
    - Excel available resources I am having an error that happens frequently when opening a workbook. It says "Excel cannot complete this task with available resources". It also happens at other times. I have seen this happen at other times as well, but it happens most frequently on workbook open. It happens most when the computer has just come back from the screen saver or having been locked (or both). I am working in Excel 2007 on a machine with 2 GB of RAM and 4096MB of virtual memory. There are plenty of available resources when I check the mem usage in task manager. The information I've read about this error doesn't seem to relate to it. I am not using named ranges, nested names, or an older version of Excel. After closing the error message and a secondary one which has code 101648 after I hit "CTRL+SHIFT+I", the screen becomes messed up. The application toolbar and parts of the screen "ghost" onto other screens. I then have to drag another window across them to get them to redraw. Excel has to be restarted. It doesn't appear to be related to how long my computer's been on. Remote Desktop also seems to impact my base machine sometimes causing this. Any help is appreciated. Tag: Freeze pane issue Tag: 138951
  - 5
    - Sumproduct error Hi! I have a formula that work fine on a computer, but on other computer (same software installed) it return #VALUE. Formula is: =SUMPRODUCT(--(Export!$G$2:$G$100>C9);--(Export!$G$2:$G$100<D9);--(Export!$D$2:$D$100)) Can anybody help? Thanks Tag: Freeze pane issue Tag: 138939
  - 6
    - Number format for basis points Hello I am certainly not the first to ask but I didn't find an answer yet. Is there anyway to create a custom number format that allows to display basis points in Excel? For instance if I have a cell with the formula "=2.5%%", I would like to see "2.5bps" appearing. "0.0%%" allows to get "2.5%%" appearing. Any trick to get beyond that step? thanks in advance Charles Tag: Freeze pane issue Tag: 138938
  - 7
    - PIVOT TABLE ALL option Is there any way to remove the "All" option that comes in the page fields in a pivot table?? Tag: Freeze pane issue Tag: 138936
  - 8
    - Excel Help for Immediate Window I cannot display VBA Help for the Immediate Window using Excel 2003 under XP home. When I open Help and search for Immediate Window I get several topics. The top two, Use the Immediate Window and Immediate Window Keyboard Shortcuts do not display any information. When I click on them the machine just sits there and does nothing. All the other topics bring up a window with the topic information. Do I need to do something other than just click on either of the top two to get information displayed? Thank you. Tag: Freeze pane issue Tag: 138935
  - 9
    - Cell colour according to date Hi, Is there a formula that would change the cell colour if a date in a cell was out of date afetr a set number of years. Example: Cell B9 contained date 140506 I then want the cell B9 to turn red when the date reaches 2 years later 140508. Thanks in advance Jason Tag: Freeze pane issue Tag: 138929
  - 10
    - missing menus when I open excel the only thing I can see is the title bar and the cells. all the icons and menus are missing eg file, edit, insert etc how do I get the menus back thanks steve Tag: Freeze pane issue Tag: 138928
  - 11
    - Footer i have following contents need to display in excel every page. anyway that can fullfill the request. I am using excel 2003 e.g contents approval by hod approval owner approval _________ ____________ ____________ audit aprroval implemented by reviewed by ___________ ______________ ____________ Tag: Freeze pane issue Tag: 138926
  - 12
    - Deafult / Forced view arrangement when opening Is it possible to set a default or forced view arrangement to e.g. cascade so that and existing excel workbook automatically opens and rearranges / resizes to this mode. Most sheets I receive have been created and saved with Excel maximised and so the sheets invariably open with scroll bars running off the right and lower edges and hence have to be re-arranged Thanks Sanjay Jain Tag: Freeze pane issue Tag: 138925
  - 13
    - Possible to indent the height of a row? Is it possible to apply a standard size across all rows, so that all tops and bottoms of the rows will be a specified distance from the text (similar to an indent, but from top to bottom) Thanks. Tag: Freeze pane issue Tag: 138923
  - 14
    - FYI - MS Plugs 7 XL Flaws Just came across this article. http://blogs.zdnet.com/security/?p=943&tag=nl.e550 -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- Tag: Freeze pane issue Tag: 138922
  - 15
    - how to stop the Web and Reviewing Toolbars from randomly being Hello - It seems that excel is randomly displaying the Web Toolbar and Reviewing Toolbar---even though I never need to use either one of them. Does anyone happen to know how I can stop this from happening? Thanks. Tag: Freeze pane issue Tag: 138921
  - 16
    - Converting pdf tables into Excel files Converting pdf tables into Excel files http://www.library.mcgill.ca/edrs/services/publications/howto/PDFtoXLS/PDFtoExcel.html Tag: Freeze pane issue Tag: 138911
  - 17
    - How to transform a cell value that as no comma like 43534 into 435,34 Hello to ALL. I would like to know what should i use as a command or formula on Excel in order to transform a cell value that as no comma like 43534 into 435,34. Is it possible to do this in Excel? How can i do it? I use Excel 2003 SP3. Thank you in advance for any help. Best regards, Hugo Rosa Tag: Freeze pane issue Tag: 138906
  - 18
    - Countif using less than or greater than criteria I have a list of data in cells d11:d15. I want to be able to count how many of the data points fall within a certain numeric range (ie less than 100 but greater than 50) but I want to be able to reference a specific cell containing the criteria rather than using '100' or '50' in the formula. In my worksheet 50 is in cell I2 and 100 is in cell K2. Tag: Freeze pane issue Tag: 138902
  - 19
    - Simple countif syntax request Hi, I used to use Excel a lot but haven't for a few years. What is the syntax for using a countif function these days? "=countif(a1:a10,>b2)" used to do the trick I have tried using help but for some reason "=COUNTIF(B29:B40,">B23")" is not giving me the correct result, ie if I put 6.5 into cell b23 it is returning 0 not the number of cells in the range B29:B40 which are greater than 6.5 which is incredibly frustrating! Thanks, Will Tag: Freeze pane issue Tag: 138898
  - 20
    - Data hidden/lost in Excel 2003 spreadsheet? I have an odd situation I was hoping some of you excel experts might be able to help me with. I was sent a spreadsheet (task schedule list) that was about 25kb (only 40 rows by 8 columns). After I did some editing (adding 2 new columns and adding some information to them) and saved the file, I noticed the file size has ballooned up to 2MB! I went hunting through the file to see if had accidentally pasted a something huge from my clipboard but could find nothing. I know it is the column I added as when I delete the entire column and save the file it goes back to the original 25kb. But when I delete the rows from this column where I added data (knowingly!) the file size does not change....it remains 2MB. I manually scrolled down from row 41 to 65,536 and could see nothing but white cells. I figure there's some data hidden in there but I can't seem to figure out how to find it. Can anyone recommend a good way to hunt this down? Much appreciated. Tag: Freeze pane issue Tag: 138895
  - 21
    - Excel 2007 acting weird So I go into My Documents and double click an existing Excel file to open. Seems quite normal, no? This document opens, as well as a separate file "Book1". It gets rather annoying, that I've already opened the file I want. I didn't open Excel (start w/ a blank workbook) then go File>Open. Even more annoying is that I didn't make any changes to Book1 (at least that I can see), but it asks when I try to close Excel "Do you want to save?" I did have Solver installed and enabled. I've since tried disabling, but that doesn't seem to do anything. Is this normal behavior? If not, how can I stop it? TIA KenB Tag: Freeze pane issue Tag: 138894
  - 22
    - Is there a way to copy a cell value into a cell comment? Is there a way to copy a cell value into a cell comment? thanks! Tag: Freeze pane issue Tag: 138877
  - 23
    - When any cell in row 19 (eg K19) equals X I want the cell in row 25 3 Any tips will be greatly appreciated. Cheers! Tag: Freeze pane issue Tag: 138875
  - 24
    - Can I move comment indicator to another corner of cell? In Excel 2002, those little triangular comment indicators display in the upper right corner of their cell. I want them in the U.L. corner instead. Can I tell Excel to do that? (There is no such option in Tools / Options / View's Comments panel.) Thanks. *** Tag: Freeze pane issue Tag: 138870
  - 25
    - Protection from cut and paste Cell C1 is protected and has the formula A1 + B1. The users in my office sometimes cut and paste A1 and B1 to A2 and A2. After the cut and paste the formula in C1 changes to A2 + B2. What I want is for the formula to remain A1 + B1. Is there a way to protect or prevent cuts and pastes? Tag: Freeze pane issue Tag: 138867

This should be easy but it seems to be confounding me.

I am using Excel 2007 and I want to Freeze all row above row 8 (so the
always remain visible as I scroll down). I select row 8 and select View and
Freeze Panes my only option seems to be to Freeze the Top Row, and that is
exactly what it does. What am I missing?

Re: Freeze pane issue by Tyro

Tyro
Sat Mar 15 21:18:45 CDT 2008

When you select row 8, in Freeze panes, you can select the uppermost option,
which is Freeze Panes. This freezes all rows above your selected row.
Apparently, you selected Freeze Top Row which freezes the topmost visible
row.

Tyro

"Patrick C. Simonds" <ordnance1@comcast.net> wrote in message
news:eutMlVwhIHA.3780@TK2MSFTNGP06.phx.gbl...
> This should be easy but it seems to be confounding me.
>
> I am using Excel 2007 and I want to Freeze all row above row 8 (so the
> always remain visible as I scroll down). I select row 8 and select View
> and Freeze Panes my only option seems to be to Freeze the Top Row, and
> that is exactly what it does. What am I missing?

Re: Freeze pane issue by Patrick

Patrick
Sat Mar 15 22:31:33 CDT 2008

Thanks, I just could not see the forest for the tree's

"Tyro" <Tyro@hotmail.com> wrote in message
news:9s%Cj.21491$0o7.10812@newssvr13.news.prodigy.net...
> When you select row 8, in Freeze panes, you can select the uppermost
> option, which is Freeze Panes. This freezes all rows above your selected
> row. Apparently, you selected Freeze Top Row which freezes the topmost
> visible row.
>
> Tyro
>
> "Patrick C. Simonds" <ordnance1@comcast.net> wrote in message
> news:eutMlVwhIHA.3780@TK2MSFTNGP06.phx.gbl...
>> This should be easy but it seems to be confounding me.
>>
>> I am using Excel 2007 and I want to Freeze all row above row 8 (so the
>> always remain visible as I scroll down). I select row 8 and select View
>> and Freeze Panes my only option seems to be to Freeze the Top Row, and
>> that is exactly what it does. What am I missing?
>
>