Free Microsoft Excel 2013 Quick Reference

restricted values that can be entered

When entering information into a cell, excel comes up with a error messages
that states " The value you entered is not valid. A user has restricted
values that can be entered into this cell". The cell is formatted as General
and is not protected.


When entering information into a cell, excel comes up with a error messages
that states " The value you entered is not valid. A user has restricted
values that can be entered into this cell". The cell is formatted as General
and is not protected.

I am creating an electronic timesheet that contains cells in which the time of day is entered. Sometimes, it is necessary to enter text into this cell via a drop down box that includes such options as "Vacation" or "Sick Time". When I now try to type in the dime of day (e.g. 17:00), it gives me an error stating "The value you have entered is not valid. A user has restricted values that can be entered into this cell." How do I allow a cell to have a drop down with a few selectable items while still allowing the times to be manually typed in?

Hi when i tried to input some value in a workbook, i am getting an error msg "The value you entered is not valid. A user has restricted values that can be entered into this cell". Can someone help how to remove restriction on the cells
Thanks

Hello
I am working on this legacy excel sheet and i tried to put a value in this worksheet and got the error

"Microsoft Excel

The value you enetered is not valid

A user has restricted values that can be entered into this cell"

how can i change these values?

Is it possible to expand a data validation list to allow adding ANY value, and then adding it to the list? This would allow a pre defined list to grow as new values are entered. When I try to add a value not in the list, a message box appears, "The value you entered is not valid. A user has restricted values that can be entered into this cell."

Is there a workaround to this?

Thanks for your help.
chazrab

I have successfully created a drop-down list in a excel worksheet. One of
the values in the list is 'Miscellaneous'. If a user selects this option, I
would them to be able to type in additional information in that cell. For
example, they could type in 'Miscellaneous (New funds)'. Currently when I
try this, I get error message "A user has restricted values that can be
entered into this cell".

Hi all,

I am trying to do the following:

I have a list created which allows me to select between "Pass", "Fail", "Not Tested". This is done using data validation. All cells in column D have this option from D5 down.

I want to column to be blank (Default) when nothing is entered in the corresponding A column (e.g. When A7 is blank I would like D7 to be blank). D7 should not be allowed to enter data when there is nothing in A7.

When the column A cell is populated, I want the Default to go to "Not Tested" in the D cell (e.g. Cell A7 is populated with number 1.4.6.2, and D7 now states "Not Tested").

I want to be able to select "Pass" or "Fail" at a later date with the information still entered, but I should not be able to delete "Not Tested".

Is there an easy way to accomplish this? I'm not too familiar with VB, and I've stumbled upon some sites with useful commands, but nothing I'm doing seems to work. For example, I click cell D7 and tried typing =IF(ISBLANK(A7),"","Not Tested") but that didn't seem to work as excel spewed out "The value you entered is not valid. A user has restricted values that can be entered into this cell." I'm guessing this is due to my list.

Any ideas?

I am trying to block usage to a cell using the lock and unlock function unless a specific criteria is met. I have the following code working to lock and unlock the cell but when it unlocks and I try to input anything in the cell I get an error that says "The value you entered is not valid. A user has restricted values that can be entered into this cell" What is causing any value to be restricted from being entered?

My code is as follows:


	VB:
	
 Range) 
    If Range("E11").Value = "Y" Then 
        ActiveSheet.Unprotect 
        Range("F12").Select 
        Range("F12").Locked = False 
        ActiveSheet.Protect 
         'Enable lock property if E10's value is anything else or is deleted.
    Else 
        If Range("E11").Value  "Y" Then 
             'If [E10]  "'Y" Then
            ActiveSheet.Unprotect 
            Range("F12").Select 
            Range("F12").Locked = True 
            ActiveSheet.Protect 
             'Optional, reprotect sheet
             'ActiveSheet.Protect ("PASSWORD")
        End If 
    End If 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Thank you for any help

Hello All:

I received an excel file from a company which instructs me too fill in data lets say Cell D40. However, everytime I try to enter data I get a message from the Assistant saying "The Value you have entered is not valid, A user has restricted values that can be entered into this Cell".

