clicking onlocked cells problem - do help

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
    - Excel cannot complete this task with available resources Dear all, I've experiencing the error "Excel cannot complete this task with available resources. Choose less data or close other applications" when I tried open four Excel file which generated by program with ONLY data in cells. All four files are around 16-17MB in size. Problem persist in three different computer which all have RAM of 2G at least (Excel you at most 1G anywayz on ver. 2003). The wired things is the error only occured when I tried to open all four files in under the same Excel.exe, which is when you select all four files from file explorer then press enter to open it. If doesn't work either if you open the Excel application, then open the files by selecting File-> Open from the menu, then select those files. However, it works fine once you open the more than one Excel application, and open those files in seperate Excel.exe (which you can see the Excel.exe appear in the TaskMan twice). I've applied the lastest service pack, hot-fix but have no luck. Any help would greatly be appreciated. Thank you. Tag: clicking onlocked cells problem - do help Tag: 121000
  - 2
    - Newbie: Cell showing formula in words only. Help Excel 97 on a XP Pro. The formula for this cell is "=CASH!A1". I want it to just copy the content of the A1 cell in the CASH sheet, so whenver I change the content of A1 the cell will be updated automatically. It used to work quite well until yesterday when it just show the words "=CASH!A1" instead of getting the information. What did I do wrong? Help ABC Tag: clicking onlocked cells problem - do help Tag: 120996
  - 3
    - Remove last letter from entries in a column I have a long list of first names but some have a middle initial after their first name that I need to drop from the entire list. Sample would be: "Jennifer A" Can anyone tell me what function/code I could use to drop that last single letter from every row in that column, or leave it alone, if there is not a single letter at the end? Thank you! Tag: clicking onlocked cells problem - do help Tag: 120990
  - 4
    - Average speed Hi all Having trouble working out average speed. miles in a1 =14.3 time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS The formula A1/B1 brings back the wrong answer if I alter to A1/(B1*24) still does not work correctly. Advise please. Thanks Jon Tag: clicking onlocked cells problem - do help Tag: 120986
  - 5
    - Running Average How can I create a formula that creates a running average? Example... I have four column headings: Date, Weekly Pay, Weekly Average, Yearly Total. Each week I enter how much I'm paid in the Weekly Pay. The formula under Yearly Total is =IF(B2="","",N(D1)+B2), then I copy the formula down. The Weekly Average would simply be the grand total divided by the number of weeks. What would the formula look like? Tag: clicking onlocked cells problem - do help Tag: 120983
  - 6
    - plz help with macro The macro should send and email using outlook. The recipients will be in column A The email needs to include in the body the info in column B, C , D and E However, if the recipient is repeated I don=B4t want to send more than one email. Example: ColumnA - ColumnB - ColumnC-COL D -COL E a@a.com - James - Married - yes - june 1st a@a.com - Susan - Married b@a.com - Peter - Married c@a.com - John - Single c@a.com - Antonio - Single c@a.com - Marcia - Divorced REsult: one email sent to a@a.com that inccludes in the body James - Married Susan - Married one email sent to b@a.com that includes in the body Peter - Married one email sent to c@a.com that includes in the body John - Single Antonio - Single Marcia - Divorced Tag: clicking onlocked cells problem - do help Tag: 120970
  - 7
    - Basic Worksheet Help I can't find an auto sum function in google worksheet. Can some help? Tag: clicking onlocked cells problem - do help Tag: 120966
  - 8
    - Need the formula Okay, I have raw data that needs to fit into a report. I need a formula that says: This row equals the row from tab 2 that includes the word "orange" and/ or the word "sock" I'm a complete rookie to this so any help is appreciated. dzelnio Tag: clicking onlocked cells problem - do help Tag: 120962
  - 9
    - Earm Money Hi, mGinger.com pays you to read ads on your cellphone! These ads are only about your interests. Not only that, you get to decide when you want these ads. Based on my calculations I can easily make enough money to free up my cell phone bill. Check it out... http://www.mginger.com/index.jsp?inviteId=316855 See how much you can make. Have fun calculating...and sign up. You will like it... -Amit If u dont beleive it see the below link... of CNN IBN http://mginger.com/blog/index.php/2007/05/27/we-are-in-the-news/ Tag: clicking onlocked cells problem - do help Tag: 120960
  - 10
    - earn money Hi, mGinger.com pays you to read ads on your cellphone! These ads are only about your interests. Not only that, you get to decide when you want these ads. Based on my calculations I can easily make enough money to free up my cell phone bill. Check it out... http://www.mginger.com/index.jsp?inviteId=316855 See how much you can make. Have fun calculating...and sign up. You will like it... -Amit If u dont beleive it see the below link... of CNN IBN http://mginger.com/blog/index.php/2007/05/27/we-are-in-the-news/ Tag: clicking onlocked cells problem - do help Tag: 120959
  - 11
    - Importing Data Problem Hi I have a problem with importing text data. Our accounts structure is 99-99 - but when I import accounts such as 10-10 or 10-20 Excel thinks these are dats so loads 10-Oct or 20-Oct for me. Any way I can stop this? Thanks Max Tag: clicking onlocked cells problem - do help Tag: 120956
  - 12
    - check to see if a list of cells contains a string Hi, Is there a function to check if a list of cells (say form a1 to a10) contains a string in a cell (say b2)?? I try lookup and the problem of lookup is that even though b2 is not in a1 to 10, it returns the previous result instead of N/A. Thanks, wing Tag: clicking onlocked cells problem - do help Tag: 120953
  - 13
    - Copy Filenames into Excel I need to create an index with comments on a large database of engineering plans. I would like to copy "just" the filename and if possible the "date modified" from the plans directory to columns in an excell spreadsheet. Is this possible Steve Tag: clicking onlocked cells problem - do help Tag: 120950
  - 14
    - Help : Cell Flags In Excel 2003, some of the cells in my spreadsheet have a small triangle indicator in the top left corner. What does this indicator signify, and how can I remove it from my spreadsheet? Thanks for any help. Tag: clicking onlocked cells problem - do help Tag: 120947
  - 15
    - Time calcs in Excel Dear all, Having problems with a time calc in Excel. I have to design a spreadsheet which will be used at various offices within the company which needs to calculate staff hours worked in a week and also the amount of rest from one day to the next. So lets say a member of staff finishes work at 1100 on Monday and then resumes work at 1300 on Tuesday, that is a rest period of 26 hours. If I just take one from the other (1300-1100) Excel returns a value of 02:00:00 which is correct as far as Excel is concerned as I need to tell it the date. Herein lies the problem, I cannot expect the staff at the offices to input each cell in the format "25/May/07 17:00" etc as it will be too time consuming due to the numbers of staff involved.. So if they input the times in the format 13:00 is it possible via some code to solve the problem. I've tried having the date in one cell and using INDIRECT to join it and the time cell together without much success. Any ideas? Thanks very much for any advice. Colin. Tag: clicking onlocked cells problem - do help Tag: 120935
  - 16
    - Install add-in under Excel 2007/Vista - How? I have an add-in that comes with the instruction to add the .xla and support files to the C:\Documents and Settings\All Users\Application Data\Microsoft\AddIns folder. Of course, either this folder doesn't exist or I can't find it under Vista. Does anyone know which folder under Vista takes the place of the above folder under XP? Thanks. Tag: clicking onlocked cells problem - do help Tag: 120932
  - 17
    - shortcut to open workbook as read only? Excel 2000 I have a workbook that contains data that will be used for mail merge. Users will be filtering the data before the merge, so I want them to use a copy of the workbook so the original data is safe. I know users can select Open As Copy from the drop down next to the Open button, but it's not obvious to a casual user, so I'd like to create a shortcut in windows explorer for them that they can double click to open the workbook as a copy. Does anyone know if that's possible? Thanks :) Tag: clicking onlocked cells problem - do help Tag: 120931
  - 18
    - Converting Seconds to H:MM from query Hi: I have a query that returns a value in seconds and I would like to format the cell so that it gives H:MM. I tried the format of [H]:mm, but that seems to assume that the value is entered is in days, so if the value is "1", then it gives 24:00. What I want is that if the value returned is 5400, it shows 01:30. Do I have to change things on the query side? Thanks, Kayda Tag: clicking onlocked cells problem - do help Tag: 120928
  - 19
    - Comparing characters in cells I am trying to create a column (column C) that contains values only when the cell contents of column A and the cell contents of column B are EXACT matches. The characters in BOTH columns contain names of companies so there are both alpha and numeric values. The first FIVE characters (including spaces) of each line already match EXACTLY... see example below. I want column C to show a value only when ALL of the characters in the cell in column A match EXACTLY to all of the characters in the cell in column B. I am running excel 2007 but could run an older version if needed. ... The first five characters of each line are EXACT but the characters after character number 5 MAY not be exact. i.e. Column A: Column B: Column C: MICROSOFT.PUBLIC.EXCEL MICROSOFT.PUBLIC.WORD Able Body Labor Able Real Estate Usa, Inc. ABN AMRO Abn Amro Inc. Integrity Windows and Doors Integrity Windows and Doors Integrity Windows and Doors Central DuPage Hospital Centron Industries Inc. As you can see in this example the first five characters of each column match, but the rest of the cell characters do not match so there is not a value in Column C. Except for Integrity Windows and Doors. The characters in the cell in column A match EXACTLY to the characters in the cell in column B so there is now a value in Column B. This is a COMPLETE and EXACT match. I apologize for the length of this post and am open for clarification question. Thank you in advance. Tag: clicking onlocked cells problem - do help Tag: 120925
  - 20
    - Querying master worksheet Hi: I have a master worksheet that runs from an Access query. After it is populated I want the other sheets to be populated dynamically. So like this: WorksheetA ColumnA ColumnB ColumnC Agent Supervisor Calls b. smith 1199 3 s. jones 1199 6 a. sharma 2244 4 a. chong 2244 5 WorksheetB Header: Supervisor Number: 2244 ColumnA ColumnB Agent Calls a.sharma 4 a.chong 5 So basically each worksheet brings back a different supervisor. I know this is basic stuff, but I'm pretty new to do anything slightly complex with Excel. What is the best way to "query" the first worksheet and bring back a result set? Basically it would look at the value for the supervisor in the header cell and then populate several columns from the main sheet based on that. Thanks, Kayda Tag: clicking onlocked cells problem - do help Tag: 120924
  - 21
    - Import Data From Access to Excel Hi: I want to import data into Excel 2003 from Access 2003. I have an Access query that has 2 parameters and want to be able to pass those parameters from Excel. However, I see no way to pass those parameters-- I choose Data | Import External Data | Import Data option and choose an Access DSN. I run through the selections but there are no places to enter my Access parameters and I get the usual "Too few parameters..." error. There is also the option of Data | Import External Data | New Database Query, which I can build a query in Excel, and I can create parameters there in Excel, but the problem is it seems I can only make parameters from fields that are in the result set, and I the fields I want to choose on are not in the result set, i.e. I want to choose Month and Year but Month and Year aren't returned. Also, how do I prevent the query from returning the field headers? I have the field headers in my Excel spreadsheet anyway formatted nicely and just want the data. What is the best way to do this? Thanks a lot, Kayda Tag: clicking onlocked cells problem - do help Tag: 120921
  - 22
    - Turn Excel list into mass email I have an email list that I compiled of company employees. How do I convert this information to a mass email? Tag: clicking onlocked cells problem - do help Tag: 120914
  - 23
    - Any easy way to do this with Excel? I play tournament poker and run into situations from time to time where I need to figure some calculations quickly. A situation comes up in tournament poker when players left at the end of a tournament start to talk about splitting up the remaining prize money. The players with more chips should get more of the prize money as their chip stack has more equity then a player with a smaller chip stack. I'd like to create a spreadsheet that will calculate what each person should make in a perfectly even split based on the equity they hold in their stacks. The standard deal calculation is to look out how much money is still at stake -- in other words, assign everyone left in the field the lowest remaining prize and see what's left over -- and then distribute the remaining funds proportionately according to the chip stacks. For example: Let's say three players are left that will be involved in the potential deal with stacks of 200k for Player 1, 170k for Player 2, and 130k for Player 3 (500k total). The prize money is $1000 for 1st, $700 for 2nd, $500 for 3rd. Each player gets at least $500 at this point (as they have already guaranteed 3rd place money), so there's only $700 remaining in play (1000+700+500-3*500). So the deal amounts based completely on the equity each player has in his chip stack would be: Player 1: 200k/500k = 40%, so $500 + 40% * $700 = $780 Player 2: 170k/500k = 34%, so $500 + 34% * $700 = $738 Player 3: 130k/500k = 26%, so $500 + 26% * $700 = $682 The amount of players involved in the "deal" could be anywhere from 2-9. I want to set up the spreadsheet to where all I need to enter is the remaining players chip count and the prize money breakdown. The spreadsheet would then need to calculate from the remaining prize money, how much is left for each player to play for and what % of that amount each player deserves based on their chip stacks (their chip stack / total chips in play). So, is there an easy way to make a spreadsheet that will allow me to figure these calculations? THANKS in advance for any help !!! Tag: clicking onlocked cells problem - do help Tag: 120902
  - 24
    - relative date appearance I am working on a project tracker in which relative dates are calculated. For example, Column C's formula is =B(row #) +7, indicating that the date in Column C is the date in Column B plus seven days. Because this is a project tracker, information will be added to the spreadsheet as new projects come along. If I drag the formula down so that it will be available for future projects, the cells read 1/0/1900. Is there a way I can have the formula in place for future projects but leave the cell in which it resides blank? Thanks. Tag: clicking onlocked cells problem - do help Tag: 120900
  - 25
    - Refreshing F9 vs. F2 F9 is supposed to refresh the entire workbook and/or cells which you have selected correct? And F2 is used to edit a cell's value on the worksheet correct? So why can I hit F9 5 times without a formula value updating but as soon as I F2 the cell and hit enter, the value updates? This has puzzled me for some time, anyone know the answer? Thanks Tag: clicking onlocked cells problem - do help Tag: 120898