The cell does not appear to be protected. There are no macros involved. Can anyone enlighten me on what is going on here??

I would like to add to a drop down list that is in a column of an excel
spreadsheet. I can insert a line and then when I try to add or change the
drop down list, I get the following error:
"THE VALUE YOU ENTERED IS NOT VALID. A USER HAS RESTRICTED VALUES THAT CAN
BE ENTERED INTO THIS CELL."

I received this spreadsheet from a coworker that had created it. I believe
they may have copied the information from another spreadsheet. Is it possible
she brought some protected information with it?

I have created a spreadsheet using vlookup & I now need to amend some of the
information in the range of data, however, when I try to change this I get
error message "The value you have entered is not valid. A user has restricted
values that can be entered into this cell" Please can you advise how I can do
this. Thanks

Hi All,

I have made a drop down in excel.
After I select one of the categories from the drop down, I need to add more data to it.
e.g. If I select Fruits_ from drop down, I need to add Apple (manually) after fruits such that it would look like : FRUITS_APPLE.
I should be able to add anything manually after FRUITS_

Whenever I try to do it, it shows me an error that "user has restricted values that can be entered into this cell".

Please guide me.

Thanks in advance

I have created a spreadsheet using vlookup & I now need to amend some of the
information in the range of data, however, when I try to change this I get
error message "The value you have entered is not valid. A user has restricted
values that can be entered into this cell" Please can you advise how I can do
this. Thanks

I apologize if the answer's already been given in another thread, but I couldn't quite find it in my search.

In a single cell, I'd like to include an IF statement and validation list reference. The goal: if a cell is a certain value, I'd like all of the following cells in that record (row) to kick over to "N/A". These other cells currently reference a validation list. Otherwise, I'd like the drop-down lists to be available.

My thought was: =IF(a2="Support","N/A",...)
For the ... false value placeholder, I was hoping to be able to reference the validation list.

The error I'm getting when I try the IF statement in a validation list cell is: "The value you entered is not valid. A user has restricted values that can be entered into this cell."

Is there an easy fix for what I'm trying to achieve?

Hi,

Here is my challenge:

I have a list of 3 items: vegetables, fruits and other, and a dependent list for each of them. When "other" is selected, the dependent list is set to show a blank field.
Now, when I try to edit it I get these error messages "The value you entered is not valid"; "A user has restricted values that can be entered into this cell".

I've tried different things but couldn't get rid of the error message.
Can anyone tell me how can I keep the dependent list but still be able to edit a blank field within the list?

Thank you
marius

Hi,

New to this so here goes. An admitted newbie but prepared to 'do the yards'.

Have a workbook with a number of worksheets.

One of the worksheets is titled 'TEMPLATE' - this is a calculation sheet that is used to determine pricing - on a quarterly basis. A number of cells in this worksheet reference cells in another worksheet titled 'CURRENT RATE' in the same workbook.

Every quarter, we are provided a new 'CURRENT RATE' worksheet.

At the moment, we have to manually rename the existing worksheet 'CURRENT RATE' to a title referencing the quarter that it was applied to ie Rates DEC2011-FEB2012. Then insert the new version worksheet , rename it 'CURRENT RATE'.

The problem is that the cells in the 'TEMPLATE' worksheet that reference the original 'CURRENT RATE' worksheet changes to the new name of the original worksheet. This results in me having to track through the 'TEMPLATE' worksheet to re-reference the affected cells back to 'CURRENT RATE' once I have inserted the new quarterly worksheet (and renamed it to 'CURRENT RATE').

I've looked at absolute values but am getting an alert. I have tried a number of methods ie =ABS('CURRENT RATES'!$D$3), =$'CURRENT RATES'!$D$3 & ='CURRENT RATES'!$D$3

Alert states 'a user has restricted values that can be entered in this cell'

I have a spreadsheet that I have to use, (that was created by a CPA)
with a column that has a dropdown validated list. I would like for it to autofill when I start filling it in. He has somehow prevented me from doing this- the list for the dropdown is less that 20 codes and the list formatting is:
1102 - Personnel
I would like to type 1102 hit tabkey and have it pick that line from the list and auto fill- instead it tells me the error: the value you have entered is not valid User has restricted values that can be entered into this cell
And on top of it all, he has merged 6 or 7 cells together to create this location of where the list is to populate
is there any simple way to fix this that anyone could share? I lived with this the last whole fiscal year and would like to start out different this year for faster data entry. TX

I want to format a cell so that only specific numbers can be entered. For
instance only numbers between 1 and 5 can be entered. All other numbers will
either force an error message or simply cannot be entered.

I have a formula question regarding entering a value in a cell and having it automatically display something in another. Here is what I am trying to do:

I have three values that can be entered into a cell in column A, they are "Customer, Vendor, or Internal". I then want a cell in column B be to display a numercial value depending on what value was entered into the cell in column A.

Customer = 32
Vendor = 64
Internal = 45

I am sure a name exists for this type of formula, but without knowing it makes it hard to research it own my own. Any assistance would be greatly welcome. I am an engineer so using this will help me to track the costs incurred but different types of defects.

Shane

I have one spreadsheet cell that has 5 "IF" statements and contains a total
of 435 characters,504 with spaces and the cell results are truncating the
final "IF" statement value.
Is there a limit on "IF" statements or a LIMIT on the number of characters
that
can be entered into a individual cell.

thanks for any help
--
mike

Is there a worksheet function on locating a word that can be duplicated then ignores the rest within a cell or within a range of cells? For example, I am looking for the last word “Entered on 02/11/2008”, locate the next word “Entered”, ignore the remaining words and perform a count by name.

(In the sample below which is located in cell A1 only, there are 3 “Entered on 02/11/2008” but I am searching for the last one). After this word, it will find the next word “Entered” then disregard the remaining words. Finally, count the names (John should be 2 and Smith should be 1).

A1
Entered on 02/11/2008 at 15:12:12 by John:
Entered on 02/11/2008 at 15:12:15 by John:
Entered on 02/11/2008 at 14:22:44 by Smith:
Entered on 10/22/2007 at 10:47:04 by Lucy:

In cell A2, the count should be 2 for John
A2
Entered on 02/11/2008 at 15:12:12 by John:
Entered on 02/11/2008 at 15:12:15 by John:
Entered on 02/10/2008 at 14:22:44 by Smith:
Entered on 10/22/2007 at 10:47:04 by Lucy:

Please let me know if this is not clear.

Your help on this is appreciated!

STATSMAN

Hi guys,

I happened to come across a post on purchase order from excelforum.com and I am very delighted to see such a robust and practical PO.

Credit to Norman May for sharing such a good piece of work, however there is a question I would like to ask regarding the "History" sheet.

Is there a way to unrestrict the top most cells of the sheet, where it holds the label for the data? I would like to add/change the title accordingly. I have tried modifying the codes for it but it didn't work, it keeps gving the "The value you entered is not valid, a user has restricted the values that can be entered into this cell"

As attached is the Purchase Order.

Thanks alot in advance,
Faiz

Is there a way to define a name that can be used as a reference or variable? I have a sheet with my print forms on them. I also have account sheets for each month. I want the print form to take values from a defined month sheet, fill in the fields and then print it. Is there a way top define a constant or variable that can be used in a formula name? This is what I am trying to do.

Cell C9 on the print form imports data from =Jan!C4. I have 50 lines in column C and other columns on the Jan sheet that needs to be imported into the print form. How can I defined a constant or name such that I can use the syntax =PrintMonth!C4, where PrintMonth can be changed to point to the month I want to print. PrintMonth would be used in every column/row as a reference to the correct cell on the month sheets.

I tried to define a name PrintMonth that could be used as a variable but Excel turns that into ='Jan' which cannot be used as a variable in the sheet path to cell Jan!C4.

What am I missing or doesn't Excel have a concept of a variable in a formula path? I have hundreds of cells that I need to reference from the print form sheet. It would be insane to have to create a name for each cell. Or is this a job for a macro or VBA?

Thanks,
Barry

Hi guys,

How/where do I create a macro that can be used in any open workbook. I want to be able to run the macro on any workbook that is opened.

Thanks,
Julie