- Next
  - 1
    - comparing 2 files with Vlookup possible? I have been asked to use Vlookup to flag similar entries in two files using vlookup. Is it possible? Thanks Tag: clicking onlocked cells problem - do help Tag: 120893
  - 2
    - Need Macro I would like to delete rows based on if a cell has a particular value. E.g. Column M has a string value, "1 2 3 A B C". I would like to delete all rows that DO NOT contain value "C". Thanks, Bill Tag: clicking onlocked cells problem - do help Tag: 120880
  - 3
    - repeated info Hello, I have a document in which (under column A) I have different employees UserID. The problem is that some of them are repeated many times... Since the list includes about 6000 entries, I can't go one by one and delete the ones that are repeated. Is there a way to automatically go through the 6000 entries and delete the ones that are repeated??? Thanks!!! Tag: clicking onlocked cells problem - do help Tag: 120879
  - 4
    - Dynamic range from a different XLS file for a pivot table Hello. I have several pivot tables in an Excel-1 file. They all aquire the data from another Excel-2 file where I have a List created, which enlarges everytime I add more data to it. I have created a dynamic name in Excel-2 as explained in http://contextures.com/xlPivot01.html. I would like to use the name of the data range in Excel-2 in the pivot tables as its source data in Excel-1. Unfortunately, when I try to use that name as an external source for the pivot tables, it doesn't appear. Do you know how could I do that? Maybe I could create some cell with the data range in Excel-2 and make the pivot table aquire the range from that cell, but I don't know how can I make the pivot table to aquire the content of a cell as the data range. Any idea? Thanks in advance. Tag: clicking onlocked cells problem - do help Tag: 120878
  - 5
    - Macros with unknown table lengths Hi, I'm relatively new to macro programming with excel, and I'm having trouble dealing with variable length data. Every week I get a spreadsheet that has data in columns A through J, and rows 1 through somewhere around 3000 plus or minus a hundred or so, and 3 sheets. I need to take the data from sheets 2 and 3 and append them to the bottom of sheet 1, as well as put a formula into column K and copy it down to the end of the data. When I tried to record a macro doing this, it always saves a cell address for the last row in this particular spreadsheet, so it won't work on next weeks because there will be a different number of rows. Is there an easy way to fill column K down to the same number of rows for which there is data in column A? Tag: clicking onlocked cells problem - do help Tag: 120877
  - 6
    - Project data and time imported into Excel - How to remove time portion Hi I am exporting date fields from Microsoft Project into Excel, the problem I am having is finding a way of getting rid of the time portion as it is interferring with the calculation. I understand that a date and time is stored as a double, the integer part is the date and the decimal part is the time. I would like to easily remove the decimal part of the imported part. Any help would be good. thanks daryl Tag: clicking onlocked cells problem - do help Tag: 120873
  - 7
    - fomulas; copy formulas but only changing sheet Hi, We all know, I guess, what Excel does when copying a formula down. Cell A1 will become cell A2, etc. However. I have a 'index' sheet with the most basic info like name, adress and identification number. This info comes from the sheets that can be found in the document. For example: The index sheet looks like this: A Sheet 1 B Don Franco C Sunflower 34 D Netherlands E ID 3255 On the second sheet, which is called '1', you will find these exact information because the index has the formula which refers to cells in sheet 1 and column B is hyperlinked to sheet 1, 2, 3, etc. So; by clicking the name of de person, you go directly to more information about the person. I have about 34 persons which 7 columns. Problem was that it was first build as index has the hard data and the sheets had the links like '=index'A1' etc. I changed that so everything on index is linked to the sheet (which now has the hard data). Problem (finally, sorry!): I use '$' to keep the right cells by copying down. However; I have to change each cell cause the sheet doesn't change. I need this: ='1'$C$1 and on the next row: ='2'$C$`1 etc By copying Excel does: ='1'$C$1 and on the next row: ='1'$C$`1 etc Is there a way to make Excel doing this so I don't have to change every single cell? (34 x 7 = a lot of time!) ='1'$C$1 and on the next row: ='2'$C$`1 etc Thanks, Don Franco. Tag: clicking onlocked cells problem - do help Tag: 120872
  - 8
    - corrupted date conversion I have an excel file that was somehow corrupted. After Excel repaired the file, almost everything was ok, except the dates. They were somehow converted into numeric form. For example, May 18, 2007 was displayed as "39220". Can someone suggest a quick macro that can convert all the numbers back to the original date entry? Tag: clicking onlocked cells problem - do help Tag: 120865
  - 9
    - Using the SUM Formula How do I create a formula that adds from the top of a column? Here's the situation. I have a column of numbers (with a header of "Pay"). To the right of that colum I want to keep a running total ("Yearly Total"). Every time I get paid, I'm going to enter the amount in the pay column and then I want the Yearly Total column to automatically add it. When I create a fomula (say =SUM(B2:B21)), and propigate it down, it doesn't start at the top. In others words the next formula is =SUM(B3:B22). I want it to be =SUM(B2:B22). And, if a value is not filled in on the Pay column I want the Weekly Total to be blank. I only want it activate if there's a value for Pay. I guess I would have to use a conditionally formula as well, right? Tag: clicking onlocked cells problem - do help Tag: 120859
  - 10
    - Access data on spreadsheet without accessing the file?... Hi, I have built a large, complicated spreadsheet with highly sensitive information. It is only accessed by a few people. There are other people who need some of the information on one tab of the worksheet, but they are not allowed access to the file. I have been asked to come up with a way to make this happen. And I can't be accomplished by just allowing access to the one tab they need. They can have NO access to open the file at all. I thought of creating a separate worksheet that links to the info they need, but the problem with that is that there is a lookup on the tab they need access to, where they put in an ID number and it populates the other fields on that worksheet from other worksheets in the file. So if they had a linked worksheet, how would it pass the ID number to the original file to populate the fields? I hope this is making atleast some sense. I was just hoping someone out there may have some ideas. Thanks. Tag: clicking onlocked cells problem - do help Tag: 120849
  - 11
    - GetPivot Data Hi All, In a spreadsheet i am using the getpivotdata formula, and the pivot valuesare stored in separate files. Eg: GETPIVOTDATA("Sum of Total$",[wk21sd.xls]Pivot!$A$3,"Name",$A7) Now my problem is the file name changes every week i.e. wk21sd will become wk22sd. i am unable to change the week name in the formula. i tried using offset which gives me the desired week name but the getpivotdata still does not give any value in result. Please help. Thanks, Navin Tag: clicking onlocked cells problem - do help Tag: 120847
  - 12
    - Changing cell color from a function I have created a fairly simple function that will effectively cycle a number from 1 to 288 then back to 0. It works fine. The function will be applied to around 1000 cells. In addition to the roll oevr I now want to indicate that roll-over has occurred by changing the fill-color of the cell. It does not seem to work I have copied the same cell-changing code :- Worksheets("Scheduled Servicing").Range("G44").Interior.ColorIndex = 3 Worksheets("Scheduled Servicing").Range("g44").Interior.Pattern = xlSolid to a subroutine and it works fine. If I call the subroutine from the function it does not color the cell I am beginning to get the feeling that a function cannot change the color of a cell even via a subroutine. Is this correct? If so how can I cange the color of the cell? Conditional formatting is out as the requirements for color changing may end up be very complex. Many Thanks in advance Andy Tag: clicking onlocked cells problem - do help Tag: 120836
  - 13
    - Commnets When I do a print preview I can't see my comments. How can I fix this? Tag: clicking onlocked cells problem - do help Tag: 120833
  - 14
    - Eine Zelle auseinander nehmen Hallo zusammen kann mir jemand helfen, ich habe folgenden String "doggwils; gagnauxl; lusten; muellu" in einer Tabelle, und sollte die einzelnen Begriffe zwischen den ; auslesen, und weitere Tabellenbl=E4tter mit dem durchsuchen. kann mir jemand einen Tip geben, wie ich am besten vorgehe? Tag: clicking onlocked cells problem - do help Tag: 120825
  - 15
    - The window menu Can't ms follow their own gui conventions? When I hit alt-w + 1 I want to see the first opened spreadsheet, alt-w + 2 the 2nd, etc.... alt-w+1 opening the 2nd one. How the heck do I do this? I use excel 2000, though they all have this problem. Tag: clicking onlocked cells problem - do help Tag: 120821
  - 16
    - How to match on null cells I want to look up a value in one column of my worksheet in another worksheet, using the MATCH() function. In some rows, this column is empty. For this case, I want to use a default value, so I extended the range of the lookup table by one row, assuming that the null cell being compared would match the null cell in the new last line of the lookup range. Does anyone know if there is a way to do this without resorting to IF() or replacing all the null cells with some other placeholder value? Tag: clicking onlocked cells problem - do help Tag: 120815
  - 17
    - Calendar Spreadsheet: Column 1 = Date, Column 2 Time of Day, Column 3 memo text field I am an excel novice. Looking for a template or instructions on how to create a Calendar Spread Sheet with a single line for each day. I.E. Left Hand Column Would be a date Column Friday June 1st, 2007 Saturday June 2nd, 2007 or to make it more simple Friday 06/01/07 Saturday 06/02/07 ... and so on (want to start with 2006) 2nd Column should be time of day Want to be able to manually insert a duplicate a line, e.g. more than one event on a given day. Like to know how to create additional columns that are true false and/or time of day fields. Also want a final column that is a variable length text field for comments. Thanks for your help. -- "J. J." Tag: clicking onlocked cells problem - do help Tag: 120811
  - 18
    - dynamically copy cell content and fill color I know I can easily copy the contents of cell S1 to cell A1 by simply putting =S1 into cell A1, but can I also copy the fill color and content from S1 to A1 using some function? TIA John Keith kd0gd@juno.com Tag: clicking onlocked cells problem - do help Tag: 120810
  - 19
    - Total Different Cells I have a list of cells in two rows: Harry 40 John 41 Harry 13 Bob 20 John 23 Bob 23 I need to extract the total of each person and enter in another TWO rows by name and amount. Only one name for each person will appear. As: Harry 53 John 64 Bob 43 NOTE:--Alpha'd if possible. Thanks. Etc. Tag: clicking onlocked cells problem - do help Tag: 120808
  - 20
    - New row after server data input and copy forumla. Greeting all, I'm looking for a Macro that will help me out. Here's my scenario: I have intermittent (maybe every second or spontaneous) data entered in Excel via an OPC server. The data is entered per row, so I may have 30 values entered along row 1. The cell's formula may look like this: =OPC|TagValues!servername.datavalue What I'm trying to do is check to see if data has been entered in the row, if it was entered go to the next row while copying the forumla to the new row. So basically, the data will propogate down the spreadsheet as the server sends more data. Thanks for any help, Nate Tag: clicking onlocked cells problem - do help Tag: 120806
  - 21
    - problem printing chart in Excel97 In Excel 97 data on the Y-axis of chart have positive and negative values. The X-axis ticks are printed in the middle of the chart, i.e. on the zero line. Is there any way to prevent this and get the X-axis ticks printed at the bottom of the chart? Tag: clicking onlocked cells problem - do help Tag: 120803
  - 22
    - Multiple sheets printed to single page I have a spreadsheet with 3 sheets. Each sheet is just a small table but the column widths are specific, Each sheet is only 3.5 inches tall. I want to print all three sheets on a single page. How do I do this. I've been all over Excell and cant figure it out. Any attempts to merge the sheets ends up modifieing the column widths. Thanks Tag: clicking onlocked cells problem - do help Tag: 120800
  - 23
    - Paste Cell Contents into Custom Header I'm setting up a Custom Header under File...Page Setup and I want to be able to include the contents of a cell in the Header. While the cell address stays the same for every worksheet, the value within the cell will change. Is this possible? Thanks, Barry Tag: clicking onlocked cells problem - do help Tag: 120796
  - 24
    - XL2003: Why won't some formulas auto extend? In XL 2003, I have "Extend data ranges and formats" checked. In one workbook, some formulas will extend, but others won't. I'm down to row 64, so I've got the formulas in at least the previous five rows as required. It works this way with both manual and automatic calculation. Can anyone give me any hints as to how to correct this? Ed Tag: clicking onlocked cells problem - do help Tag: 120790
  - 25
    - Carton size and cubic feet auto calculate.. I have an Excel sheet for our "Shipping Manifest". It shows how many pieces in a carton, carton size, cubic feet, etc. We have standard carton sizes we use which we've named. Carton A = 18 x 18 x 18 = 3.38 Cubic Feet Carton B = 18 x 18 x 14 = 2.63 Cubic Feet Carton C = 18 x 16 x 14 = 2.33 Cubic Feet .. etc, on down to Carton J. Is there a way to make it so we can type A, B, C, etc under "CTN SIZE" column it will automatically enter the cubic feet for us under the cubic feet column? Then at the bottom of the sheet we'll have a total which will total up the cubic feet for us. Tag: clicking onlocked cells problem - do help Tag: 120785

I have created a worksheet in which i have locked certain cells that i
do not want users to mistakenly change or enter data erroneously - a
fact that is likely to occur as less knowledgeable personnel shall be
using the same

MY question is that when a user mistakenly clicks on a locked cell by
default is an error mesage supposed to pop up? It does not in my
worksheet - instead the cursor just goes back to the last cell that is
unlocked. Is this the default behaviour of Excel? If it is not
anyway to get back to the original behaviour

How do i create a custom message that will show when the user does try
to access a locked cell deliberatlty or mistakenly ?

Mine is a file created in Excel 2007 and saved in Ecel 2003

Thanks for any help in this group

Top

Re: clicking onlocked cells problem - do help by Gord

Gord
Mon May 28 15:17:04 CDT 2007

Sounds like when you protected the sheet you disabled the "select locked cells".

You can re-protect and give users the abilility to select locked cells and get a
message.

If you want a customized message see this thread from yesterday.

http://snipurl.com/1mgdt

Gord Dibben MS Excel MVP

On 27 May 2007 21:32:53 -0700, keskarsanjit@rediffmail.com wrote:

>I have created a worksheet in which i have locked certain cells that i
>do not want users to mistakenly change or enter data erroneously - a
>fact that is likely to occur as less knowledgeable personnel shall be
>using the same
>
>MY question is that when a user mistakenly clicks on a locked cell by
>default is an error mesage supposed to pop up? It does not in my
>worksheet - instead the cursor just goes back to the last cell that is
>unlocked. Is this the default behaviour of Excel? If it is not
>anyway to get back to the original behaviour
>
>How do i create a custom message that will show when the user does try
>to access a locked cell deliberatlty or mistakenly ?
>
>Mine is a file created in Excel 2007 and saved in Ecel 2003
>
>Thanks for any help in this group

Top